Change Purchase Orders process (PO_POCHNG) Failed with Error "ORA-00001: unique constraint (PS_PO_CHNG_HDR) violated Failed SQL" at Step PO_CMCHGTRK.CT7000.CHNGHDR2 (Doc ID 2840604.1)

Last updated on MARCH 01, 2024

Applies to:

Symptoms

Change Purchase Orders (PO_POCHNG) process Failed with Error "ORA-00001: unique constraint (PS_PO_CHNG_HDR) violated Failed SQL" at Step PO_CMCHGTRK.CT7000.CHNGHDR2

The issue can be reproduced at will with the following steps:
     1. Navigate : Purchasing > Purchase Orders > Add/Update POs
          Create Purchase Order with an item for Supplier USA0000011
          POA Status : Awaiting PO Dispatch
          Click Header Details
          Acknowledgements required for : initial dispatch Only
          Save (PO ID : 0000000462)
     2. Navigate : Purchasing > Purchase Orders > Add/Update POs
          Create Purchase Order with an item for Supplier SCM0000001 (PO ID : 0000000463)
     3. Navigate : Purchasing > Purchase Orders > Add/Update POs
          Create Purchase Order with an item for Supplier SCM0000001 (PO ID : 0000000466)
          Dispatch it
     4. Navigate : Purchasing > Purchase Orders > Add/Update POs
          Create Purchase Order with an item for Supplier SCM0000001 (PO ID : 0000000467)
          Dispatch it
     5. Navigation: Purchasing > Purchase Orders > Manage Change Orders > Buyer Mass Change
          Select a combination of approved and dispatched POs and run the process 
          Select PO IDs 462, 463, 466 & 467
          Click Process Change
          Click Yes for “Would you like to wait until the PO Change process is completed? (10208,88)”
          Purchase Orders have been updated successfully. The process instance number is 250665 (10208,89)
          PO_POCHNG Process completed
     6. Run the Query
          select * from PS_PO_CHNG_HDR where business_uniT='US001' AND PO_ID in('0000000462','0000000463','0000000466','0000000467') order by PO_ID asc;
          Data added for all these four purchase orders
     7. Navigate : Purchasing > Purchase Orders > Add/Update POs
          Open Approved PO 0000000462
          Dispatch it
          Click Awaiting Acknowledgement
     8. Click Line Number
          Change Acknowledge Due Date (01/12/2022 )and Qty (3)
          Click Return
          Click Run PO Auto Change (PO_AUTO_CHNG)
          Click Save & Approve
     9. PO_AUTO_CHNG process is completed
     10. Navigate : Purchasing > Purchase Orders > Manage Change Orders > Approve Change Requests
          Search PO ID : US001-0000000462
          Select Approved for Change order Source EDX
          Click Reviewed
          Save
     11.Navigate : Purchasing > Purchase Orders > Manage Change Oders > Process Change Orders
          Enter Source : PO Acknowledgements
          Business Unit : US001
          PO ID : 0000000462
          Click Run the process PO_POCHNG
          Issue : Process Failed

Changes

Cause

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