How to create alert in oracle fusion
Hi friends, We are going to discuss about the alert in Oracle Fusion. Alert helps to send notifications to concerned person, group or team if any specific condition meet or event occurs. It helps to put more control and visibility in system. Usually Alert is fired its terms of email notifications. We don't need to run the alert manually but it got triggered as per the schedule or some condition full fills. In Oracle Fusion , We cannot create the Alert as like alert Manger in Oracle apps but we have the other options too which helps to create or configure the alert in Oracle Fusion.
Types of alert in Oracle
1. Event Based Alert.
2.Periodic Alert.
Event Alerts:-
It got trigger when some event occurs. like we can create the alert based on some DB events like Insert , update or delete.
Periodic Alerts :-
It got trigger as per the schedule. We need to define the schedule for the alert. So Alert got triggers automatically as per the schedule and trigger notifications , if condition written inside the alert full fills.
In Oracle Fusion , We cannot create the Event based Alerts but we have the options to create the Periodic alerts in Oracle fusion.
Steps to Create the Periodic Alert in Oracle Fusion
There are two Options , to create the Periodic alert in Oracle Fusion.
1.BIP Schedule Option.
2.BIP Report Bursting.
Creating Alert through BIP Schedule Option in Oracle Fusion:-
Step1-; We have already created the BIP report 'Payables Detail Report' as below. We are creating this BIP schedule alert , To send the Notification for AP Invoices created yesterday in Oracle Fusion application.
 |
| How to create alert in oracle fusion |
Step 2:- Now We need to goto the Schedule Option for the BIP Reports.
 |
| How to create alert in oracle fusion |
Step 3:- Now Under Schedule Option , we need to goto the Output Option and specify the Destination type of the report output.
 |
| How to create alert in oracle fusion |
Step 4:- Now under Schedule Tab , We need to define the schedule for this report run.
 |
| How to create alert in oracle fusion |
Step 5:- We have the other options too , Like Notification in which we can send the notifications for the report Completion , report failed or other report related steps.
 |
| How to create alert in oracle fusion |
Creating Alert through BIP report bursting in Oracle Fusion:-
Step1:- First thing I am assuming , we know the BIP reporting tool in Oracle cloud. If you are familiar with BIP in Oracle Fusion then you can refer my OLD posts.
Step2:- Go to the BIP report Data Model to which we want to do the Bursting.
Step3:- For Example , here below is the Report Data Model and i want to Create the Bursting according to the vendor.
Like Report output should Split and send according to the supplier basis so here below VENDOR_ID is the important column of this report and we will use this column to split the report output for different suppliers.
 |
| How to create alert in oracle fusion |
Step4:- In the report Data Model , We need to go to Bursting Open as highlighted below.
 |
| How to create alert in oracle fusion |
Step5:- Now click on the '+' icon to create the bursting Logic for this report.
 |
| How to create alert in oracle fusion |
Step 6:- Here below we are designing the Bursting logic in Cloud BIP reports.
Split By and Delivery By are the Two important Parts in Designing the Bursting Logic.
Split By means , We can to divide the reports output on the basis of which column of the report. For Example , We will use Vendor_id column so that report output will be split based on the Vendor and if the report output having 3 suppliers output then Bursting First divide/split this report output in 3 parts based on Vendor Id.
Delivery By means , This is uses to sent the report output through Email. Here also we need to specify the report column based on which we want to delivery the report output.
Split By is the Parent Column and Deliver by is the child Column of this Parent Split by Column.
So Bursting email deliver logic works on the basis of Deliver By.
 |
| How to create alert in oracle fusion |
Step 7:- Here below i have used the common Vendor_ID column of the report in Split By & Deliver By logic.
Split By and Delivery By are the Two important Parts in Designing the Bursting Logic.
Split By means , We can to divide the reports output on the basis of which column of the report. For Example , We will use Vendor_id column so that report output will be split based on the Vendor and if the report output having 3 suppliers output then Bursting First divide/split this report output in 3 parts based on Vendor Id.
Delivery By means , This is uses to sent the report output through Email. Here also we need to specify the report column based on which we want to delivery the report output.
Split By is the Parent Column and Deliver by is the child Column of this Parent Split by Column.
So Bursting email deliver logic works on the basis of Deliver By.
In the SQL Query we will use this below SQL Query
select
Vendor_id as "KEY",
'RTF NAME OF THE BIP REPORT.rtf' TEMPLATE,
'en-US' LOCALE,
'PDF' OUTPUT_FORMAT,
VENDOR_NAME OUTPUT_NAME,
'EMAIL' DEL_CHANNEL,
'To Email Address' PARAMETER1,
'Cc Email Address' PARAMETER2,
'TestEmail.email.com' PARAMETER3,
'Subject Of the Email' PARAMETER4,
'Hi
'||'Email body which will be show in the Bursting Email.
'||'Thanks & Regards
Test Person' PARAMETER5,
'True' PARAMETER6,
:p_from_email PARAMETER7
from PO_VENDORS
 |
| How to create alert in oracle fusion |
Step8:- Here below is the final Bursting Logic written in the BIP report.
 |
| How to create alert in oracle fusion |
0 comments:
Post a Comment