Unique Constraint Error at Step PO_POCREATE.PB4800.STEP06 While Running PO AutoSource(PO_AUTO_SRC)
(Doc ID 2238062.1)
Last updated on AUGUST 30, 2018
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
PO_AUTO_SRC process is running to No Success with Unique Constraint error
Automatic Purchasing Sourcing process (PO_AUTO_SRC) is running to No Success, when sourcing requisitions which have different Merchandise amounts, and "Amount Only" flag selected.
Process ABENDED at Step PO_POCREATE.PB4800.STEP06 (SQL) -- RC = 805 (108,524)
Steps to reproduce the issue:
Navigate to Main Menu > Purchasing > Requisitions > Add/Update Requisitions
1.Create a couple of Requisitions with different Merchandise Amounts, Supplier Information, and “Amount Only” flag selected.
2.Approve and Budget Check the requisitions.
3.Auto Source the Requisitions:
Navigate to Main Menu > Purchasing > Purchase Orders > Stage/Source Requests > PO Auto Sourcing
Select “Approved Requisitions” and provide Requisition ID From/To range
4.Process runs to “No Success” 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!