My Oracle Support Banner

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 JUNE 07, 2021

Applies to:

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

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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