Buyer Mass Change Fails With "ORA-00001: unique constraint" Error and Abend at Step PO_CMCHGTRK.CT7100.Step02 if the Purchase Order (PO) Change has Prior Errors (Doc ID 2761062.1)

Last updated on MARCH 06, 2023

Applies to:

Symptoms

Buyer Mass Change fails with "ORA-00001: unique constraint" error and abend at Step PO_CMCHGTRK.CT7100.Step02 if the Purchase Order (PO) Change already has prior errors.

Steps

1) Create a PO (Purchase Orders > Add/Update PO) and dispatch it.(Note: PO should require acknowledgement and matching)

2) Create a voucher for this PO and match it

3) Submit a POA with changes using IB

4) Approve the Purchase Order Acknowledgement (POA)

5) Approve the POA

6) Run the PO_AUTO_CHNG process

7) Now review the PO change request from Purchase Orders -> Manage Change Orders -> Approve Change Requests.  The PO change went into error because a POA cannot modify a matching PO line (this is expected behavior)

8) Now for the same PO, change the buyer id using Buyer Mass Change.  The mass change process fails. This is because we already have an error record for this PO

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.