IJ34922: UNABLE TO APPROVE A CROSS-SITE INVOICE WITH A DUPLICATED/DECOMMISSIONED ASSET

APAR status

• Closed as program error.

Error description

• PROBLEM:
  Unable to approve a cross-site invoice with variance when the
  cost is charged against an asset that has the same number as a
  decommissioned asset in the invoice's site.
  
  STEPS TO REPRODUCE:
  - Use a vanilla Maximo environment with demo database and have
  default site set to BEDFORD ?
  
  1) Go to Assets > find asset 1001 in site BEDFORD, decommission
  it.
  
  2) Change the user?s Default Insert Site to FLEET.
  3) Create a new asset with the same number 1001 (in site FLEET)
  > change status to OPERATING.
  
  4) Create a new Purchase Order (in FLEET), add a PO line
  against the asset 1001, set Line Type to Material. Description:
  "Test Item". Set Line Cost to 200 - Approve the PO.
  5) Use the Receiving app to receive the PO Line.
  6) Set the user's Default Insert Site to BEDFORD > create a new
  Invoice (in BEDFORD) against the PO we created in step (4) >
  Copy the PO Line over to Invoice. Update the Line Cost field to
  220 - Change the Invoice status to Approve.
  
  RESULTS:
  Maximo will show an error: BMXAA2013E - Could not change invoice
  status to APPR. BMXAA0090E - Asset 1001 is not a valid asset, or
  its status is not an operating status.
  
  
  EXPECTED RESULTS:
  Invoice should be able to change status to Approved.
  Troubleshooting details:
  
  When there is a variance between Invoice Line and Receipt,
  Maximo will attempt to create an INVOICE transaction in the
  MATRECTRANS table. At this step, it looks at the Decommissioned
  Assetnum 1001 in site BEDFORD and thus gives us this error. It
  should be looking at Assetnum 1001 in site FLEET instead.
  
  
  REPORTED IN VERSION:
  Tivoli's process automation engine 7.6.1.2 (base)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Unable to approve a cross-site invoice with variance when    *
  * the cost is charged against an asset that has the same       *
  * number as a decommissioned asset in the invoice's site.      *
  ****************************************************************
  1) Go to Assets > find asset 1001 in site BEDFORD, decommission
  it.
  2) Change the user's Default Insert Site to FLEET.
  3) Create a new asset with the same number 1001 (in site FLEET)
  > change status to OPERATING.
  4) Create a new Purchase Order (in FLEET).
  5) Add a PO line against the asset 1001.
  6) Set Line Type to Material. Description: "Test Item".
  7) Set Line Cost to 200 - Approve the PO.
  8) Use the Receiving app to receive the PO Line.
  9) Set the user's Default Insert Site to BEDFORD.
  10) Create a new Invoice (in BEDFORD) against the PO we created
  in step (4).
  11) Copy the PO Line over to Invoice.
  12) Update the Line Cost field to 220.
  13) Change the Invoice status to Approve.
  RESULTS:
  Maximo will show an error: BMXAA2013E - Could not change invoice
  status to APPR. BMXAA0090E - Asset 1001 is not a valid asset, or
  its status is not an operating status.
  EXPECTED RESULTS:
  Invoice should be able to change status to Approved.
  Troubleshooting details:
  When there is a variance between Invoice Line and Receipt,
  Maximo will attempt to create an INVOICE transaction in the
  MATRECTRANS table. At this step, it looks at the Decommissioned
  Assetnum 1001 in site BEDFORD and thus gives us this error. It
  should be looking at Assetnum 1001 in site FLEET instead.
  

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