Unique Constraint (SYSADM.PS_PC_RES_PA_TA14) Violated. Process Abended At Step PC_POADJUST.QUANTITY.COND_1 (SQL) (Doc ID 1567925.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

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'

Replication Steps:
-----------------------

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.

 

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