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

Last updated on MARCH 06, 2023

Applies to:

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 = A.
2. Setup PURCHASE_ORDER_ACKNOWLEDGEMENTS
3. Created a purchase order (TEST_POA2) for quantity 10 of item = xx.
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.
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.