Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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):
Tagged:
0