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

    How to count User-Defined Table Values to use in Fast formula?

    in Payroll and Global Payroll Interface (GPI) 8 comments

    Summary:

    We are trying to use UDT in a Fast formula to get Holiday dates in the current year, the reason to use a custom table is that the delivered function GET_PAY_AVAILABILITY did not work as expected. Thus we want to fill an array from UDT and then later use it in fast formula.


    Content (required):

    The function "GET_PAY_AVAILABILITY" is not considering the weekend based on employee's work schedule.

    We applied for 28-Apr-2022 (Thurs) to 30-Apr-2022 (Sat) for an employee who has Monday off in his Assigned Work schedule. (Person Number 11854)

    Holiday (29-Apr & 30-Apr)

    1. GET_PAY_AVAILABILITY ('ASSIGN',l_abs_sd,l_abs_ed,'Y', 'Y', 'Y', 'N', 'D')

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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