My Oracle Support Banner

Autosource Process Abended at PO_CMPRICE.PR1100.UPDTPRC1 With Error"ORA-00001: unique constraint violation". (Doc ID 2879610.1)

Last updated on JUNE 27, 2022

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

PO_POcalc process which is part of auto sourcing abended at Step PO_CMPRICE.PR1100.UPDTPRC1 with below error



The issue can be reproduced at will with the following steps:
1. Create an open item reference general contract .Navigation: Main Menu-->procurement contracts.
2. Update one Item with the supplier from the contract in step-1.Navigation:Items-->Define Items and Attributes-->Define Item.
3. Create 2 ePro requisitions for the item and remove contract details from line details and approve.Navigation: eProcurement-->Create Requisition.
4. Run PO Auto Sourcing process for 2 requisitions .Navigation: Purchasing-->Purchase Orders-->Stage/Source Requests-->PO Auto Sourcing
5. 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!


In this Document
Symptoms
Changes
Cause
Solution
References


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