Fusion Global HR: Is There Any Way by Which an HCM Extract Can be Scheduled for 5 Days a Week> (Doc ID 1990920.1)

Last updated on AUGUST 28, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion Global Human Resources - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Goal

1. Is there any way by which a user can schedule a HCM extract to process for 5 days a week?

2:Wrote a fast formula of type 'Flow schedule' for the requirement:
Schedule extract for 5 days a week(Monday,Tuesday,Wednesday,Thursday,Friday) But fast formula is not working properly. Extract is getting scheduled for each day.


Fast formula

/*******************************************************************
FORMULA NAME: Daily Weekday Schedule
FORMULA TYPE: Flow Schedule
DESCRIPTION: Formula to return a date time.
  Returns NEXT_SCHEDULED_DATE;
FORMULA RESULTS:
NEXT_SCHEDULED_DATE This is a date time value with yyyy-MM-dd HH:mm:ss format.
********************************************************************/
/* Inputs */
INPUTS ARE SCHEDULED_DATE(DATE)

/* Calculations */
add = 1
day = to_char(SCHEDULED_DATE, 'DAY')
if (day = 'FRIDAY') then add = 3
NEXT_SCHEDULED_DATE =ADD_DAYS(SCHEDULED_DATE, add)
 
/* Returns */
RETURN NEXT_SCHEDULED_DATE

/* End Formula Text */
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms