Search Results ben_wv_prtn_rsn




Overview
Explore in AI Chat

Overview

APPS.BEN_WV_PRTN_RSN_PTIP_D is a reporting and inquiry view within the Oracle E-Business Suite Advanced Benefits (BEN) module. It exposes configuration data that links a Plan Type in Program (PTIP) record to waived participation reason codes, presenting the raw foreign key identifiers in a denormalized, human-readable form. The view is one of the "_D" (descriptive) views in the BEN schema family, whose purpose is to translate coded columns into their descriptive meanings while retaining the surrogate keys and effective-dating attributes required by forms, concurrent programs, and downstream integrations.

Its primary role is to support user-facing inquiries on the "Waive Participation Reason" setup. Rather than joining the underlying tables manually, developers and report authors can select from this single view to obtain the program name, plan type name, default flag meaning, and the descriptive meaning of the waive participation reason code. The view is defined in the APPS schema and is available for read-only access across the EBS 12.1.1 and 12.2.2 releases.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects: BEN_PGM (VIEW), BEN_PL_TYP (VIEW), BEN_PTIP_F (SYNONYM), BEN_WV_PRTN_RSN_PTIP_F (SYNONYM), FND_USER (SYNONYM), HR_API (PACKAGE), and HR_LOOKUPS (VIEW). The driving table is BEN_WV_PRTN_RSN_PTIP_F, aliased WPT in the definition text. It is outer-joined to BEN_PTIP_F (plan type in program) via PTIP_ID, to FND_USER via LAST_UPDATED_BY, and twice to HR_LOOKUPS — once for the reason code lookup type 'BEN_WV_PRTN_RSN' and once for the default flag lookup type 'YES_NO'. Inner joins connect BEN_PTIP_F to BEN_PGM (PGM_ID) and BEN_PL_TYP (PL_TYP_ID), which supplies the program and plan type names surfaced in the view. Because BEN_PGM and BEN_PL_TYP are themselves views, the effective lineage extends further into the BEN base tables, but the documented dependency surface remains the objects listed above.

Key Columns

  • ROW_ID — the ROWID of the BEN_WV_PRTN_RSN_PTIP_F row, used by Oracle Forms for row identification.
  • WV_PRTN_RSN_PTIP_ID — primary key of the waive participation reason PTIP record.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-tracked effective dating attributes governing row validity.
  • PGM.NAME and TYP.NAME — the program name (from BEN_PGM) and plan type name (from BEN_PL_TYP) to which the rule applies.
  • WV_PRTN_RSN.MEANING — descriptive meaning of the waive participation reason lookup code.
  • DFLT.MEANING — meaning of the default flag, resolved through the YES_NO lookup.
  • LAST_UPDATE_DATE and LAST_UPDATED_BY — audit columns; LAST_UPDATED_BY is resolved through FND_USER.

Common Use Cases and Queries

Typical scenarios include auditing which reasons are configured as defaults for a given plan type, validating setup prior to benefits open enrollment, and feeding extracts into data warehouses. A representative query follows:

SELECT wv_ptip_id, program_name, plan_type_name, waive_reason_meaning, default_meaning
FROM apps.ben_wv_prtn_rsn_ptip_d
WHERE SYSDATE BETWEEN effective_start_date AND effective_end_date;

Because the view already resolves program, plan type, and lookup meanings, it eliminates the need for ad-hoc joins and is a preferred source for reporting on waive participation reason configuration in Oracle EBS 12.1.1 and 12.2.2.