My Oracle Support Banner

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 and later
Oracle Fusion Application Toolkit - Version and later
Oracle Fusion Application Toolkit Cloud Service - Version and later
Information in this document applies to any platform.


On : 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.


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

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