My Oracle Support Banner

Fusion Applications - How To Schedule BI Publisher Report With Dynamic Parameter (Based On SQL) (Doc ID 2554719.1)

Last updated on FEBRUARY 19, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.

Goal

How To Schedule BI Publisher Report With Dynamic Parameter (Based On SQL)?

Example
---------

  1. Create Data Model
  2. Add LOV based on SQL
  3. Add Parameter and use the above LOV
  4. Now, Schedule the report
  5. In the 'General' tab, parameters are displayed and we need to enter a value.
  6. it does not request for dynamically take the value from the SQL specified in LOV.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.