Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to bind effective date parameter of HCM Extract to BIP Report's parameter and load HDL ?
Summary: How to bind effective date parameter of HCM Extract to BIP Report's parameter and load the HDL file generated by BIP Report ?
Content (please ensure you mask any confidential information):
I have created one custom BIP Report and its Data Model. Data Model having two data sets 1. EmployeeDetailsDS 2. globalReportsDataset and following are parameter in data model archiveActionId, deliveryOptionId, payrollActionId, flowInstanceName, sequence, isBursting, isChunking, p_effective_date.
Now created one dummy extract to call this BIP report. Under Payroll Flow Patterns following are task defined
1. Employee Interface,
2.Initiate HCM Data Loader,
3. Run BI Publisher Report (Under Run BI Publisher Report defined Eighth Argument as Effective Date).