There are cases where you need to run HCM Extracts on different schedules which are not available in standard schedule. For example, we need to run an HCM Extracts after 6 hours. In this case, a custom flow schedule fast formula can be created.
Sample FF to run HCM Extracts at 4 AM, 10 AM, 4 PM and 10 PM:
INPUTS ARE SUBMISSION_DATE(DATE), SCHEDULED_DATE(DATE)
NEXT_SCHEDULED_DATE = ADD_DAYS(SCHEDULED_DATE,0.25)
SCHEDULED_TIME = TO_NUMBER(TO_CHAR(NEXT_SCHEDULED_DATE, 'HH24'))
IF(SCHEDULED_TIME = 04) THEN
(
NEXT_SCHEDULED_DATE = ADD_DAYS(NEXT_SCHEDULED_DATE,0.25)
)
RETURN NEXT_SCHEDULED_DATE