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
Skip to content
  • 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!