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 with Redwood for Oracle Cloud HCM   Begin Now

How can I pass the current date to a job that runs a BI publisher report with a text parameter?

Received Response
32
Views
2
Comments
edited Apr 28, 2023 2:15PM in Reporting and Analytics for HCM 2 comments

Summary:

I have a report that takes a date in TZ format (ex: '2023-03-10T00:00:00.000+05:00'), through a text parameter. I need to create a scheduled job for this report and to pass the current date to it. What are my options?

Content (required):

Unless I am missing some thing that should be fairly obvious, this looks like a very serious problem with the usability of BI Publisher and its scheduled jobs/system variables because nothing that I try works.

I have a data model that receives a text parameter that is later converted to TO_UTC_TIMESTAMP_TZ(). Unless I do it so date component extraction functions do not work. So, I am stuck with the text parameter.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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