oracle.apps.iby.exception.DatabaseException

SQLException occurred: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 380 ORA-06512: at line 1at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:208)

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web5

  • via Oracle Community by Tam_11, 11 months ago
    SQLException occurred: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 380 ORA-06512: at line 1at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:208)
  • SQLException occurred: ORA-01722: invalid number ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 519 ORA-06512: at line 1at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:208)
  • SQLException occurred: ORA-01693: max # extents (505) reached in lob segment IBY.SYS_LOB0000195185C00003$$ ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 353 ORA-06512: at line 1at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:208)
  • Stack trace

    • oracle.apps.iby.exception.DatabaseException: SQLException occurred: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 380 ORA-06512: at line 1at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:208) at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:218) at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:89) at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCore(FDFormatProgramUtils.java:258) at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCommon(FDFormatProgramUtils.java:234) at oracle.apps.iby.scheduler.FDFormatProgramUtils.doPmtInstrExtractAndFormat(FDFormatProgramUtils.java:90) at oracle.apps.iby.scheduler.FDExtractAndFormatting.doExtractAndFormat(FDExtractAndFormatting.java:456) at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:278) at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:159) at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

    Write tip

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

    Users with the same issue

    You’re the first here who have seen this exception.