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.
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 .
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.
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