Search Results ben_dlvry_mthd




Overview
Explore in AI Chat

Overview

APPS.BENBV_CM_DLVRY_MTHD_TYP_V is a read-only reporting view in the Oracle EBS Advanced Benefits (BEN) module. It exposes the "Communications Delivery Method Type" setup data, which defines the delivery methods (for example, print, email, or web) available for benefit communications such as enrollment confirmations and plan notices. The view is a "BV" (business view) object, the naming convention Oracle uses for views intended primarily for reporting, integration extracts, and external interfacing rather than for direct transactional updates.

The view carries the descriptive flexfield reference token _DF:BEN:BEN_CM_DLVRY_MTHD_TYP:CMT, signalling that the underlying entity is DFF-enabled, and it is declared WITH READ ONLY, so it cannot be used as a DML target. Rows are filtered by the session's business group through HR_BIS.GET_SEC_PROFILE_BG_ID, so multi-organization and security profile behaviour is inherited automatically.

Underlying Base Objects

The view is defined over two documented objects:

  • BEN_CM_DLVRY_MTHD_TYP (referenced via a synonym) — the base table holding delivery method type definitions. It supplies every ID, code, flag, and WHO (audit) column in the view.
  • HR_BIS (package) — a shared HR utility package invoked through two functions: BIS_DECODE_LOOKUP, which translates lookup codes into their user-facing meanings, and GET_SEC_PROFILE_BG_ID, which returns the current business group for row-level security.

Because the view resolves the synonym at runtime and calls the HR_BIS package, it is coupled to the APPS schema and the standard EBS security model. The synonym indirection is typical of BEN reporting views and should not be dropped.

Key Columns

  • CM_DLVRY_MTHD_TYP_ID — primary identifier for the delivery method type record.
  • CM_DLVRY_MTHD_TYP_CD — the lookup code value; decoded in the following column.
  • BIS_DECODE_LOOKUP('BEN_DLVRY_MTHD', CM_DLVRY_MTHD_TYP_CD) — the descriptive lookup meaning for the delivery method code (for example, the displayable name of the method).
  • DFLT_FLAG / decoded DFLT_FLAG — indicates whether the method is the default; the decoded column returns the Yes/No meaning via BIS_DECODE_LOOKUP('YES_NO', …).
  • RQD_FLAG / decoded RQD_FLAG — indicates whether the method is required; likewise decoded to a Yes/No meaning.
  • CM_TYP_ID — the parent communication type identifier, linking the delivery method to its communication type.
  • BUSINESS_GROUP_ID — the HR business group owning the row; drives security filtering.
  • CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include populating custom reports of available communication delivery methods, driving integration extracts, and validating data migration loads into the BEN setup tables. A basic query lists methods with readable meaning:

  • SELECT cm_dlvry_mthd_typ_cd, dflt_flag, rqd_flag FROM apps.benbv_cm_dlvry_mthd_typ_v ORDER BY cm_dlvry_mthd_typ_cd; — returns the coded values for the current business group only, because the view applies the security profile predicate automatically.
  • SELECT cm_dlvry_mthd_typ_id, cm_typ_id FROM apps.benbv_cm_dlvry_mthd_typ_v WHERE dflt_flag = 'Y'; — isolates the default delivery methods, useful when configuring communication defaults.
  • SELECT cm_typ_id, cm_dlvry_mthd_typ_id FROM apps.benbv_cm_dlvry_mthd_typ_v v WHERE EXISTS (SELECT 1 FROM apps.ben_cm_typ t WHERE t.cm_typ_id = v.cm_typ_id); — joins the delivery methods back to their parent communication types for reporting.

Since the view is read-only and security-restricted, any attempt to modify data must be directed to the base table BEN_CM_DLVRY_MTHD_TYP through the standard BEN forms or APIs, not through this view.