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 220.127.116.11.0 and later
Oracle Fusion Application Toolkit - Version 18.104.22.168.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!