My Oracle Support Banner

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 later
Oracle 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


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