My Oracle Support Banner

Full Dataload Contract Lifecycle Management For ECC Fails With Error "ERROR 5.o.e.i.u.s.i.DataLoadControllerServiceImpl" (Doc ID 2821016.1)

Last updated on MAY 02, 2022

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, ECC Contract Lifecycle Management

ECC V6 - CLM dataload failed with the following error: 
 

ERROR
-----------------------
22:41:00.919 [pool-4-thread-1] ERROR 5.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is an error while trying to ingest data for this load rule PO_ICX_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset po-clm-requisitions for job 5,112java.sql.SQLException: ORA-01427: single-row subquery returns more than one row


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run CLM ECC data load
2. See error

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.