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)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

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

Solutions on the web

via Oracle Community by VikramAwotar, 1 year ago
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)
via Stack Overflow by Aniket
, 2 years ago
ORA-01403: no data found </code></pre> <p>ORA-06512: at "SYSTEM.LOGIN", line 10 ORA-06512: at line 1</p> <pre><code>at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
via Oracle Community by 666705, 1 year ago
ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
via Oracle Community by Nayas, 1 year ago
ORA-00005: Message 5 not found; product=RDBMS; facility=ORA ORA-06512: at "SYS.DBMS_UTILITY", line 70 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
via Oracle Community by 435534, 1 year ago
ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS.OWA_UTIL", line 328 ORA-06512: at "SYS.HTP", line 7 ORA-06512: at "FLOWS_020200.EXPORT_TO_CLOB", line 18 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
via Oracle Community by 445907, 1 year ago
ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS.OWA_UTIL", line 328 ORA-06512: at "SYS.HTP", line 7 ORA-06512: at "FLOWS_020100.EXPORT_TO_CLOB", line 18 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
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

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 3 weeks ago
Samebug visitor profile picture
Unknown user
Once, 1 month ago
Samebug visitor profile picture
Unknown user
Once, 1 month ago
Samebug visitor profile picture
Unknown user
Once, 1 month ago
52 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.