Get Started with Redwood for Oracle Cloud HCM Begin Now
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.
Absence Fast formula error
Summary
Absence Accrual Formula - LEGAL_EMPLOYER_IDContent
Here is my Absence Accrual Formula .
Code is below.
DEFAULT for ANC_ABS_TYP_NAME IS ' '
DEFAULT for LEGAL_EMPLOYER_ID IS 2323
INPUTS ARE IV_END_DATE(date), IV_START_DATE(date)
/*start checking annual type */
IF (ANC_ABS_TYP_NAME='Annual Leave')THEN
(
/*diffrence between end and start days */
l_no_of_days = DAYS_BETWEEN(IV_END_DATE,IV_START_DATE)
/* compare legal entities */
/***************/
if (
LEGAL_EMPLOYER_ID = 55555
)
then
IF (l_no_of_days < 0.5) THEN
(
VALID='N'
ERROR_MESSAGE = 'Absence Duration Cannot be less than 0.5 days'
)
IF (l_no_of_days > 16) THEN
Tagged:
0