Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Fast Formula function BEN_FN_GET_CHAR_VALUE is not returning the expected value — Cloud Customer Connect
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

Fast Formula function BEN_FN_GET_CHAR_VALUE is not returning the expected value

Received Response
1
Views
4
Comments

Summary:


Content (required):

Here is the code snippet:

CHANGE_CONTEXTS(EFFECTIVE_DATE = l_eval_dt)

l_waived_flag = BEN_FN_GET_CHAR_VALUE('BEN_PRTT_ENRT_RSLT','ENROLLED',l_waive_plan)

l_end_dt_char = BEN_FN_GET_CHAR_VALUE('BEN_PRTT_ENRT_RSLT','ENRT_CVG_THRU_DT',l_waive_plan)


l_waived_flag returns 'Y' but l_end_dt_char returns 'N' instead of a date


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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