IJ30790: CROSS-ORG/SITE ITEMSET CONFLICT WHILE APPROVING SERVICE ITEM INVOICES USING WORKFLOW, ESCALATION AND CRONTASK

APAR status

• Closed as program error.

Error description

• In this scenario, please consider:
  
  Organization: EAGLENA
  Item Set: SET1
  Company Set: COMPSET1
  Site: BEDFORD (MAXADMIN's Default Insert Site)
  
  Organization: EAGLESA
  Item Set: SET2
  Company Set: COMPSET1
  Site: CHILEHDQ
  
  STEPS TO REPRODUCE:
  
  1. Go to Users application.
  
  2. Create a User named AUTOACCEPT, replying Yes to the system
  message "BMXAA3844W - Person AUTOACCEPT does not exist. Do you
  want to create a new person?"
  
  3. Go to Workflow Designer application.
  
  4. Create a Process with just 04 nodes (START > CONDITION > TASK
  > STOP) as the following:
  
  Process: APPR-INV
  Description: Approve Invoice
  Object: INVOICE
  
  Condition node properties:
  Title: WAPPR?
  Expression: STATUS='WAPPR'
  
  Task node properties:
  Title: APPROVE
  Assignments > New Row > Role ID: AUTOACCEPT
  Time Limit: 1:00
  
  TASK to STOP Action properties:
  Action: INV APPR (Invoice Approve Action)
  
  5. Validate, enable and activate the Process.
  
  6. From More Actions menu, select Add Workflow to Applications.
  
  7. In Add Workflow to Applications dialog, select the "Add
  Support?" check-box for Invoice application and click OK.
  
  8. From More Actions menu, select Set Process to Auto-Initiate.
  
  9. Go to Actions application.
  
  10. Create an Action as the following:
  Action: WFACCEPT
  Description: Auto-Accept Workflow Tasks
  Object: WFASSIGNMENT
  Type: Application Action
  Value: WFACCEPT
  Accessible From: ALL
  
  11. Go to Escalations application.
  
  12. Create an Escalation as the following:
  Applies To: WFASSIGNMENT
  Condition: ASSIGNCODE='AUTOACCEPT' AND ASSIGNSTATUS='ACTIVE' AND
  PROCESSNAME='APPR-INV'
  Schedule: every 2 minutes
  Escalation Point 1, Repeat: Yes
  Action: WFACCEPT
  
  13. Save, validate, activate the Escalation and take note of its
  number.
  
  14. Go to Cron Task Setup application.
  
  15. Bring up ESCALATION Cron Task.
  
  16. Filter the Cron Task Instances by the Escalation number
  created above.
  
  17. Go to History tab and check if the Escalation is running
  properly every 2 minutes.
  
  18. Login to Maximo as wilson.
  
  19. Set the Default Insert Site as CHILEHDQ.
  Note: CHILEHDQ Site is from EAGLESA Organization, whose Item Set
  is SET2.
  
  20. Go to Service Items application.
  
  21. Create the Service Item FREIGHT.
  
  22. Save the record and change the Status to ACTIVE, selecting
  the option "Roll New Status to Organizations?".
  
  23. Go to Purchase Orders application.
  
  24. Create a new PO against any valid Vendor with just 01 PO
  Line as the following:
  Line Type: Service
  Description: Testing
  Quantity: 1.00
  Unit Cost: 1.00
  GL Debit Account: any valid GL Account
  
  25. Save, approve PO and take note of its number.
  
  26. Go to Invoices application.
  
  27. Create an Invoice associated to the PO above and save it.
  
  28. Go to Invoice Lines tab, click on New Row button, enter the
  following info:
  Line Type: Standard Service
  Item: FREIGHT
  Quantity: 1.00
  Unit Cost: 1.00
  GL Debit Account: any valid GL Account
  
  29. Save the Invoice, change the Status to WAPPR and Route
  Workflow.
  
  30. Wait for the Escalation runs.
  
  RESULTS:
  The Invoice does not get approve.
  There is no error in the UI, but the SystemOut log displays the
  error below:
  "BMXAA2013E - Could not change invoice XXXX status to APPR.
  BMXAA3782E - The item set identifier is not valid."
  
  EXPECTED RESULTS:
  The Invoice should get approve.
  
  REPORTED IN VERSION:
  IBM Maximo Asset Management 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * CROSS-ORG/SITE ITEMSET CONFLICT WHILE APPROVING SERVICE ITEM *
  * INVOICES USING WORKFLOW, ESCALATION AND CRONTASK             *
  ****************************************************************
  h4. Description
  In this scenario, please consider:
   Organization: EAGLENA
   Item Set: SET1
   Company Set: COMPSET1
   Site: BEDFORD (MAXADMIN's Default Insert Site)
   Organization: EAGLESA
   Item Set: SET2
   Company Set: COMPSET1
   Site: CHILEHDQ
   STEPS TO REPRODUCE:
   1. Go to Users application.
   2. Create a User named AUTOACCEPT, replying Yes to the system
   message "BMXAA3844W - Person AUTOACCEPT does not exist. Do you
   want to create a new person?"
   3. Go to Workflow Designer application.
   4. Create a Process with just 04 nodes (START > CONDITION >
  TASK
   > STOP) as the following:
   Process: APPR-INV
   Description: Approve Invoice
   Object: INVOICE
   Condition node properties:
   Title: WAPPR?
   Expression: STATUS='WAPPR'
   Task node properties:
   Title: APPROVE
   Assignments > New Row > Role ID: AUTOACCEPT
   Time Limit: 1:00
   TASK to STOP Action properties:
   Action: INV APPR (Invoice Approve Action)
   5. Validate, enable and activate the Process.
   6. From More Actions menu, select Add Workflow to
  Applications.
   7. In Add Workflow to Applications dialog, select the "Add
   Support?" check-box for Invoice application and click OK.
   8. From More Actions menu, select Set Process to
  Auto-Initiate.
   9. Go to Actions application.
   10. Create an Action as the following:
   Action: WFACCEPT
   Description: Auto-Accept Workflow Tasks
   Object: WFASSIGNMENT
   Type: Application Action
   Value: WFACCEPT
   Accessible From: ALL
   11. Go to Escalations application.
   12. Create an Escalation as the following:
   Applies To: WFASSIGNMENT
   Condition: ASSIGNCODE='AUTOACCEPT' AND ASSIGNSTATUS='ACTIVE'
  AND
   PROCESSNAME='APPR-INV'
   Schedule: every 2 minutes
   Escalation Point 1, Repeat: Yes
   Action: WFACCEPT
   13. Save, validate, activate the Escalation and take note of
  its
   number.
   14. Go to Cron Task Setup application.
   15. Bring up ESCALATION Cron Task.
   16. Filter the Cron Task Instances by the Escalation number
   created above.
   17. Go to History tab and check if the Escalation is running
   properly every 2 minutes.
   18. Login to Maximo as wilson.
   19. Set the Default Insert Site as CHILEHDQ.
   Note: CHILEHDQ Site is from EAGLESA Organization, whose Item
  Set
   is SET2.
   20. Go to Service Items application.
   21. Create the Service Item FREIGHT.
   22. Save the record and change the Status to ACTIVE, selecting
   the option "Roll New Status to Organizations?".
   23. Go to Purchase Orders application.
   24. Create a new PO against any valid Vendor with just 01 PO
   Line as the following:
   Line Type: Service
   Description: Testing
   Quantity: 1.00
   Unit Cost: 1.00
   GL Debit Account: any valid GL Account
   25. Save, approve PO and take note of its number.
   26. Go to Invoices application.
   27. Create an Invoice associated to the PO above and save it.
   28. Go to Invoice Lines tab, click on New Row button, enter
  the
   following info:
   Line Type: Standard Service
   Item: FREIGHT
   Quantity: 1.00
   Unit Cost: 1.00
   GL Debit Account: any valid GL Account
   29. Save the Invoice, change the Status to WAPPR and Route
   Workflow.
   30. Wait for the Escalation runs.
   RESULTS:
   The Invoice does not get approve.
   There is no error in the UI, but the SystemOut log displays
  the
   error below:
   "BMXAA2013E - Could not change invoice XXXX status to APPR.
   BMXAA3782E - The item set identifier is not valid."
   EXPECTED RESULTS:
   The Invoice should get approve.
   REPORTED IN VERSION:
   IBM Maximo Asset Management 7.6.1.2
  

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:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  PURCHASING

• Fixed component ID

  5724R46PU

Applicable component levels