Enterprise Command Center (ECC) 'Projects Costing Budgetary Control ECC Data Load' Process Errors with 'ORA-01427: single-row subquery returns more than one row' in the Log File.
(Doc ID 2847193.1)
Last updated on FEBRUARY 07, 2022
Applies to:
Oracle Project Costing - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
The 'Projects Costing Budgetary Control ECC Data Load' process errors with the following in the log file:
ERROR 5.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is SQLException while applying load rule for dataset pa-ds-cost-bcbalances for job 55,402java.sql.SQLException: ORA-01427: single-row subquery returns more than one rowORA-06512: at "APPS.PA_ECC_COST_BUDGET_CNTRL_PKG", line 391ORA-06512: at "APPS.PA_ECC_COST_BUDGET_CNTRL_PKG", line 391ORA-06512: at "APPS.PA_ECC_COST_BUDGET_CNTRL_PKG", line 3086ORA-06512: at line 1 at
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01427: single-row subquery returns more than one rowORA-06512: at "APPS.PA_ECC_COST_BUDGET_CNTRL_PKG", line 391ORA-06512: at "APPS.PA_ECC_COST_BUDGET_CNTRL_PKG", line 391ORA-06512: at "APPS.PA_ECC_COST_BUDGET_CNTRL_PKG", line 3086ORA-06512: at line 1 at oracle...
Steps to Reproduce:
1. Project's responsibility
2. Other | Requests | Run | run the process: 'Projects Costing Budgetary Control ECC Data Load' process
Changes
New implementation
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 |
| Changes |
| Cause |
| Solution |
| References |