Error: While trying to ingest data for this load rule CN_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset cn-cp or cn-trx , ORA-01427: single-row subquery (Doc ID 2831763.1)

Last updated on MARCH 28, 2023

Applies to:

Symptoms

Oracle Incentive Compensation (ECC) Enterprise Command Center data load programs failing with the below error.

ERROR
statusMessage: There is an error while trying to ingest data for this load rule CN_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset cn-cp for job XX,XXX ORA-01427: single-row subquery

or

There is SQLException while applying load rule for dataset cn-trx for job XX,XXX. Exception details ORA-1427: single-row subquery returns more than one row


STEPS
1. Login to Oracle Applications.
2. R) Oracle Incentive Compensation -> Submit Service Requests window -> Try to run the OIC ECC data load program, It ends with the above mentioned error.

Changes

Cause

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