My Oracle Support Banner

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 later
Information in this document applies to any platform.


When attempting to run ECC full Load the Order Management Command Center Returns Data Load fails ,
the following error occurs.

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

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. 




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

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