My Oracle Support Banner

Enterprise Command Center (ECC) ECC Data Load - po-pcc-requisitions - Failing With Error - Exception Details ORA-01427: Single-Row Subquery Returns More Than One Row oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) (Doc ID 2826372.1)

Last updated on SEPTEMBER 02, 2024

Applies to:

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

Symptoms

Using Purchasing, Version 12.2

Actual:
Enterprise Command Center (ECC) Data load - po-pcc-requisitions - failing with error


Expected:
The ECC Data Load should not fail with error.


Error:
Status Message
Failed as one of the load rules failed which is [id = 19,431, PO_PCC_REQUISITIONS_UTIL_PVT.GET_ECC_DATA_LOAD_INFO]. Please check the load rule audit entry
Data Set Details
Sequence

Query details
Status Message
There is SQLException while applying load rule for dataset po-pcc-requisitions for job 24,927. Exception details ORA-01427: single-row subquery returns more than one row oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)


Replication Steps:
The issue can be reproduced at will with the following steps:
1. ECC Data load is submitted by navigating the ECC Developer Responsibility
    - On the left hand sidemenu - choose Data Load Submission
    - Choose the application name and then data set 'ALL'
    - Load type is 'Full Load'
2. Find that the Data Load process completed with errors

Other:
1. <Patch 32495423>R12.PO.D was applied - but did not resolve the issue.

2. The full error noted from the log is as follows:

10:59:22.227 [pool-4-thread-11] ERROR 2.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is an error while trying to ingest data for this load rule PO_PCC_REQUISITIONS_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset po-pcc-requisitions for job 27,902
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:765) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1362) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:369) ~[ojdbc8.jar:19.3.0.0.0]
at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:499) ~[com.bea.core.datasource6.jar:12.2.1.4]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.applyLoadRuleDetail(DataLoadControllerServiceImpl.java:2158) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.invokeDataLoad(DataLoadControllerServiceImpl.java:1922) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.loadDataForDataset(DataLoadControllerServiceImpl.java:667) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.startJob(IRDataLoadServiceImpl.java:930) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.tryToStartJob(IRDataLoadServiceImpl.java:542) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.lambda$runLoadDataForApplicationWorkFlow$21(IRDataLoadServiceImpl.java:2152) [ecc-ir-1.0.0.jar:na]
at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1640) ~[na:1.8.0_281]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_281]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_281]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_281]
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01427: single-row subquery returns more than one row

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ~[ojdbc8.jar:19.3.0.0.0]
... 23 common frames omitted
10:59:22.235 [pool-4-thread-11] ERROR 2.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is SQLException while applying load rule for dataset po-pcc-requisitions for job 27,902
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:765) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1362) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:369) ~[ojdbc8.jar:19.3.0.0.0]
at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:499) ~[com.bea.core.datasource6.jar:12.2.1.4]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.applyLoadRuleDetail(DataLoadControllerServiceImpl.java:2158) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.invokeDataLoad(DataLoadControllerServiceImpl.java:1922) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl.loadDataForDataset(DataLoadControllerServiceImpl.java:667) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.startJob(IRDataLoadServiceImpl.java:930) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.tryToStartJob(IRDataLoadServiceImpl.java:542) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.IRDataLoadServiceImpl.lambda$runLoadDataForApplicationWorkFlow$21(IRDataLoadServiceImpl.java:2152) [ecc-ir-1.0.0.jar:na]
at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1640) ~[na:1.8.0_281]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_281]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_281]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_281]
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01427: single-row subquery returns more than one row

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ~[ojdbc8.jar:19.3.0.0.0]
... 23 common frames omitted
16:57:32.485 [pool-4-thread-11] ERROR 2.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is SQLException while applying load rule for dataset po-pcc-ind-proc for job 27,902
java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 1375 with name "_SYSSMU1375_2546179767$" too small
ORA-06512: at "APPS.PO_PCC_IND_PROC_UTIL_PVT", line 2029
ORA-06512: at "APPS.PO_PCC_IND_PROC_UTIL_PVT", line 103
ORA-06512: at line 1

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.