My Oracle Support Banner

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

Last updated on MARCH 25, 2019

Applies to:

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


On : 9.2 version, Purchasing Adjustments.

PC_POADJUST Process failed with below abend

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

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




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.