PO_POCHNG Process Abended at PO_CMCHGTRK CT7000 CHNGHDR SQL (Doc ID 2002801.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to create a change order against a closed purchase order, the PO Change process fails with the following error.

ERROR:  Process 21106665 ABENDED at Step PO_CMCHGTRK.CT7000.CHNGHDR (Action SQL) -- RC = 805



The issue can be reproduced at will with the following steps:

  1. Enabled POA Change Requests for Vendor = SCM0000001.
  2. Setup PURCHASE_ORDER_ACKNOWLEDGEMENTS
  3. Created a purchase order (TEST_POA2) for quantity 10 of item = 10030.
  4. Dispatched the PO.
  5. From the Handler Tester page, I provided an XML text that changes the Price
  6. from 87.00 to 90.00. (file = TEST_POA2.txt)
  7. Executed the file.
  8. From Manage Acknowledgements - Acknowledged the change and added text in the
  9. Vendor Item ID field.
  10. Approved.
  11. Run PO Change Load.
  12. The Change Order is pre-approved.
  13. Ran the Process Change Orders.  This goes to success.
  14. Dispatched the PO.
  15. Processed another XML Change Order from the Handler Tester page, I provided
  16. an XML text that changes quantity from 10 to 3. (file = TEST_POA2.txt)
  17. Executed the file.
  18. From Manage Acknowledgements - Acknowledged the change and added text in the
  19. Vendor Item ID field.
  20. Approved.
  21. Run PO Change Load.
  22. From the Buyers Workbench - Closed the purchase order.
  23. Ran the Process Change Orders  This goes to No Success.




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms