Fusion Benefits: Function BEN_FN_GET_CHAR_VALUE Not Returning Expected Results in Poste Election Fast Formula if Used in ChangeContext With Future Effective Date (Doc ID 2575030.1)

Last updated on FEBRUARY 13, 2023

Applies to:

Symptoms

 The function ben_fn_get_char_value is returning an 'ENROLLED' output of 'N', though the employee is enrolled with that plan already.

Ex:

CHANGE_CONTEXTS (EFFECTIVE_DATE = l_eff_date)
  (
  l_enr_exec_life = ben_fn_get_char_value
  ('BEN_PRTT_ENRT_RSLT'
  ,'ENROLLED'
  ,l_exec_life /* Plan name is 'Executive Life/AD&D' */
  ,'NA'
  )

)

The above function returns 'N', but when ben_fn_get_char_value is used outside CHANGE_CONTEXTS then its returning 'Y'. The employee is currently enrolled in that plan. What causes this?

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.