PO_POCHNG failed due to duplicate insert on PO Status (Doc ID 1597781.1)

Last updated on JUNE 09, 2017

Applies to:

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

Symptoms

PO_POCHNG failed due to duplicate insert on PO Status. It happens when eProcurement Requisition is in PO Dispatched status.  Change Request is entered and pending with approver.  Meanwhile, Buyer cancels either PO line and/or PO.  Approver  approves change request.  PO_POCHNG runs to No Success with SQL error on duplicate  row insert from PS_PO_CHG_HDR_T4 and PS_PO_CHGRSN_T4 tables.  

Error Message
-------------
ORA-00001: unique constraint
Failed SQL stmt:INSERT INTO PS_PO_CHNG_HDR


Process Abended at Step PO_CMCHGTRK.CT7000.CHNGHDR (SQL) --RC = 805

REPLICATION STEPS
=================


1. Create a new eProcurement requisition for a Special request Item

2. Save and Submit.

3. Source it to PO using PO Auto Sourcing

4. Check the SOurcing Workbench. PO is created in Approved status

5. Dispatch the PO

6. Edit the Requisition

7. Change the price from say 100 to 150

8. Save and Submit

9. Change request is created

10. Approve the change request

11. Cancel the PO. Select the Option ,"No, Do Not Re-Source Reqs" while Cancelling the PO

12. Click on Continue. Click on OK

13. Dispatch the PO

14. Run the change PO process which is Process Change Order

15. The PO_POCHNG process runs in NO success when there is a price change. Status shows as No Success and Posted

16. PO_POCHNG failed due to duplicate insert on PO Status













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