Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Help on debug the FF
Summary
Add 1 day to termination dateContent
Hello,
I wrote this FF to get termination date +1.
DEFAULT FOR PER_PER_TERMINATION_DATE IS '0001/01/01 00:00:00' (date)
ALIAS PER_PER_TERMINATION_DATE AS TERMINATION_DATE
l_term_pay_thru_date = '0001/01/01 00:00:00' (date)
l_today =GET_CONTEXT(EFFECTIVE_DATE,to_date('1951/01/01 12:00:00'))
IF (TERMINATION_DATE WAS NOT DEFAULTED
AND TERMINATION_DATE <= l_today )
THEN ( l_term_pay_thru_date = ADD_DAYS(TERMINATION_DATE,1)
RULE_VALUE = TO_CHAR(l_term_pay_thru_date,'MM-DD-YYYY'))
ELSE (RULE_VALUE = '12/31/2999' )
RETURN RULE_VALUE
Unfortunately, the outcome is always blank.
Any help?
Tagged:
0