Search Results leav_reas




Overview
Explore in AI Chat

Overview

APPS.BEN_LVG_RSN_RT_D is a reporting and inquiry view within the Oracle E-Business Suite Advanced Benefits (Oracle Benefits) module. It exposes leave-of-absence reason records associated with variable rate profiles, resolving surrogate identifiers into human-readable descriptions. The view is a denormalized, read-only presentation layer over the transactional table BEN_LVG_RSN_RT_F, joining lookup meanings, profile names, and user audit information so that reporting tools, concurrent programs, and integration extracts can retrieve leave reason configurations without performing multiple joins themselves.

Its role is primarily descriptive rather than transactional. No DML is supported against the view; inserts, updates, and deletes must target the underlying BEN_LVG_RSN_RT_F table through the standard Benefits forms or the HR_API package. The "_D" suffix in the object name follows the Oracle EBS naming convention for a "detail" or display view, indicating it is intended for query and reporting consumption.

Underlying Base Objects

The view is defined over the following documented objects:

The join to BEN_VRBL_RT_PRFL_F is date-sensitive: the leave reason record's EFFECTIVE_START_DATE must fall between the profile's effective start and end dates, and both sides of that range predicate are outer-joined to prevent suppression of records lacking a matching effective profile row.

Key Columns

  • ROW_ID — the ROWID of the underlying BEN_LVG_RSN_RT_F row, useful for direct row addressing.
  • LVG_RSN_RT_ID — primary key of the leave reason rate record.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-effective bounds governing when the configuration is valid.
  • EXCLD_FLAG — indicates whether the leave reason is excluded from the associated rate processing.
  • NAME — the variable rate profile name from BEN_VRBL_RT_PRFL_F.
  • MEANING — the user-facing description of the leave reason code from HR_LOOKUPS for LOOKUP_TYPE 'LEAV_REAS'.
  • ORDR_NUM — display ordering sequence for the leave reason.
  • LAST_UPDATE_DATE and USER_NAME — audit columns identifying when and by whom the record was last modified.

Common Use Cases and Queries

Typical scenarios include validating leave reason configuration for a variable rate profile, auditing changes to exclusion flags, and driving extracts that feed payroll or absence interfaces.

List all leave reasons for a given profile:

  • SELECT lvg_rsn_rt_id, name, meaning, ordr_num, exclD_flag FROM apps.ben_lvg_rsn_rt_d WHERE name = :profile_name ORDER BY ordr_num;

Audit recent changes:

  • SELECT lvg_rsn_rt_id, meaning, last_update_date, user_name FROM apps.ben_lvg_rsn_rt_d WHERE last_update_date >= :since_date ORDER BY last_update_date DESC;

Identify excluded reasons within a date range:

  • SELECT meaning, effective_start_date, effective_end_date FROM apps.ben_lvg_rsn_rt_d WHERE excld_flag = 'Y' AND effective_start_date BETWEEN :start_date AND :end_date;

Because the view performs the lookup and profile resolution internally, these queries avoid manual joins to HR_LOOKUPS and BEN_VRBL_RT_PRFL_F, simplifying report SQL in Oracle EBS 12.1.1 and 12.2.2 environments.