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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Getting error after scheduling BI Report with Bursting definition

in Reporting and Analytics for HCM 3 comments

Summary:

I have resignation report based on transaction console. I'm scheduling the report with Bursting definition and i'm getting below error.

Job processor caused exception

[INSTANCE_ID=bip.bi_serverHA] [INSTANCE_JOB_ID=2204205]

Error getting report data

[INSTANCE_ID=bip.bi_serverHA] INSTANCE_JOB_ID=[2204205] oracle.xdo.XDOException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected DATE got NUMBER

oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected DATE got NUMBER

at oracle.xdo.servlet.BurstingDefinitionImpl.getControlXM



But if i schedule the report without bursting defintion, it is getting success without any error.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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