oracle.apps.iby.exception.DatabaseException: SQLException occurred: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 353 ORA-06512: at line 1at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:208)

Oracle Community | 843443 | 5 years ago
  1. 0

    Positive Pay with Additional Parameters erroring out on Manual Run

    Oracle Community | 5 years ago | 843443
    oracle.apps.iby.exception.DatabaseException: SQLException occurred: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 353 ORA-06512: at line 1at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:208)
  2. 0

    The Create Settlement Batches fails with java.sql.SQLSyntaxErrorException

    Oracle Community | 5 years ago | user5793782
    oracle.apps.iby.exception.DatabaseException: 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)
  3. 0

    ORA-01693: max # extents (505) reached in lob segment IBY.SYS_LOB000019518

    Oracle Community | 5 years ago | kkrm333
    oracle.apps.iby.exception.DatabaseException: 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)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Format Payment Instructions with Text Output fails with ora 01422

    Oracle Community | 5 years ago | Tam_11
    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)
  6. 0

    iPayment Scheduler Concurrent Request is giving an error

    Oracle Community | 9 years ago | 591439
    oracle.apps.iby.exception.DatabaseException: SQLException occurred: ORA-00904: "IBY_UTILITY_PVT"."MAKE_ASCII": invalid identifier

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.apps.iby.exception.DatabaseException

      SQLException occurred: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 353 ORA-06512: at line 1at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:208)

      at oracle.apps.iby.database.DBWrapper.raiseDBException()
    2. oracle.apps.iby
      FDPositivePayAddParam.runProgram
      1. oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:218)
      2. oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:89)
      3. oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCore(FDFormatProgramUtils.java:258)
      4. oracle.apps.iby.scheduler.FDFormatProgramUtils.doPosPayAddParamExtractAndFormat(FDFormatProgramUtils.java:156)
      5. oracle.apps.iby.scheduler.FDPositivePayAddParam.runPosPay(FDPositivePayAddParam.java:252)
      6. oracle.apps.iby.scheduler.FDPositivePayAddParam.runProgram(FDPositivePayAddParam.java:119)
      6 frames
    3. oracle.apps.fnd
      Run.main
      1. oracle.apps.fnd.cp.request.Run.main(Run.java:157)
      1 frame