PC_SUM_FRSH2 Application Engine does not allow concurrent processing- SQL Error: ORA-00001: unique constraint (DEV.PS_PC_SUM_USE_TAO) violated (Doc ID 1298728.1)

Last updated on NOVEMBER 09, 2016

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9 and later
Information in this document applies to any platform.
*Checked for relevance on 30-DEC-2013

Symptoms

Listing of PC_AP_TO_PC Error Messages and Troubleshooting Tips to Resolve each Error > Note 1298728.1


When attempting to run the Accounts Payable Cost Collection process 'PC_AP_TO_PC' it abends at step PC_SUM_RFSH2.PreFull.10000000 (SQL).
and the following error occurs:

ERROR
-----------------------
SQL Error: ORA-00001: unique constraint (DEV.PS_PC_SUM_USE_TAO) violated.

STEPS
----------
The issue can be reproduced with the following steps:
1. Navigation: Project Costing> Cost Collection> Payables.
2. Run the PC_AP_TO_PC process

Expected Behavior:
------------------------
Expect to run the PC_AP_TO_PC smoothly without any abends.

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