Importance of Incremental Data in Oracle Fusion

Real-Time Scenario:

 Requirement:

If any changes like first name     Last Name/First Name

 got changed in a day then we need to capture those details and send to employees at the end of the day.

Tables required for this:

Per_all_pople_f

Per_person_names_f

 

Lets build the report

 Select

papf.person_number,

ppnf.first_name,

ppnf.last_name,

ppnf.last_update_date

From

Per_all_pople_f papf,

Per_person_names_f ppnf

 

where

papf.person_id=ppnf.person_id

and ppnf.name_type='GLOBAL'

and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date

and trunc(sysdate) between ppnf.effective_start_date and ppnf.effective_end_date

and trunc(ppnf.last_update_date) between trunc(sysdate-1) and trunc(sysdate)

 

 

                                                           

Burst to multiple email addresses stored in a parameter

Summary:

Burst to multiple email addresses stored in a parameter

Content (please ensure you mask any confidential information):

I would like to have Bursting to multiple email addresses that are stored in a parameter (either as Fixed Data LOV, or dummy SQL query from DUAL). The issue I am having is that when the report runs, it is only bursting to the first email address stored in the parameter.

SQL Dummy Query LOV:

In the bursting query you can see I have tried passing in both parameters (P_EmailAddress , P_EmailAddress2), however only the first email address listed in either LOV is what email address is being bursted to. When I run the report, I am using the 'All' value for the Parameter.

If I have the email addresses hardcoded in the bursting query, as shown in the middle highlighted line above then it will burst to both email addresses within 1 delivery.