Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Ability to submit Multiple Custom Bi reports(HCM) based on a single schedule (dynamic date param)
Summary:
We have multiple BI reports that take similar date parameters as input and produce different txt files as output. Since there around 60 unique scenarios we are covering, we have built multiple reports to make sure the reports runs efficiently.
The reports have three date parameters
- Effective Date From - defaults to sysdate-1
- Effective Date To - defaults to sysdate
- Last update date from - defaults to sysdate-1
- Our requirement 1 is to run these reports daily to find transactions that has happened yesterday and drop the files to SFTP server. I am trying to research what are our options to meet the requirement in most efficient way
0