EPO: Purchase Order Change Order (PO_POCHNG) Process Fails at Step PO_CMCHNG.PC7100.GETGPO With Unique Constraint Error ORA-00001 When Using Items That Have Multiple GPO Contracts Associated With Them (Doc ID 2691455.1)

Last updated on SEPTEMBER 30, 2024

Applies to:

Symptoms

When an item has multiple GPO contracts linked to it, Purchase Order Change Order (PO_POCHNG) process fails with the following unique constraint error at the step PO_CMCHNG.PC7100.GETGPO:

Steps to Reproduce the Issue:

1. Create two GPO contracts.
2. Open an item and click on the Manufacturers link.
3. Click on GPO Pricing link and select the GPO contracts created.
4. Create a PO, add the item. Then save the PO.
5. Create a new GPO contract.
6. Associate the GPO contract with the item.
7. Dispatch the PO.
8. Change the buyer on the PO to generate a change request.
9. Process the change.

Changes

 N/A

Cause

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