Results for “dss_group_name”

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

Overview

HZ_DSS_GROUPS_TL is the translation (language) table for the Trading Community Architecture decision-support / data-sharing group definitions in Oracle E-Business Suite. It is owned by the AR (Receivables) schema and is present in both 12.1.1 and 12.2.2 releases, where it carries a VALID status. The "_TL" suffix follows the standard Oracle EBS multilingual convention: the base table (HZ_DSS_GROUPS_B) stores language-independent attributes and codes, while HZ_DSS_GROUPS_TL stores the translatable, user-facing text such as group names and descriptions for each installed language.

DSS groups represent logical groupings used by the Receivables and Trading Community data-sharing/partitioning framework to control how customer, party, and account data is scoped and shared across operating units. In this context HZ_DSS_GROUPS_TL supplies the localized labels that appear in setup and inquiry screens for those groups.

From a Data Vault modeling perspective, the FK topology is best understood heuristically as a link: the table does not act as a pure hub or a change-tracking satellite, but rather as the object that associates a DSS group code with a language and a source language. Practically, it behaves as a language-dependent extension of the HZ_DSS_GROUPS_B hub, keyed by (DSS_GROUP_CODE, LANGUAGE).

Key Information Stored

The table contains 11 documented columns. The most significant are:

• DSS_GROUP_CODE — the language-independent key that identifies the DSS group; together with LANGUAGE it forms the primary key HZ_DSS_GROUPS_TL_PK. It is the join column back to HZ_DSS_GROUPS_B.
• LANGUAGE — the installed language code (validated against FND_LANGUAGES) for which the translatable text is supplied.
• SOURCE_LANG — the language from which the translation was derived, also validated against FND_LANGUAGES; used in the oracle translation workflow.
• DSS_GROUP_NAME — the user-facing, translatable name of the DSS group displayed in forms and reports.
• DESCRIPTION — the translatable, free-text description of the group's purpose.
• LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — the standard audit set documenting when and by whom the row was last changed.
• CREATION_DATE / CREATED_BY — the standard creation audit fields.
• ZD_EDITION_NAME — the editioning column supporting Online Patching in 12.2.x, included in the unique indexes.

The surrogate primary key is defined by the index HZ_DSS_GROUPS_TL_PK on (DSS_GROUP_CODE, LANGUAGE). The documented business-key unique indexes are HZ_DSS_GROUPS_TL_U1 on (DSS_GROUP_CODE, LANGUAGE, ZD_EDITION_NAME) and HZ_DSS_GROUPS_TL_U2 on (DSS_GROUP_NAME, LANGUAGE, ZD_EDITION_NAME), the latter enforcing uniqueness of the displayed name per language.

Common Use Cases and Queries

The table is primarily used to retrieve localized group names and descriptions, and to validate the completeness of translations across the languages installed in FND_LANGUAGES. A common query resolves the display name for a given language:

• SELECT DSS_GROUP_CODE, DSS_GROUP_NAME, DESCRIPTION FROM HZ_DSS_GROUPS_TL WHERE LANGUAGE = USERENV('LANG' or a specific FND language code);
• Joining to the base table: SELECT b.DSS_GROUP_CODE, t.DSS_GROUP_NAME FROM HZ_DSS_GROUPS_B b, HZ_DSS_GROUPS_TL t WHERE b.DSS_GROUP_CODE = t.DSS_GROUP_CODE AND t.LANGUAGE = 'US';
• Translation gap analysis: compare SOURCE_LANG rows against target languages to identify groups lacking a translation.
• Reporting by uniqueness: use HZ_DSS_GROUPS_TL_U2 to ensure DSS_GROUP_NAME is not duplicated per language.

Report developers should always filter on LANGUAGE to avoid returning one row per installed language.

Related Objects

The documented relationships identify the following significant objects:

• HZ_DSS_GROUPS_B — the base (language-independent) table, joined on DSS_GROUP_CODE.
• FND_LANGUAGES — referenced twice: LANGUAGE and SOURCE_LANG both validate against the installed-language definitions.
• HZ_DSS_GROUPS_TL_PK / _U1 / _U2 — the primary key and unique indexes defining access paths and business-key constraints.
• HZ_DSS_GROUPS_VL / _V — the standard ML view layer that joins base and translation rows for forms and concurrent programs.
• ZD_EDITION_NAME — the editioning attribute enabling Online Patching compatibility in 12.2.2.