Results for “drvbl_fctr_apls”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.BEN_ELIGY_PRFL_RL_D is a reporting and integration view in the Oracle E-Business Suite Advanced Benefits (Benefit) module, documented under ETRM 12.2.2 and applicable to 12.1.1 and 12.2.2 environments. The view flattens the eligibility profile rule model, exposing one row per eligibility profile rule (ben_eligy_prfl_rl_f) joined to its parent profile, its associated formula, the deriving/derived factor application flag lookup, and the identity of the user who last updated the row. Its primary role is to provide a readable, denormalized projection of the eligibility rule definition so that concurrent programs, extracts, and downstream reporting tools can present business-friendly names rather than numeric identifiers.

The name component "DRVBL_FCTR_APLS" referenced in the view's join predicates corresponds to the drvbl_fctr_apls_flag column, which is decoded through HR_LOOKUPS using lookup type YES_NO. This view is therefore frequently consulted when investigating how derived factors are applied within an eligibility profile rule.

Underlying Base Objects

The view is owned by APPS and is defined over the following documented base objects:

• BEN_ELIGY_PRFL_RL_F (SYNONYM) — the driving table, aliased ERL, supplying rule identifiers, effective dates, ordering, weights, and scores.
• BEN_ELIGY_PRFL_F (SYNONYM) — alias ELIGY_PRFL, the eligibility profile header providing the profile name.
• FF_FORMULAS_F (SYNONYM) — alias FORMULA, supplying the formula name attached to the rule.
• FND_USER (SYNONYM) — alias FUSER, resolving the last_updated_by value to a user name.
• HR_LOOKUPS (VIEW) — alias DRVBL_FCTR_APLS, decoding the drvbl_fctr_apls_flag into its display meaning.
• HR_API (PACKAGE) — referenced by the view metadata as an associated object supporting the effective-dating and lookup infrastructure.

All joins except the driving table use Oracle outer-join syntax ((+)), and both the profile and formula joins are additionally date-bounded using BETWEEN predicates on effective_start_date and effective_end_date. This date-sensitive join ensures that the profile and formula rows returned correspond to the effective period of the rule.

Key Columns

• ROW_ID — the ROWID of the underlying eligibility profile rule row, retained to support update-by-rowid operations in a Forms or ADF context.
• ELIGY_PRFL_RL_ID — primary identifier of the eligibility profile rule.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — datetrack effective range of the rule.
• ORDR_TO_APLY_NUM — the sequence in which the rule is evaluated relative to other rules in the profile.
• FORMULA_NAME — the name of the formula that computes or drives the rule outcome.
• NAME — the eligibility profile name from BEN_ELIGY_PRFL_F.
• MEANING — the decoded value of DRVBL_FCTR_APLS_FLAG from the YES_NO lookup, indicating whether derived factors apply.
• CRITERIA_WEIGHT / CRITERIA_SCORE — weighting and scoring attributes used in scored or weighted eligibility evaluation.
• LAST_UPDATE_DATE / USER_NAME — audit columns exposing when the rule was modified and by whom.

Common Use Cases and Queries

Typical uses include auditing eligibility profile rule configuration, tracing which formula underpins a given rule, verifying derived-factor application flags, and building extracts for benefits reconciliation.

List rules for a specific profile by name:

SELECT eligy_prfl_rl_id, name, ordr_to_aply_num, formula_name, meaning, criteria_score FROM apps.ben_eligy_prfl_rl_d WHERE name = :profile_name ORDER BY ordr_to_aply_num;

Identify rules where derived factors apply:

SELECT eligy_prfl_rl_id, name, formula_name, meaning FROM apps.ben_eligy_prfl_rl_d WHERE meaning = 'Yes';

Audit recent changes to eligibility rules:

SELECT eligy_prfl_rl_id, name, formula_name, user_name, last_update_date FROM apps.ben_eligy_prfl_rl_d WHERE last_update_date >= SYSDATE - 30 ORDER BY last_update_date DESC;

Because the view applies outer joins throughout, rules lacking an associated formula or profile still return rows, making it suitable for completeness and exception reporting as well as routine operational queries.