1. Integrating with Oracle HCM Cloud Using an Oracle Integration Accelerator
  2. Create a Custom Frequency for the Extraction Schedule

Create a Custom Frequency for the Extraction Schedule

Oracle HCM OFS WorkSchedule Extract Integration fetches the Person's Assigned work schedule details from Oracle HCM Cloud and creates or updates the Work Schedule details in Oracle Fusion Field Service for the corresponding Resource.

Use these tips to receive the newly updated Work Schedule changes from Oracle HCM Cloud as an extract report:
  1. You can schedule an Extract Submission with the required frequency and use Extract Modes - Changed attributes to fetch the changed details. If you process the modified details instead of the full details from the extract, you will get a better performance.
  2. Schedule an extract submission. You can configure custom frequencies and use these frequencies while scheduling extract. For more information about how to create a custom frequency, see the HCM Extracts guide.
Note: Always convert the required frequency time to days. For example: 10 Minutes = 0.0069 Days.
Here is the formula text:
FORMULA NAME: Daily
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.
Input: SUBMISSION_DATE(DATE), SCHEDULED_DATE(DATE)
Calculation: NEXT_SCHEDULED_DATE = ADD_DAYS(SCHEDULED_DATE,0.0069)
Returns: RETURN NEXT_SCHEDULED_DATE