How to Schedule the HCM Extract For multiple Times a day and passing Effective date as Sysdate — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Schedule the HCM Extract For multiple Times a day and passing Effective date as Sysdate

edited Jun 10, 2025 10:43AM in HCM Extract

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!