Oracle Fusion :- BIP Bursting In Oracle Fusion Cloud
Many a times there is a need to send details to a specific distribution list or an individual based on a specific event/transaction which has taken place in the ERP Application.
Some of such use case scenario being:
All of the above were easily achieved in an On-Premise environment (EBS particularly) either by creating a Custom Alert (Periodic/Event depending on the specific business requirement) or a custom pl/sql program which would send details over email or even by using BI Publisher Bursting Feature.
However, in a Cloud Environment we do not have the flexibility of using custom code and although the Alert Manager feature is available (starting Release 12) one need to check whether there are events already present against which one could raise the alert action.
So does this means one would not be able to perform such actions in a Cloud Setup?
No, absolutely not. While we don’t have the flexibility of writing a custom pl/sql nor can we can define new alerts as per our requirement but we still can use BI Publisher Bursting Feature and achieve desired results.
In this article, we would try to demonstrate the same.
For this example, we would try to send a “Termination Initiation Notice” to Manager whenever a subordinate submits resignation.
The manager would be send the information about the Employee Name along with his/her Person# and actual termination date in an Email. The Email should also have a static internal portal link (which will contain knowledge documents describing how to perform exit formalities). Additionally, there should also be a PDF attachment in the Email.
So, let-us begin then.
We would have to create a SQL Query which would form our data source for this BIP Report.
The Report should fetch details like:
We would also need to create a BI Bursting Query
Also, we have created a ‘Schedule Trigger’ to ensure that the Scheduled Report should only send email whenever there is data returned from the mail Data Model SQL. In this case the Schedule Trigger would only return a TRUE value whenever a termination happens between Current System Date and one day prior to it.
Running the Report
When we run the report and check the same using the ‘Schedule Option’ we can see the following:
Verifying the Results
A quick check on the received email confirms that the expected content is delivered
And the attachment looks as per the BI Template