Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Error with Month as a Presentation Variable Prompt
Summary
ORA-01722: invalid number at OCI call error when calling the report through prompt but works fine when hard-codedContent
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.
Tagged:
0