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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Schedule Extract using Fast Formula

in HCM Extract 2 comments

Summary:

Hi All,

We have a requirement to submit the extract at 3 different times (11 AM UTC, 5PM UTC, 11 PM UTC), for this i have created a Flow schedule fast formula with below code. Formula which I have written is running for 5AM UTC,11 AM UTC, 5PM UTC, 11 PM UTC.

can anyone suggest what is the mistake in the below code.


INPUTS ARE SUBMISSION_DATE(DATE), SCHEDULED_DATE(DATE)


SCH_TIME = TO_NUMBER(TO_CHAR(SCHEDULED_DATE, 'HH24'))

SCH_DAY = GET_DATE_DAY_OF_WEEK(SCHEDULED_DATE)

SCH_DATE = TRUNC(SCHEDULED_DATE)


NEXT_SCHEDULED_DATE = ADD_DAYS(SCHEDULED_DATE,0.25)


IF(SCH_TIME = 05) THEN

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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