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

Last updated on APRIL 10, 2017

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

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