java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at ""APPS.IBY_EXTRACTGEN_PVT"", line 353 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

tip

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Error while navigating in OIC
    via by 676255,
  • Upgrade 12.0.6 to 12.1.1 error
    via by Sivamani,
  • Transaction deadlock TX
    via Stack Overflow by Naini Archana
    ,
  • AIA Order to Cash Implementation Issue
    via by Bharathy,
    • java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at ""APPS.IBY_EXTRACTGEN_PVT"", line 353 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3445) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4395) at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:85) at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCore(FDFormatProgramUtils.java:242) at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCommon(FDFormatProgramUtils.java:218) at oracle.apps.iby.scheduler.FDFormatProgramUtils.doPmtInstrExtractAndFormat(FDFormatProgramUtils.java:97) at oracle.apps.iby.scheduler.FDExtractAndFormatting.doExtractAndFormat(FDExtractAndFormatting.java:439) at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:269) at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:154) at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    tomthomas
    tomthomas1 times, last one,
    tzrlk
    tzrlk10 times, last one,
    treefolk
    treefolk6 times, last one,
    46 more bugmates