My Oracle Support Banner

Getting Unique Constraint Error While Running Auto Sourcing For Service Procurement Work Orders (Doc ID 2253556.1)

Last updated on OCTOBER 02, 2018

Applies to:

PeopleSoft Enterprise SCM Services Procurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Integration

Getting unique constraint error while running auto sourcing process for Service Procurement Work Orders having Contract information.


ERROR
-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PO_CNTRCT_L2T23) violated Failed SQL stmt: INSERT INTO PS_PO_CNTRCT_L2T23 (PROCESS_INSTANCE, BUSINESS_UNIT, PO_ID, LINE_NBR, S CHED_NBR, PO_STG_TYPE, ITM_SETID, INV_ITEM_ID, CNTRCT_SETID, CNTRCT_ID, VERSION_NBR, CNTRCT_LEVEL, C AT_LINE_NBR, CNTRCT_LINE_NBR, PO_DT, PRICE_SETID, PRICE_VENDOR, PRICE_LOC, PRICE_PO, CONVERSION_RATE , CURRENCY_CD, UNIT_OF_MEASURE, CNTRCT_RATE_DIV, CNTRCT_RATE_MULT, CNTRCT_SPEC_FLG, CONVERSION_RT_CN TR, CURRENCY_CD_CNTR, MERCHANDISE_AMT, MILESTONE_NBR, PRICE_CNTRCT_BASE, QTY_PO, QTY_PO_STD, RATE_DA TE, RT_TYPE, UNIT_MEASURE_CNTR, USE_CNTRCT_BASE) SELECT P.PROCESS_INSTANCE, P.BUSINESS_UNIT, P.PO_ID , P.LINE_NBR, P.SCHED_NBR, P.PO_STG_TYPE, P.ITM_SETID, P.INV_ITEM_ID, P.CNTRCT_SETID, P.CNTRCT_ID, P

The issue can be reproduced at will with the following steps:
1. Create a new contract and Populate required fields for contract categories.
2. Create a new sPro resource based req, Save and submit the req.
3. Create a second req that is deliverable based, Add 3 lines to the req.
4. After adding the 3 line go to the checkout page.
5. Page hangs and user is kicked out. Unable to create a multi line sPro requisition. This is not the issue reported by customer, but issue is preventing OSS from compleating the test.




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