HCM Extracts : How to specify dynamic date in HCM Extracts Schedule

It is very rare that the HCM Extracts would be developed to be run on ad-hoc basis.
Most of the times the extracts are scheduled on a periodic basis.

Saying so, we might need to pass dynamic value for its parameters for ex: effective date. ( in place of SYSDATE which is by default )

Lets say we want the extract to run with date range of 15 days in future. ( i.e EffectiveDate is SYSDATE+15 )

To achieve this, we need to go to Data Exchange ==> HCM Extracts ==> Refine Extracts ==>
Search for the extract and click on edit.

Select the Effective Date parameter and click on edit. Enter below values :
a. Parameter Basis : Post SQL Bind
b. Basis Value : select sysdate+15 from dual
c. Save and then Submit.
 

Bingo, now whenever the extract runs the effective date would be Todays date + 15.

Thanks for reading,
Srikanth

Fusion BIP : How to view the report output submitted by any user.

Many times we need to view the report outputs submitted by others. This might be to debug an issue or just for data validation.

We can achieve this from the same BIP login of the Fusion Apps, from where we generally create the reports.

Navigation :
a. Open the URL : https://< FusionApps hostname>/xmlpserver
b. Click on the Home link.
c. Click on the "Report Job History" on the bottom left.

d. This opens a search window, enter the Report Job Id and click on Search.
    (  In case of HCM Extracts, the ESS JobID of the BIP Job can be entered in the ReportJobName field ).
     The search results will be shown which is irrespective of the user who has submitted them.
     The output can also be downloaded from the same.
   

             

Now click on the "Report Job Name" and this takes us to the page where we can download the report output.

Thanks for reading,

Srikanth