My Oracle Support Banner

Purchase Order Auto Source Process Abended at Step PO_CMPRICE.PR1000.GETELPO With Unique Constraint Error. (Doc ID 2709033.1)

Last updated on OCTOBER 14, 2021

Applies to:

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

Symptoms

Auto Sourcing process abend's with unique constraint error when processing 2 requisitions with same INV_ITEM_ID and SHIPTO_ID but with a different LOCATION_ID and DEPTID .

Error-

The issue can be reproduced at will with the following steps:
1.Create 2 Requisitions with same INV_ITEM_ID and SHIPTO_ID but with different LOCATION_ID and DEPTID .
2.Auto Source should consolidate the two staged requisition lines onto the same PO_ID and LINE_NBR but onto two different schedules and/or distribution records.
3.Run Auto sourcing process for the 2 requisitions.
4.Process will abend with unique constraint error.

Changes

 

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.