G-INVOICING ECCRUNDL: ECC Run Data Load Concurrent Process Performance Issue and Error "ORA-01427: single-row subquery returns more than one row"
(Doc ID 2876459.1)
Last updated on APRIL 07, 2025
Applies to:
Oracle Enterprise Command Center Framework - Version 12.2.9 and laterOracle Project Billing - Version 12.2.9 and later
Oracle Project Costing - Version 12.2.9 and later
Information in this document applies to any platform.
Symptoms
On : 12.2.9 version, ECC Project Costing
ECCRUNDL: ECC Run Data Load having performance issue and completed with below error .
ERROR
---------
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01427: single-row subquery returns more than one row
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ~[ojdbc8.jar:19.3.0.0.0]
... 23 common frames omitted
Error Details:CP main completed runProgram for oracle.apps.fnd.ecc.dataload.EccDataLoadCP
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Go into the Project Costing Responsibility
2. Run the process ECCRUNDL: ECC Run Data Load
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 |
Cause |
Solution |
References |