Results for “hz_dss_groups_vl”

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

Overview

HZ_DSS_GROUPS_VL is a view owned by the APPS schema in Oracle E-Business Suite, registered under the Receivables (AR) product family. It presents group definitions maintained within the Oracle Data Subset Selection (DSS) framework used by the Trading Community Architecture (TCA). These groups are used to categorize and rank registry records so that the data classification and matching processes in HZ (TCA) can select the correct set of records for downstream processing, such as customer matching, deduplication, or external data synchronization through the Bulk Export/Import Service (BES).

The "_VL" suffix follows the standard Oracle EBS naming convention denoting a "view with language" — that is, a view that joins a base table to its translation table and filters the translation by the session language. As a result, HZ_DSS_GROUPS_VL exposes both the operational attributes stored at the group level and the language-sensitive descriptive text, returning only the translation rows corresponding to the language of the current session (USERENV('LANG')). This makes the view suitable for reports, concurrent programs, and integrations that require user-facing group names and descriptions in the appropriate language.

Underlying Base Objects

The ETRM metadata documents HZ_DSS_GROUPS_VL as being defined over two referenced base objects, both accessed through synonyms in the APPS schema:

• HZ_DSS_GROUPS_B — the base (non-translated) table holding the DSS group code, rank, status, BES enable flag, and standard WHO/audit columns.
• HZ_DSS_GROUPS_TL — the translation (TL) table holding the language-specific group name and description, keyed by DSS_GROUP_CODE and LANGUAGE.

The view is defined by an inner join between these tables on the DSS_GROUP_CODE column, constrained by T.LANGUAGE = USERENV('LANG'). Only rows that exist in both the base and the translation table for the current language are returned. The B table supplies the operational attributes, while the TL table supplies the displayable text.

Key Columns

• DSS_GROUP_CODE — the primary identifier of the DSS group; the join key between the _B and _TL tables.
• RANK — the numeric ranking assigned to the group, used to order or prioritize groups during data subset selection.
• STATUS — the enabled/active status of the group definition.
• BES_ENABLE_FLAG — indicates whether the group is enabled for the Bulk Export/Import Service processing.
• DSS_GROUP_NAME — the language-specific name of the group, sourced from the translation table.
• DESCRIPTION — the language-specific description of the group, sourced from the translation table.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns recording creation and last modification details.
• OBJECT_VERSION_NUMBER — the optimistic locking version number used by the TCA APIs.

Common Use Cases and Queries

This view is typically referenced when reporting on configured DSS groups, validating group enablement for BES processing, or joining group codes to registry records that reference them. Because it resolves the current-language name and description, it is the preferred source for user-facing listings and LOV-style queries.

A basic listing of enabled groups ordered by rank:

• SELECT dss_group_code, dss_group_name, description, rank FROM hz_dss_groups_vl WHERE status = 'A' AND bes_enable_flag = 'Y' ORDER BY rank;

To look up a specific group by its code:

• SELECT dss_group_code, dss_group_name, status, bes_enable_flag FROM hz_dss_groups_vl WHERE dss_group_code = :p_group_code;

To join group definitions to dependent registry data, the view's DSS_GROUP_CODE can be correlated to the corresponding group column in the HZ registry tables. In all cases, the language filter is applied automatically by the view, so no additional LANGUAGE predicate is required in client SQL.