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:

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

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