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
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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)

    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