Guidance Required – Executing Dynamic SQL in Oracle BI Publisher Report
Summary:
We have a requirement where business users will maintain extract configurations through a custom Oracle VBCS screen.
For each vendor, the users will configure details such as:
- SELECT clause (list of columns to extract)
- WHERE clause (filter criteria)
Based on this configuration, our application needs to invoke an Oracle BI Publisher (BIP) report to extract the corresponding data from Oracle Fusion and then send the output to the respective vendor.
We would like to understand whether Oracle BI Publisher supports this type of dynamic behavior.
Specifically, we have the following questions:
- Is it possible to pass a dynamic SQL query
0