iSetup Comparison Reporter Completes With Error: ORA-01422: exact fetch returns more than requested number of rows (Doc ID 1909058.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle iSetup - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On Oracle Applications 12.1.3 version, iSetup Migrator
when attempting to run the iSetup R12 Comparison Reporter,
the following error occurs.


AZR12COMPREPORTER module: iSetup R12 Comparison Reporter
+---------------------------------------------------------------
:
:

******************************************
Entity Name: Document Sequence Assignment
Ignore Warnings and Continue: Yes
Update Existing Records: No
Time Taken(seconds): 52.0
java.sql.SQLException: ORA-20001: The following PL/SQL exception:
-1422: ORA-01422: exact fetch returns more than requested number of rows
occurred in procedure az_comp_reporter.compare
on this statement:
procedure end
ORA-06512: at "APPS.AZ_COMP_REPORTER", line 759
ORA-06512: at "APPS.AZ_COMP_REPORTER", line 180

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.az.r12.util.DBUtil.execCompRepProc(DBUtil.java:1325)
at oracle.apps.az.r12.api.BC4JAPI.compReportAPI(BC4JAPI.java:624)
at oracle.apps.az.r12.reporter.cpserver.APICompReporter$APICompReportExecuter.run(APICompReporter.java:465)

Status: ERROR

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms