Schedule the Data Extract in Fusion HCM hourly or on any custom frequency

We have only few Pre defined options to schedule the Data Exchange or Data Extract in Oracle Fusion,

Daily/Monthly/Once/Weekly

However there is always a need to schedule the extract on a different frequency such as hourly on any specific day of the week etc.

Here is a solution to this: A New Fast Formula,

Navigate to Fast Formula Creation Screen, Consider an example that we need to schedule the Data Extract in every hour, 

Create a New formula:

Formula Name: IT_TEST_1_HOUR_SCHEDULE

Type: Flow Schedule

Description: Optional

/*****************************************************************************

FORMULA NAME: Hourly Flow Schedule

FORMULA TYPE: Flow Schedule

DESCRIPTION: Formula to return a date time.

Returns NEXT_SCHEDULED_DATE;

Formula Results :

NEXT_SCHEDULED_DATE This will be a date time value with yyyy-MM-dd HH:mm:ss format.

*******************************************************************************/

/* Inputs */

INPUTS ARE SUBMISSION_DATE(DATE), SCHEDULED_DATE(DATE)

/* Calculations 1 Hour*/

NEXT_SCHEDULED_DATE = ADD_DAYS(SCHEDULED_DATE,0.041666)

/* Returns */

RETURN NEXT_SCHEDULED_DATE

/* End Formula Text */

Once the Fast Formula is Ready, 

Next step is to define new extract:

Navigate to My Client Groups - Data Exchange - Submit Extracts

For the newly created extract use this new Fast Formula in the schedule parameter: 

Select the Frequency: 

and summit and Test your Data Extract