Results for “cagr_message_level”

12 results




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

Overview

APPS.PER_CAGR_ENTITLEMENTS_V is a reporting and integration view within the Oracle E-Business Suite Enterprise Technology and Reporting Model (ETRM), specifically aligned with the Collective Agreements (CAGR) functionality used by Oracle Payroll and Oracle Human Resources. The view exposes entitlement records defined against collective agreements, joining the transactional entitlement rows in PER_CAGR_ENTITLEMENTS with descriptive attributes resolved from the entitlement item definition view (PER_CAGR_ENTITLEMENT_ITEMS_V) and the collective agreement header (PER_COLLECTIVE_AGREEMENTS). Its principal design objective is to present decoded, human-readable values in place of internal lookup codes — status, beneficial rule, formula criteria, and message level are all passed through HR_GENERAL.DECODE_LOOKUP — so that downstream reports, extracts, and interfaces do not need to re-implement lookup translation logic. The object is defined in the APPS schema and is available in both EBS 12.1.1 and 12.2.2, with documented metadata recorded against the 12.2.2 ETRM release.

Underlying Base Objects

The view text is constructed from four primary sources. PER_CAGR_ENTITLEMENTS (referenced through a synonym) supplies the entitlement header, including its collective agreement, dates, status, formula, and message level. PER_CAGR_ENTITLEMENT_ITEMS_V provides the item-level definition, contributing ITEM_NAME, CATEGORY_NAME, BENEFICIAL_RULE, PARAMETER_LOOKUP_TYPE, ELEMENT_NAME, ELEMENT_TYPE_ID, INPUT_VALUE_NAME, INPUT_VALUE_ID, UOM_DESC, and the flexfield value set identifiers. PER_COLLECTIVE_AGREEMENTS (also a synonym) supplies the agreement name, and FF_FORMULAS is outer-joined so that entitlements without an associated formula are still returned. FND_SESSIONS is included in the WHERE clause to satisfy effective-date and session context; the join uses HR_GENERAL.END_OF_TIME for open-ended entitlements. Supporting packages listed in the metadata — HR_API, HR_CHKFMT, HR_GENERAL, and PAY_INPUT_VALUES_PKG — provide the lookup decoding, date handling, and input value validation used by the underlying item view.

Key Columns

Common Use Cases and Queries

Typical uses include reporting entitlement coverage by collective agreement, exporting entitlement definitions for payroll validation, and auditing decoded status or message-level values without re-deriving lookup meanings.

To list entitlements for a collective agreement with decoded status and message level:

SELECT collective_agreement_name, item_name, status_desc,
       message_level_desc, start_date, end_date, formula_name
  FROM apps.per_cagr_entitlements_v
 WHERE status = 'A'
 ORDER BY collective_agreement_name, item_name;

To find entitlements carrying a specific message level, filtering on the decoded description avoids hard-coding lookup codes:

SELECT cagr_entitlement_id, collective_agreement_name, item_name,
       message_level_desc
  FROM apps.per_cagr_entitlements_v
 WHERE UPPER(message_level_desc) LIKE '%WARNING%';

Because the view restricts results to sessions current on the system date against the entitlement's effective window, queries return only entitlements active for the invoking session — a behaviour worth noting when historical or future-dated records are required.