You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BIP Report Error with XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Received Response
19
Views
7
Comments
edited Feb 8, 2021 7:22AM in Reporting and Analytics for ERP 7 comments

Summary

As soon as report is submitted it throws XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Code Snippet

WITH
    tax_cal_dates
AS
   (SELECT
       (SELECT
             MIN(glp.START_DATE)
        FROM
            GL_PERIODS   glp
        WHERE
            glp.PERIOD_SET_NAME = 'VH Calendar' AND
            glp.PERIOD_NAME = nvl(:p_period_acct_start,glp.period_name))   min_date,
       (SELECT
 
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!