IJ30969: THE MULTIASSETLOCCI OBJECT IS NOT POPULATED CORRECTLY WHEN GENERATING A WORK ORDER.

APAR status

• Closed as program error.

Error description

• Location has a single 'Linear' Asset linked to it, the Work
  Order is generated/created but the MULTIASSETLOCCI object is
  not populated
  
  STEPS TO REPRODUCE:
  
  1st Scenario:
  
  1. Create a
  new location
  Location: LOC01
  Description: Location 1? For
  Non-Linear Asset
  Associate with Primary System
  Change status to
  ?Operating?
  
  2. Create another new location
  Location:
  LOC02
  Description: Location 2? For Linear Asset
  Associate with
  Primary System
  Change status to ?Operating?
  
  3. Create a new
  asset
  Asset: ASSET01
  Description: Asset 1 ? A Non-Linear
  Asset
  Associate Asset 1 to Location LOC01
  Change status to
  Operating?
  
  4. Create a new asset
  Asset: ASSET02
  Description:
  Asset 2 ? A Linear Asset
  Associate Asset 2 to Location
  LOC02
  Mark ?Is-Linear? flag check box
  Add Start and End
  measures with a LRM value.
  Change status to Operating?
  
  5.
  Create a new PM
  PM Num: PMLOC01
  Description: PM for Location
  1
  Location LOC01
  Work Order status: APPR
  Frequency: 1
  Frequency
  Units: WEEKS
  Next Date: Today?s Date
  Save and change status to
  ?Active?
  
  6. Create another PM
  PM Num: PMLOC02
  Description: PM
  for Location 2
  Location LOC02
  Work Order status:
  APPR
  Frequency: 1
  Frequency Units: WEEKS
  Next Date: Today?s
  Date
  Save and change status to ?Active?
  
  PM Work Order
  Generation
  7. Open PM PMLOC01
  Select ?Generate Work Orders?
  from the PM Action menu.
  If using Frequency Criteria option,
  the ?Generate WOs Due Today Plus This Number of Days? enter a
  number, say 14
  Click OK to generate
  Take note of Work Order
  numbers
  
  8. Repeat above for PM PMLOC02.
  
  PM PMLOC01 created
  work order 1487.
  PM PMLOC01 created work order 1489.
  PM PMLOC01
  created work order 1490.
  
  PM PMLOC02 created work order
  1491.
  PM PMLOC02 created work order 1492.
  PM PMLOC02 created
  work order 1493.
  
  9. Query MULTIASSETLOCCI Object ? SQL 1
  Query
  MULTIASSETLOCCI object to see if records exist for the
  generated Work Orders:
  
  select * from MULTIASSETLOCCI where
  recordkey in ('1487', '1489', '1490', '1491', '1492',
  '1493');
  
  EXPECTED RESULTS: The results should also show the
  LOC02 location with corresponding MULTIASSETLOCCI
  entries
  
  RESULTS: Results will show that only Location LOC01
  with a Non-Linear asset will have corresponding MULTIASSETLOCCI
  entries
  
  ========
  2nd Scenario:
  
  Create a Work Order Manually
  1
  1. Click Add Work Order in the Work Tracking Application
  2.
  Enter Location LOC01 into the Location Field and hit Enter.
  ----> LOC01 1494
  3. The Asset linked to the Location is then
  populated into the Asset Field.
  4. Save the record at this
  point.
  5. Repeat the above for LOC02 ---> LOC02 1495
  
  6. Query
  MULTIASSETLOCCI Object ? SQL 2
  Query MULTIASSETLOCCI object to
  see if records exist for the manually created Work
  Orders
  
  select * from MULTIASSETLOCCI where recordkey in
  ('1494', '1495');
  
  EXPECTED RESULTS: The results should also
  show the LOC02 location with corresponding MULTIASSETLOCCI
  entries
  
  RESULTS: Results will show that only Location LOC01
  with a Non-Linear asset will have corresponding MULTIASSETLOCCI
  entries
  
  REPORTED IN VERSION:
  
  Version of Maximo: IBM Maximo
  Asset Management 7.6.1.2
  Application within Maximo: Work Order
  Tracking
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo Linear users                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * THE PRIMARY MULTIASSETLOCCI OBJECT IS NOT CREATED WHEN       *
  * GENERATING A WORK ORDER FROM A LOCATION-BASED PM THAT HAS A  *
  * SINGLE ASSET THAT IS LINEAR.                                 *
  ****************************************************************
  Location has a single Linear Asset linked to it, the Work Order
  is generated/created but the MULTIASSETLOCCI object is not
  populated
   STEPS TO REPRODUCE:
   1st Scenario: PM Work Order Generation
   1. Create a new location.
   Location: LOC01
   Description: Location 1 For Non-Linear Asset
   Associate with Primary System.
   Change status to Operating.
   2. Create another new location.
   Location: LOC02
   Description: Location 2 For Linear Asset
   Associate with Primary System.
   Change status to Operating.
   3. Create a new asset.
   Asset: ASSET01
   Description: Asset 1 - Non-Linear
   Associate ASSET01 to Location LOC01.
   Change status to Operating.
   4. Create another new asset
   Asset: ASSET02
   Description: Asset 2 - Linear
   Associate ASSET02 to Location LOC02.
   Mark Is-Linear? flag check box.
   Add Start and End measures and an LRM value.
   Change status to Operating.
   5. Create a new PM.
   PM Num: PMLOC01
   Description: PM for LOC01
   Location: LOC01
   Work Order status: APPR
   Frequency: 1
   Frequency Units: WEEKS
   Next Date: Today's Date
   Save and change status to Active.
   6. Create another new PM.
   PM Num: PMLOC02
   Description: PM for LOC02
   Location: LOC02
   Work Order status: APPR
   Frequency: 1
   Frequency Units: WEEKS
   Next Date: Today's Date
   Save and change status to Active.
   7. Open PM PMLOC01
   Select 'Generate Work Orders' from the PM Action menu.
   Click OK to generate.
   Take note of Work Order numbers.
   8. Repeat above for PM PMLOC02.
   9. Query MULTIASSETLOCCI Object MULTIASSETLOCCI object to see
  if records exist for the
   generated Work Orders: select * from MULTIASSETLOCCI where
  recordkey in (<List WONUMs noted above in Steps 7 and 8>);
   EXPECTED RESULTS: The results should also show the LOC02
  location with corresponding MULTIASSETLOCCI entries.
   RESULTS: Results will show that ONLY Location LOC01 with a
  Non-Linear asset will have corresponding primary
  MULTIASSETLOCCI.
   ========
   2nd Scenario: Create a Work Order Manually
   1. Click Add Work Order in the Work Tracking Application.
   2. Enter Location LOC01 into the Location Field and hit Enter.
   3. The Asset linked to the Location is then populated into the
  Asset Field.
   4. Save the record.
   5. Create another work order for Location LOC02 following steps
  1 to 4 above.
   6. Query MULTIASSETLOCCI Object to see if records exist for the
  manually created Work Orders: select * from MULTIASSETLOCCI
  where recordkey in (<List WONUMs created in Steps 1 to 5>);
   EXPECTED RESULTS: The results should also show the LOC02
  location with corresponding MULTIASSETLOCCI entries.
   RESULTS: Results will show that ONLY Location LOC01 with a
  Non-Linear asset will have corresponding primary
  MULTIASSETLOCCI.
   REPORTED IN VERSION:
   Version of Maximo: IBM Maximo
   Asset Management 7.6.1.2
   Application within Maximo: Work Order Tracking
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  Release 7.6.1.3 of Base Services
  

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