ABENDED At Step PO_CMCHNG.PC8700.ISRTCNLW (SQL) (Doc ID 2075988.1)

Last updated on JUNE 12, 2017

Applies to:

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

Symptoms

ABENDED at Step PO_CMCHNG.PC8700.ISRTCNLW (SQL)  

PO_AUTO_CHNG and PO_POCHNG processes abends at PO_CMCHNG.PC8700.ISRTCNLW (SQL) when multiple POs associated with multiple versions have change orders to Process.



PeopleTools 8.54.10 - Application Engine Server
Copyright (c) 1988-2015 Oracle and/or its affiliates.
All Rights Reserved


PSAESRV started service request at 11.21.08 2015-06-24


File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703  Error Position: 0  Return: 805 - ORA-00001: unique constraint (SYSADM.PS_CNTRCT_LINE_T4) violated
Failed SQL stmt: INSERT INTO PS_CNTRCT_LINE_T4 (PROCESS_INSTANCE, SETID, CNTRCT_ID, VERSION_N

ERROR
PeopleTools
8.54.10 - Application Engine Server
Copyright
(c) 1988-2015 Oracle and/or its affiliates.
All
Rights Reserved
 
 
PSAESRV
started service request at 11.21.08 2015-06-24
 
 
File:
/vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703  Error Position: 0  Return: 805 - ORA-00001: unique constraint
(SYSADM.PS_CNTRCT_LINE_T4) violated
Failed
SQL stmt: INSERT INTO PS_CNTRCT_LINE_T4 (PROCESS_INSTANCE, SETID, CNTRCT_ID,
VERSION_NBR, CNTRCT_LINE_NBR, LINE_STATUS, ITM_SETID, INV_ITEM_ID, DESCR254_MIXED,
ITM_ID_VNDR, VNDR_CATALOG_ID, CATEGORY_ID, MFG_ID, QTY_LINE_MIN, QTY_LINE_MAX,
QTY_LINE_RELEASED, AMT_LINE_MIN, AMT_LINE_MAX, AMT_LINE_RELEASED,
INCLUDE_FOR_RELS, LINE_PRICE_TYPE, USE_CNTRCT_BASE, PRICE_UOM_ADJ,
PRICE_SHIPTO_ADJ, ADJ_BEFORE, QTY_TYPE, PRICE_DT_TYPE, PRICE_CAN_CHANGE,
UNIT_OF_MEASURE, MERCHANDISE_AMT, TOTAL_DISTRIBS, MAX_DISTRIB_LINE,
STATISTIC_AMOUNT, UNIT_PRICE, TAX_CD, DSCNT_APPL_FLG, FRGHT_PRORATE_FLG,
CURRENCY_CD, RFQ_ID, RFQ_LINE_NBR, VAT_RECOVERY_PCT, WTHD_SETID, WTHD_SW, WTHD_CD,
SHIPTO_ID, SUT_BASE_ID, TAX_CD_SUT, SUT_EXCPTN_TYPE, SUT_EXCPTN_CERTIF,
SUT_APPLICABILITY, AMT_ONLY_FLG, RETENTION_CD, RETENTION_PCT, RETENTION_AMT,
MFG_ITM_ID, ULTIMATE_USE_CD, USER_LINE_CHAR1, CUSTOM_C100_B1, CUSTOM_C100_B2,
CUSTOM_C100_B3, CUSTOM_C100_B4, CUSTOM_DATE_B, CUSTOM_C1_B) SELECT
W.PROCESS_INSTANCE, R.SETID, R.CNTRCT_ID, 0, R.CNTRCT_LINE_NBR, 'O', ' ', ' ',
' ', ' ', ' ', ' ', ' ', 0, 0, ROUND(R.QTY_LINE_RELEASED -
W.QTY_WRK_LINE_OTHMN, 2), 0, 0, R.AMT_LINE_RELEASED - W.AMT_WRK_LINE_OTHMN, 'Y',
' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', 0, 0, 0, 0, 0, ' ', ' ', ' ',
R.CURRENCY_CD, ' ', 0, 0, ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '
', 0, 0, ' ', ' ', ' ', ' ', ' ', ' ', ' ', NULL, ' ' FROM PS_PO_CNT_SUM_T4 W,
PS_CNTRCT_LIN_RLS R WHERE W.PROCESS_INSTANCE = 360811 AND W.CNTRCT_LINE_NBR
> 0 AND R.SETID = W.CNTRCT_SETID AND R.CNTRCT_ID = W.CNTRCT_ID AND
R.CNTRCT_LINE_NBR = W.CNTRCT_LINE_NBR
 
Process
360811 ABENDED at Step PO_CMCHNG.PC8700.ISRTCNLW (SQL) -- RC = 805 (108,524)
 
Process
%s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
 
PSAESRV
completed service request at 11.21.40 2015-06-24

Below are replication steps

1. Create a new Contract Process Option Purchase Order
2. Add the PO Defaults for the Contract
3. Add the Item Id over the Contract and Mark the Contract to Approved
4. Create a new requisition for the Contract Item Id
5. Created a req line with qty 5 for the ITEM ID that has UOM as BOX and Price as 3.48
6. Save and Submit and Budget Check the Req
7. Source the Req to a PO
8. Run the Auto Sourcing process
9. Check the new PO created on Manage Req
10. Open the PO and Verify the Contract on the PO Line and Dispatch it
PO Line is associated to Contract Version 1
11. Now create a new version on the Contract an Update the Expire date from 10/01/2015 to 12/01/2015. Approve the Contract and Save it
12. Create a new requisition for the same Contract Item Id with qty 10 that has UOM as BOX and Price as 3.48
13. Save and Submit the Req and Budget Check it
14. Source the new req to PO
15. Run the PO Auto Source Process
16. Verify the new PO from manage Req page.
17. Verify the Contract version on the PO Line, its Contract Id 14 and Version 2. Dispatch the PO
18. Load the POAs for both POs with reducing the Price PO from 3.48 to 3.28
19. Verify the POA loaded under manage PO Acknowledgements
20. Verify and Approve the POAs
21. Once POAs Approved, run the Process Change Order job for the complete Business Unit
22. The Process fails with the below 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