Issue with HCM Extract – Effective Date Not Picking Sysdate on Scheduled Runs
Summary:
Hi Forum,
We have a requirement to generate an HCM extract (changes-only file) scheduled on the 15th and 28th of each month. For this, we are using Flow Schedule FF.
The challenge we’re facing is that the effective date is not picking up as sysdate during the scheduled runs on the 15th and 28th.
I have tried two approaches so far: - Post SQL Bind and Context Bind in Refine Extracts..
Unfortunately, both scenarios resulted in the wrong effective date being picked.
Could you please guide me on how to achieve the correct effective date (sysdate) for these scheduled runs?
0