Error with Month as a Presentation Variable Prompt — Cloud Customer Connect
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

Error with Month as a Presentation Variable Prompt

edited Jan 25, 2021 12:57AM in Reporting and Analytics for HCM 6 comments

Summary

ORA-01722: invalid number at OCI call error when calling the report through prompt but works fine when hard-coded

Content

OTBI Report runs fine in Edit mode and shows expected results. Issue is occuring when FILTER function is used with a presentation variable. Column Prompt: "Time"."Month" is used as presentation variable. When I hard-code the value in the FILTER function it works fine.  

The report is built on Absence Calendar and Payroll - Run Results subject areas.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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