Unique Constraint Error at Step PO_POCREATE.PB4800.STEP06 While Running PO AutoSource(PO_AUTO_SRC) (Doc ID 2238062.1)

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.

Symptoms

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.

ERROR
-----------------------
Process ABENDED at Step PO_POCREATE.PB4800.STEP06 (SQL) -- RC = 805 (108,524)

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

Cause

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