Unique Constraint (SYSADM.PS_PC_RES_PA_TA14) Violated. Process Abended At Step PC_POADJUST.QUANTITY.COND_1 (SQL)
Last updated on MARCH 06, 2018
Applies to:PeopleSoft Enterprise FIN Project Costing - Version 9.1 and later
Information in this document applies to any platform.
In FSCM 9.1 PC_POADJUST process goes into error when it is invoked from PC_AP_TO_PC process.
Process is abended at Step PC_POADJUST.QUANTITY.COND_1 (SQL) -- RC = 805 (108,524) with below error.
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1617 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PC_RES_PA_TA14) violated
Failed SQL stmt:INSERT INTO PS_PC_RES_PA_TA14 (PROCESS_INSTANCE, BUSINESS_UNIT, PROJECT_ID, ACTIVITY_ID, RESOURCE_ID, RESOURCE_ID_FROM .....
----- AND T.AMOUNT_FLG <> 'Y'
1. Set Up Financials/Supply Chain, Install, Installation Options, Project Costing - From Feed option checked for Purchase Order Reversal to have the PC_POADJUST process to be invoked during cost collection.
2. Create a PO with VAT
3. Source PO to PC via PC_PO_TO_PC.
4. Create voucher against that PO and adjust line amount.
5. Source Voucher to PC via PC_AP_TO_PC.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms