IJ36767: REPORTED LABOR HOURS FOR WOS WITH THE SAME NUMBER CREATED IN DIFFERENT SITES ARE VISIBLE IN ONE WO IN THE WORK EXECUTION WORK CE

APAR status

• Closed as program error.

Error description

• When trying to report work order's labor hours (by clicking on
  the Report Work button in Work Execution work center), There are
  visible other sites already reported labor hours as they have
  same WO number. So, report work function does not take site id
  into account when showing labor hour data.
  STEPS TO REPRODUCE:
  1.	Open the Work Order Tracking application and click to create
  a new work order
  2.	Fill in some information for the WO , e.g. Asset, take
  ownership,then save it
  3.	Change the status to APPR.
  4.	Click on Actuals tab
  5.	In sub-tab Labor click on New Row and fill in:
  a.	Labor: select a labor
  b.	Regular Hours:
  6.	Save and take a note of the WO
  7.	Open the Default information. Change the Default Insert Site:
  and Storeroom Site for Self-Service Requisitions: to a different
  site
  8.	In the Work Order Tracking application click to create a new
  WO
  9.	Change the number of the WO with the one created previously,
  noted at step 6.
  10.	Fill in some information for the WO , e.g. Asset, take
  ownership, then save it
  11.	Change the status to APPR.
  12.	Click on Actuals tab
  13.	In sub-tab Labor click on New Row and fill in:
  a.	Labor: select a labor
  b.	Regular Hours:
  14.	Open the Work Execution work order
  15.	If the user did not log off after changing the default
  information the work order noted at step 6 is displayed
  After relogging, the WO created in the second site is displayed,
  but in both cases when you click on Report Work , the labours
  reported for the 2 WOs with the same number are displayed
  RESULT:
  Reported labor hours in one site are visible in another site for
  a work order with the same number
  EXPECTED RESULT:
  Each site should see only reported labor hours from one site
  REPORTED IN VERSION:
  Tivoli's process automation engine 7.6.1.2
  

Local fix

• 1.Go to the Database Configuration application
  2.Filter for the WORKORDER object
  3.lick the Relationships tab
  4.Filter for the UXSHOWACTUALLABOR relationship
  5.Change the where clause to: refwo in (select wonum from
  workorder where (wonum=:wonum or (parent=:wonum and istask =
  :yes)) and siteid=:siteid ) and siteid=:siteid
  6.Save
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Reported labor hours in one site are visible in another site *
  * within Work Execution when the same Work Order number exists *
  * in multiple sites.                                           *
  ****************************************************************
  

Problem conclusion

• _The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 7.6.1.3 Product_
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels