Unique Constraint Error at Step PO_POCREATE.PB4800.STEP06 While Running PO AutoSource(PO_AUTO_SRC)
Last updated on MARCH 20, 2017
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On : 9.2 version, Stage/Source Requests
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)
The issue can be reproduced at will with the following steps:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms