My Oracle Support Banner

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 MAY 16, 2019

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

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
Symptoms
 Listing of PC_AP_TO_PC Error Messages and Troubleshooting Tips to Resolve each Error > Note 1298728.1
Cause
Solution
References


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