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 with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Context Values for BEN_PEN_BNFT_AMT DBI

I am using BEN_PEN_BNFT_AMT to get the employee benefit amount for a given effective date. The routing information (SQL) obtained from below query shows 7 bind variables for the DBI.

select * 
from ff_routes_b 
where route_id =(select ROUTE_ID from 
                 ff_user_entities_b 
                 where user_entity_id =(
        select user_entity_id 
        from ff_database_items_b 
        where BASE_USER_NAME = 'BEN_PEN_BNFT_AMT'))

I am getting below error when I use GET_CONTEXT method -

AFDICT_APP_PREFIX-FF-1605057: Formula LL_BENI117_EOI_TO_VOYA_EE_CURRENT_AMOUNT_FF, line 27, database item or local variable PLAN_ID used as a context.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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