Fusion Apps, BI Publisher, How To Update A DFF After Running A BI Report? (Doc ID 1992611.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Financials Common Module - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.9.2.0 version, Technology Management - BI & Reporting

How to update a DFF after running a BI report?

We have created a BI report to export payments, and we'd like to use a flag to track which payments have been exported. So we want to update a DFF and set it to "Y" every time a payment is processed by the report. But we are not able to find a way to do so. We have noticed that in Data Model there is Event Triggers which can use PL/SQL functions, but we are not sure how to customize a PL/SQL package and configure the BI report to use it. Please check the screenshots attached and give some suggestions or workarounds.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms