How to Schedule the HCM Extract For multiple Times a day and passing Effective date as Sysdate
Summary:
We have a Requirement to Schedule the HCM Extract For multiple Times a day and passing Effective date as Sysdate,
We have Developed the Fast Formula to Run the Extract for Every 4 Hours which is working fine and we have edited the parameter in Refine Extracts and made it as Post SQL Bind and basis value as (Select sysdate from dual) , But problem is the run which is scheduled for next day on the current day is return the sysdate as parameter value.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):