1 Reply Latest reply on May 17, 2011 3:09 PM by omaha66

    ORA-01722: invalid number

    707073
      Hi All,

      One of my Report(10.1.2.0.2) is getting error when i change the profile option ICX: Numeric characters to 10.000,00 at user level.

      Error Message :
      ----------------------
      ORA-01722: invalid number
      SELECT '1' sptempcolumn , aps . vendor_name sp_vendor_name , apss . country sp_vendor_country , apinv . line_type_lookup_code sp_line_type , api . invoice_currency_code sp_pay_currency , api . gl_date sp_gl_date , (SELECT rc.reporting_code_char_val
      REP-0069: Internal error
      REP-57054: In-process job terminated:Terminated with error:
      REP-300: invalid number
      SELECT '1' sptempcolumn , aps . vendor_name sp_vendor_name , apss . country sp_vendor_country , apinv . line_type_lookup_code sp_line_type , api . invoice_currency_code sp_pay_currency , api . gl_date sp_gl_date , (SELECT rc.reporting_code_char_val

      The default value of ICX: Numeric characters at site level is 10,000.00 . At this time the report is completed normal.

      Can anybody give a solution for it.its very urgent.
        • 1. Re: ORA-01722: invalid number
          omaha66
          Cannot tell for sure without seeing the rest of your query (the part after the SELECT in your subquery) but a few things to check -

          Are you checking a character field against a numeric value?

          ex: where attribute1 = 12345; -- this would give you that error

          Are you checking a numeric field against a character?

          ex: project_id = '1A2';

          Is there a value larger than your max 10,000 ?

          it might just be a formatting thing, but there are spaces after your "." in many of the statements in your query, don't know if that would cause this issue but would surely cause "an" issue.

          ex: aps . vendor_name -- the space after aps. should not be there.

          Try posting your entire query and see if we can be of more hlep.