Results for “beneficial_rule_value_set”

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

Overview

APPS.PER_CAGR_ENTITLEMENT_ITEMS_V is a reporting and integration view in Oracle E-Business Suite (12.1.1 and 12.2.2) that exposes the configuration of entitlement items used by the Collective Agreement (CAGR) framework within Oracle Payroll and Oracle Human Resources. An entitlement item defines how a specific element, input value, or API parameter is populated when the CAGR engine evaluates collective agreement rules for an employee assignment. The view joins the transactional entitlement-item definition to its translated name, the associated API definition, the API parameter metadata, the element and input value names, and the descriptive flexfield value set names used for validation and beneficial rule resolution.

The inclusion of the BENEFICIAL_RULE_VALUE_SET column makes this view the primary reference point for the search term "beneficial_rule_value_set." That column returns the name of the FND flexfield value set that constrains the values a beneficial rule may take, and it is derived from the BENEFICIAL_RULE_VALUE_SET_ID foreign key on PER_CAGR_ENTITLEMENT_ITEMS.

Underlying Base Objects

The view is defined over a mixture of base tables, TL tables, views, and synonyms, joined mainly through outer joins (noted by the (+) operator) so that entitlement items remain visible even when optional related records are absent:

• PER_CAGR_ENTITLEMENT_ITEMS (synonym) — the primary table, aliased CEI.
• PER_CAGR_ENTITLEMENT_ITEMS_TL (synonym) — the translated name table, aliased CEITL, joined on language = USERENV('LANG').
• PER_CAGR_APIS (synonym) — aliased PCA, supplies API_NAME.
• PER_CAGR_API_PARAMETERS (synonym) — aliased CAP, supplies DISPLAY_NAME, DEFAULT_UOM, UOM_PARAMETER, and UOM_LOOKUP.
• PAY_ELEMENT_TYPES_V (view) — aliased PET, supplies ELEMENT_NAME.
• PAY_INPUT_VALUES_V (view) — aliased PIV, supplies INPUT_VALUE_NAME.
• FND_FLEX_VALUE_SETS — aliased F and B, supplying FLEX_VALUE_SET_NAME and BENEFICIAL_RULE_VALUE_SET respectively.
• HR_GENERAL (package) — invoked via hr_general.decode_lookup to translate lookup codes.

Key Columns

• CAGR_ENTITLEMENT_ITEM_ID / BUSINESS_GROUP_ID — primary identifier and the business group that owns the item.
• ITEM_NAME / ELEMENT_NAME / INPUT_VALUE_NAME — the entitlement item, its target element, and the input value it feeds.
• BENEFICIAL_RULE and BENEFICIAL_RULE_DESC — the rule code and its decoded description from the CAGR_BENEFICIAL_RULE lookup.
• BENEFICIAL_RULE_VALUE_SET_ID and BENEFICIAL_RULE_VALUE_SET — the flexfield value set ID and name, joined from FND_FLEX_VALUE_SETS aliased B.
• FLEX_VALUE_SET_ID and FLEX_VALUE_SET_NAME — the value set used for general validation.
• CAGR_API_ID / API_NAME / CAGR_API_PARAM_ID / DISPLAY_NAME — the API and parameter this item maps to.
• COLUMN_TYPE, COLUMN_SIZE, CATEGORY_NAME (with decoded _DESC), UOM (with UOM_DESC), and the MULTIPLE_ENTRIES_ALLOWED_FLAG / AUTO_CREATE_ENTRIES_FLAG controls.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical uses include auditing collective agreement entitlement setup, resolving which beneficial rule value set governs an item, and integrating CAGR configuration into downstream systems. A representative query lists entitlement items with their rule value set:

• SELECT item_name, beneficial_rule, beneficial_rule_value_set FROM per_cagr_entitlement_items_v WHERE beneficial_rule_value_set IS NOT NULL;
• SELECT element_name, input_value_name, api_name, uom_desc FROM per_cagr_entitlement_items_v WHERE business_group_id = :p_bg_id;
• SELECT category_name_desc, column_type_desc, column_size FROM per_cagr_entitlement_items_v ORDER BY category_name_desc;

Because the view applies USERENV('LANG'), translated item names return in the session language. Access is governed by the APPS schema, and the standard audit columns support change tracking and interface validation.