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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Help on debug the FF

edited Mar 3, 2021 8:59AM in HCM Integrations 3 comments

Summary

Add 1 day to termination date

Content

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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