Search Results hz_dss_groups_tl




Overview
Explore in AI Chat

Overview

The HZ_DSS_GROUPS_TL table is a translation table within the Oracle E-Business Suite (EBS) Receivables (AR) module. It stores translated, language-specific descriptions for Data Security Suite (DSS) groups defined in the base table HZ_DSS_GROUPS_B. DSS groups are a core component of the Trading Community Architecture (TCA) Data Security model, used to control user access to party and customer data based on configurable business rules. The primary role of HZ_DSS_GROUPS_TL is to enable the multilingual display of DSS group names within the application's user interface, supporting global deployments of Oracle EBS versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is characteristic of an EBS translation table. Its critical columns, as indicated by the primary and foreign key constraints, include DSS_GROUP_CODE, LANGUAGE, and SOURCE_LANG. The DSS_GROUP_CODE is the unique identifier that links each translated row to its corresponding record in the HZ_DSS_GROUPS_B base table. The LANGUAGE column stores the language code (e.g., 'US' for American English, 'KO' for Korean) and is a foreign key to FND_LANGUAGES, ensuring data integrity for installed languages. The SOURCE_LANG column identifies the original language in which the data was entered, also referencing FND_LANGUAGES. The most significant data column, though not explicitly listed in the brief metadata, is typically DESCRIPTION or GROUP_NAME, which holds the translated text for the DSS group in the specified language.

Common Use Cases and Queries

This table is primarily accessed by the application's internal translation engine to present localized content. Common operational and reporting scenarios include generating user-facing lists of DSS groups in a session's language for assignment purposes or auditing translation coverage. A typical query to retrieve translated descriptions for a specific DSS group across all installed languages would join to FND_LANGUAGES for the language name.

  • Sample Query: SELECT g.DSS_GROUP_CODE, t.LANGUAGE, l.LANGUAGE_NAME, t.DESCRIPTION FROM HZ_DSS_GROUPS_B g, HZ_DSS_GROUPS_TL t, FND_LANGUAGES l WHERE g.DSS_GROUP_CODE = t.DSS_GROUP_CODE AND t.LANGUAGE = l.LANGUAGE_CODE(+) AND g.DSS_GROUP_CODE = '&GROUP_CODE';
  • Reporting Use Case: Identifying DSS groups missing translations for key languages by comparing records in HZ_DSS_GROUPS_TL against the list of active languages in FND_LANGUAGES.

Related Objects

HZ_DSS_GROUPS_TL has defined dependencies on several core EBS objects, as per the provided foreign key metadata. Its primary relationship is with the base table HZ_DSS_GROUPS_B, which stores the language-independent attributes of the DSS group. All translations are meaningless without a corresponding base record. Furthermore, it has two foreign key relationships to the application foundation table FND_LANGUAGES: one for the LANGUAGE column and another for the SOURCE_LANG column. This ensures all language codes used are valid within the EBS instance. The table is also integral to the larger TCA Data Security framework, which involves objects like HZ_DSS_GROUP_ASSIGNMENTS for rule assignments and the underlying Data Security Manager APIs.