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
Performance Issue - HCM Extract that retrieves quarter to Date Balance for the last 5 quarters
in HCM Extract
I created an HCM Extract that returns the quarter to date balance of a specific balance group. I need the last 5 quarters and I was able to retrieve the data I need by manipulating the filter criteria of PAYROLL REL ACTIONS RANGE UE. Essentially, I equated the payroll actions effective date to the quarter end date with multiple OR condition to get 5rows.
I was able to get the data I needed but the HCM Extract took 10 hours to complete.
Does anyone have recommendation to improve the performance? or any other approach to get the same result?
Thanks a lot.
Tagged:
0