IZ74685: COSTS ON THE WORK ORDER ARE NOT ROLLING UP TO THE PARENT VIEW COSTS.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Maximo 6.2.5
    
    Steps to replicate:
    
    Created WO 1147, location = BR230, job plan = JP11210, SAVE,
    APPR
    Created WO 1149, location = BR 230, job plan = JP1000, entered
    Parent WO = 1147, SAVE, APPR
    Created PO 1069, enter the vendor, clicked on PO Lines tab, Line
    Type = Service, Work Order = 1149, WO task = 30, quantity = 20,
    Order Unit = HOURS, Unit Cost = 25.00, SAVE, added GL account
    Added a second line, Line Type = Service, Work Order = 1149, WO
    task = 30, quantity = 35, Order Unit = HOURS, Unit Cost = 30.00,
    added GL account, SAVE and APPR PO
    GoTo Receiving, PO = 1069, clicked on the Service Receipts tab,
    clicked on Select Ordered Services button, selected the 2
    service lines and SAVE record
    GoTo Work Order Tracking, brought up the WO 1149, Select
    Action/View Costs and the Work Order Totals and Grand Hierarchy
    Totals are displayed
    Brought up the parent WO 1147, Select Action/View Costs and the
    Work Order Totals and Grand Hierarchy Totals are displayed
    
    
    Information from the client
    
    Most of the client's construction workorders the Workorder
    Select action View Costs is not correct.  To verify they have
    taken the results from the WO/Actuals/Materials numbers and
    downloaded them all and they add up to more than the Workorder
    Select action View Costs numbers.  They have also verified the
    numbers with sql queries and the sql numbers match the
    downloaded numbers exactly line by line.  This variance comes in
    Services and Materials.
    
    Maximo version 6.2.5; app server os: windows server 2003 SP2;
    database: Oracle 10g; db server os: windows server 2003 SP2;
    report server os: windows server 2003 SP2;
    The view costs from workorder (WO) 1074964 from the front end of
    MXES. Totals do not match the detail from the WO Actuals tab for
    both Services and Materials.
    Services MXES View Cost = $25,460.13
    Services Details Tab = $28,967.35
    Materials MXES View Cost = $114,789.55
    Materials Details Tab = $116,615.53
    For this project the difference in the services matches exactly
    the amount of service charges on Children workorders. The same
    CANNOT be said for Materials - that difference does not match.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Workorder users                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: Maximo 6.2.5                            *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      Steps to replicate:                     *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      Created WO 1147, location = BR230, job  *
    *                      plan = JP11210, SAVE,                   *
    *                                                              *
    *                      APPR                                    *
    *                                                              *
    *                      Created WO 1149, location = BR 230, job *
    *                      plan = JP1000, entered                  *
    *                                                              *
    *                      Parent WO = 1147, SAVE, APPR            *
    *                                                              *
    *                      Created PO 1069, enter the vendor,      *
    *                      clicked on PO Lines tab, Line           *
    *                                                              *
    *                      Type = Service, Work Order = 1149, WO   *
    *                      task = 30, quantity = 20,               *
    *                                                              *
    *                      Order Unit = HOURS, Unit Cost = 25.00,  *
    *                      SAVE, added GL account                  *
    *                                                              *
    *                      Added a second line, Line Type =        *
    *                      Service, Work Order = 1149, WO          *
    *                                                              *
    *                      task = 30, quantity = 35, Order Unit =  *
    *                      HOURS, Unit Cost = 30.00,               *
    *                                                              *
    *                      added GL account, SAVE and APPR PO      *
    *                                                              *
    *                      GoTo Receiving, PO = 1069, clicked on   *
    *                      the Service Receipts tab,               *
    *                                                              *
    *                      clicked on Select Ordered Services      *
    *                      button, selected the 2                  *
    *                                                              *
    *                      service lines and SAVE record           *
    *                                                              *
    *                      GoTo Work Order Tracking, brought up    *
    *                      the WO 1149, Select                     *
    *                                                              *
    *                      Action/View Costs and the Work Order    *
    *                      Totals and Grand Hierarchy              *
    *                                                              *
    *                      Totals are displayed                    *
    *                                                              *
    *                      Brought up the parent WO 1147, Select   *
    *                      Action/View Costs and the               *
    *                                                              *
    *                      Work Order Totals and Grand Hierarchy   *
    *                      Totals are displayed                    *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      Information from the client             *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      Most of the client's construction       *
    *                      workorders the Workorder                *
    *                                                              *
    *                      Select action View Costs is not         *
    *                      correct.  To verify they have           *
    *                                                              *
    *                      taken the results from the              *
    *                      WO/Actuals/Materials numbers and        *
    *                                                              *
    *                      downloaded them all and they add up to  *
    *                      more than the Workorder                 *
    *                                                              *
    *                      Select action View Costs numbers.  They *
    *                      have also verified the                  *
    *                                                              *
    *                      numbers with sql queries and the sql    *
    *                      numbers match the                       *
    *                                                              *
    *                      downloaded numbers exactly line by      *
    *                      line.  This variance comes in           *
    *                                                              *
    *                      Services and Materials.                 *
    *                                                              *
    *                      Maximo version 6.2.5; app server os:    *
    *                      windows server 2003 SP2;                *
    *                                                              *
    *                      database: Oracle 10g; db server os:     *
    *                      windows server 2003 SP2;                *
    *                                                              *
    *                      report server os: windows server 2003   *
    *                      SP2;                                    *
    *                                                              *
    *                      The view costs from workorder (WO)      *
    *                      1074964 from the front end of           *
    *                                                              *
    *                      MXES. Totals do not match the detail    *
    *                      from the WO Actuals tab for             *
    *                                                              *
    *                      both Services and Materials.            *
    *                                                              *
    *                      Services MXES View Cost = $25,460.13    *
    *                                                              *
    *                      Services Details Tab = $28,967.35       *
    *                                                              *
    *                      Materials MXES View Cost = $114,789.55  *
    *                                                              *
    *                      Materials Details Tab = $116,615.53     *
    *                                                              *
    *                      For this project the difference in the  *
    *                      services matches exactly                *
    *                                                              *
    *                      the amount of service charges on        *
    *                      Children workorders. The same           *
    *                                                              *
    *                      CANNOT be said for Materials - that     *
    *                      difference does not match.              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      Please attachments from the client      *
    *                      regarding this issue.                   *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      Also Qiuping has sent some queries that *
    *                      the client has performed - please see   *
    *                      PMR 26114,49R,000 in the Issues         *
    *                      Database                                *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      LOCAL FIX:                              *
    *                                                              *
    *                      none                                    *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    ****************************************************************
    COSTS ON THE WORK ORDER ARE NOT ROLLING UP TO THE PARENT VIEW
    COSTS.
    

Problem conclusion

  • Works correctly in Rel 6.2.6
    
    
    
    
    
    The fix for this APAR is contained in the following maintenance
    package:
    
      | release\fix pack | REL 6.2.6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ74685

  • Reported component name

    WORK ORDER TRAC

  • Reported component ID

    5724R46WO

  • Reported release

    621

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-04-15

  • Closed date

    2010-05-07

  • Last modified date

    2010-05-07

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • MAXIMO
    

Fix information

  • Fixed component name

    WORK ORDER TRAC

  • Fixed component ID

    5724R46WO

Applicable component levels

  • R621 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Asset Management
Work Order Tracking

Software version:

621

Reference #:

IZ74685

Modified date:

2010-05-07

Translate my page

Machine Translation

Content navigation