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
Add 1 day to a date in a FF
Summary
we need to add 1 day to a dareContent
Hello,
we need to add one day to the following FF outcome:
DEFAULT FOR DATA_ELEMENTS IS EMPTY_TEXT_TEXT
INPUTS ARE DATA_ELEMENTS (TEXT_TEXT)
l_eff_date (date)= TO_DATE(SUBSTR(GET_PARAMETER_VALUE('effective_date'),1,10))
i=1
rule_value = ' '
l_person_id = -1
IF DATA_ELEMENTS.EXISTS('PERSON_ID') THEN
(
l_person_id = TO_NUMBER(DATA_ELEMENTS['PERSON_ID'])
rule_value = GET_VALUE_SET('XXHR_REHIRE_DATE','|=P_PERSON_ID='''||to_char(l_person_id)||'''')
rule_value = (rule_value + interval '1' day)
Tagged:
0