Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
How to count User-Defined Table Values to use in Fast formula?
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:
0