OM Command Center Returns Data Load Request Fails with Error ORA-01427: Single-Row Subquery Returns More Than One Row
(Doc ID 2883937.1)
Last updated on JULY 26, 2022
Applies to:
Oracle Enterprise Command Center Framework - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run ECC full Load the Order Management Command Center Returns Data Load fails ,
the following error occurs.
ERROR
-----------------------
ERROR 1.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is SQLException while applying load rule for dataset ont-rlines for job 144,169
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
ORA-06512: at "APPS.OE_ECC_UTIL_PVT", line 6554
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Oracle Applications
2. Go to Order Management Super User Responsibility
3. Run the Enterprise Command Center full Load for Order Management.
4. Order Management Command Center Returns Data Load program ends in error and error is seen in the Log file.
Changes
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 |