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

How to Schedule a BI Publisher Report with Dynamic time range in parameter Values

edited Aug 5, 2024 5:10PM in Payables, Payments & Cash Management 12 comments

Issue Description:
We need to view the BIP Reports -'Execution History by User' and 'BIP Reports Execution Summary'. To accommodate this, we are utilizing one of Oracle's standard reports, the "BIP Report Audit Trail," located in the Audit Reports section.
The Client specific requirement is to filter the report data based on a dynamic time range, such as the last 2 or 4 hours, and to have these time range parameters be dynamically adjustable when scheduling the report.

Current Challenge:
In our initial attempt to meet this requirement, we utilized the following parameters to retrieve data for the past 24 hours: {$SYSDATE()-1$}

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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