Search Results ben_plan_design_hgrid_vw




Overview
Explore in AI Chat

Overview

The BEN_PLAN_DESIGN_HGRID_VW view is a reporting and integration construct within the Oracle Advanced Benefits (BEN) module. Its documented purpose is to present the Plan Design H-Grid — a hierarchical, grid-oriented representation of copy entity results that drive the Benefits plan configuration copy process. In Oracle EBS 12.1.1 and 12.2.2, this view is owned by the APPS schema with a status of VALID and is classified as a VIEW object type.

The view is of particular interest to technical consultants and developers who encounter the search term pqh_copy_entity_results, because it exposes copy entity result data originally associated with the PQH (Human Resources copy framework) tables, but sourced from the Benefits-specific BEN_COPY_ENTITY_RESULTS synonym. It therefore serves as a bridge between the generic copy framework and Benefits plan design configuration screens. The DISTINCT and UNION constructs in the view text indicate it is designed to produce a de-duplicated, two-tier grid: a label tier and a data tier.

Underlying Base Objects

The ETRM metadata documents two referenced base objects:

  • BEN_COPY_ENTITY_RESULTS (SYNONYM) — the Benefits-specific copy entity results store, supplying the transactional and structural copy data.
  • PQH_TABLE_ROUTE_VL (VIEW) — the table route view that provides display names and routing metadata for the copy framework.

The view joins these on TABLE_ROUTE_ID and filters on TRE.HIDE_TABLE_FOR_VIEW_FLAG = 'N' and CER.RESULT_TYPE_CD = 'DISPLAY'. A UNION combines a synthetic label row (hard-coded -1 values, TYPE = 'LABEL') with actual data rows (TYPE = 'DATA'). Both branches reference PQH_TABLE_ROUTE_VL, confirming the view's dependency on the copy framework's routing definitions while sourcing results from the Benefits synonym.

Key Columns

  • COPY_ENTITY_RESULT_ID — Unique identifier of the copy entity result; set to -1 for label rows.
  • COPY_ENTITY_TXN_ID — The copy transaction to which the result belongs.
  • NUMBER_OF_COPIES — Count of copies; defaults to -1 for label rows.
  • PARENT_ENTITY_RESULT_ID — Parent result for hierarchical grid rendering; NVL(..., -1) ensures label roots.
  • TABLE_ROUTE_ID — Links to the table route definition in PQH_TABLE_ROUTE_VL.
  • NAME — Display name from the table route, or INFORMATION5 for data rows.
  • TYPE — Distinguishes 'LABEL' header rows from 'DATA' rows.
  • SELECTION_DISABLED_FLAG — Derived from SELECT_ALLOWED_FLAG; controls grid selection.
  • CSS_STYLE — Presentation hint (ORADATATEXT / ORATABLECELLTEXT).

Common Use Cases and Queries

This view is typically consumed by the Benefits plan design H-Grid UI and by diagnostic queries investigating copy entity behaviour. A representative query retrieving data rows for a given transaction is:

  • SELECT COPY_ENTITY_RESULT_ID, TABLE_ROUTE_ID, NAME, SELECTION_DISABLED_FLAG FROM BEN_PLAN_DESIGN_HGRID_VW WHERE TYPE = 'DATA' AND COPY_ENTITY_TXN_ID = :txn_id ORDER BY NAME;
  • SELECT TYPE, COUNT(*) FROM BEN_PLAN_DESIGN_HGRID_VW GROUP BY TYPE;

The second query is useful for validating grid structure — confirming one label row per route versus many data rows. Because the view embeds the Benefits copy framework, it is the appropriate surface for troubleshooting pqh_copy_entity_results-related configuration issues in an Advanced Benefits implementation.