Results for “cagr_default”

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

Overview

APPS.PER_CAGR_ENTITLEMENT_LINES_V is a reporting and integration view in Oracle EBS Release 12.1.1 and 12.2.2 that exposes the line-level detail of Collective Approval Grade Rates (CAGR) entitlement definitions. It is built on the PER_CAGR_ENTITLEMENT_LINES_F base table and enriches each entitlement line with decoded, human-readable descriptions for lookup-driven and value-set-driven columns. This makes the view particularly useful for extracts, BI Publisher reports, and integration interfaces where raw coded values must be translated without requiring the consuming application to call HR lookup or value-set APIs directly.

The view's name and structure reflect its role in the Oracle Advanced Benefits / Total Compensation entitlement model, where entitlement lines define grade-spine, spinal point, and eligibility-profile restrictions on Collective Approval Grade Rates. The user search term "cagr_default" corresponds directly to the view's use of the lookup type CAGR_DEFAULT in the ELIGIBLITY_PROFILE_NAME column.

Underlying Base Objects

According to the documented ETRM metadata for 12.2.2, the view is owned by APPS and references the following base objects:

• PER_CAGR_ENTITLEMENT_LINES_F (synonym) — the primary transaction table holding entitlement line rows.
• BEN_ELIGY_PRFL (view) — supplies the eligibility profile name for lines referencing a real eligibility profile.
• FND_SESSIONS (synonym) — used to filter rows by effective date relative to the current session.
• HR_GENERAL (package) — provides DECODE_LOOKUP for decoding CAGR_MANDATORY and CAGR_STATUS.
• PER_CAGR_UTILITY_PKG (package) — provides GET_NAME_FROM_VALUE_SET to translate VALUE, RANGE_FROM, and RANGE_TO codes into names.
• PER_GRADE_SPINES_V, PER_PARENT_SPINES, PER_SPINAL_POINT_STEPS_V — join sources for grade spine, parent spine, and spinal point descriptors.

All descriptive joins against BEN_ELIGY_PRFL, PER_PARENT_SPINES, and PER_SPINAL_POINT_STEPS_V are outer joins, so entitlement lines without a matching spine or step are still returned.

Key Columns

• CAGR_ENTITLEMENT_LINE_ID — primary key of the entitlement line.
• MANDATORY / MANDATORY_DESC — flag and decoded description indicating whether the line is mandatory.
• VALUE / VALUE_DESC — the entitlement value and its decoded name from the value set.
• RANGE_FROM / RANGE_FROM_DESC, RANGE_TO / RANGE_TO_DESC — range boundaries and their decoded names.
• GRADE_NAME, PARENT_SPINE_NAME, SPINAL_POINT, FROM_SPINAL_POINT, TO_SPINAL_POINT — descriptive grade and spine information.
• STATUS / STATUS_DESC — status code and decoded description via CAGR_STATUS lookup.
• ELIGY_PRFL_ID / ELIGIBLITY_PROFILE_NAME — eligibility profile identifier and name. When ELIGY_PRFL_ID is 0, the name is derived from the CAGR_DEFAULT lookup (DECODE(PCL.ELIGY_PRFL_ID,0,HR_GENERAL.DECODE_LOOKUP('CAGR_DEFAULT','DEF'),BEP.NAME)).
• EFFECTIVE_START_DATE, EFFECTIVE_END_DATE — date-effective range of the line.
• OIPL_ID — link to the originating OIPL record.
• LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER — standard audit and concurrency columns.

Common Use Cases and Queries

Typical uses include reporting on effective entitlement lines for a given date, extracting grade-rate restrictions for downstream payroll or compensation interfaces, and validating that every entitlement references either a real eligibility profile or the CAGR_DEFAULT lookup value.

Example: list entitlement lines with decoded values as of the current session.

• SELECT cagr_entitlement_line_id, mandatory_desc, value_desc, range_from_desc, range_to_desc, grade_name, eligiblity_profile_name FROM apps.per_cagr_entitlement_lines_v WHERE cagr_entitlement_id = :p_entitlement_id;

Example: find lines using the CAGR_DEFAULT eligibility profile.

• SELECT cagr_entitlement_line_id, eligiblity_profile_name FROM apps.per_cagr_entitlement_lines_v WHERE eligy_prfl_id = 0;

Example: retrieve currently effective lines for a grade spine.

• SELECT grade_name, status_desc, effective_start_date, effective_end_date FROM apps.per_cagr_entitlement_lines_v WHERE grade_spine_id = :p_grade_spine_id;

Because the view is filtered by FND_SESSIONS and USERENV('SESSIONID'), it must be queried in an EBS session context to return rows.