PC_POADJUST Process ABENDED At Step PC_POADJUST.AMOUNT.COND_2 (Action SQL) -- RC = 805

(Doc ID 2391151.1)

Last updated on APRIL 27, 2018

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Purchasing Adjustments.

PC_POADJUST Process failed with below abend

ERROR
-----------------------
-- 16:55:17.894 Process 140570 ABENDED at Step PC_POADJUST.AMOUNT.COND_2 (Action SQL) -- RC = 805
ROLLBACK
/
-- 16:55:17.942 SQL Error: ORA-00001: unique constraint (EMDBO.PS_PC_RES_PA_TA14) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a project/Activity
2. Create a PO with PC chartfields, dispatch the PO and then interface it to PC by running PC_PO_TO_PC. Say the item quantity is 1 and Item amount is $10,000
3. Create a Voucher for this PO. Copy the contents from the PO to voucher. Added an additional $1000 for freight (Prorated).
4. Post the voucher and run PC_AP_TO_PC process in "Detail" Mode.
5. Notice there will be 2 lines, For the merchandise amount, the resource_id starts with 'D' and for freight amount, the resource_id starts with 'F'
6. Run PC_POADJUST process and the process abends with the above error

Changes

 

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