My Oracle Support Banner

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.

Symptoms


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.

Error:

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.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.