Search Results gr_labels_tl




Overview
Explore in AI Chat

Overview

The GR_LABELS_TL table is a core translation table within the Oracle E-Business Suite (EBS) Process Manufacturing Regulatory Management (GR) module. It functions as a language-specific repository for the descriptive text of labels used in regulatory documents. Its primary role is to support the multilingual capabilities of the application by storing translated versions of label descriptions, ensuring that documents can be displayed or printed in the user's preferred language. Each unique label code defined in the base table (GR_LABELS_B) can have multiple corresponding rows in this table, one for each installed and active language.

Key Information Stored

The table stores the translated textual content for regulatory labels. Its structure is characteristic of EBS translation tables, utilizing a composite primary key and language columns. The most critical columns include:

  • LABEL_CODE: The unique identifier for the label, serving as a foreign key to GR_LABELS_B.
  • LANGUAGE: The code (e.g., 'US', 'F') representing the language of the translated description in this row. This column is a foreign key to FND_LANGUAGES.
  • LABEL_DESC: The actual translated description text that is displayed or printed on the document.
  • SOURCE_LANG: Indicates the original language in which the row was created. This is also a foreign key to FND_LANGUAGES and is used to identify the seed data row from which translations are made.

Common Use Cases and Queries

This table is primarily accessed to retrieve the appropriate label text for a user session or a specific document generation process. A common use case is generating a regulatory report, such as a material safety data sheet (MSDS) or product label, where the system must pull all descriptive text in the correct language. A typical query would join this table to its base table and filter by the session language.

Sample SQL Pattern:
SELECT glb.label_code, glt.label_desc
FROM gr_labels_b glb, gr_labels_tl glt
WHERE glb.label_code = glt.label_code
AND glt.language = USERENV('LANG')
AND glb.label_code = '<SPECIFIC_LABEL_CODE>';

For administrative purposes, such as verifying translation completeness, one might query for all labels missing a translation in a target language by comparing against the SOURCE_LANG rows.

Related Objects

The GR_LABELS_TL table has defined relationships with several key EBS objects, as documented in its foreign key constraints:

  • GR_LABELS_B: This is the base table that defines the core, non-translatable attributes of a label. The relationship is established via GR_LABELS_TL.LABEL_CODE → GR_LABELS_B. All label codes in the TL table must exist in the B table.
  • FND_LANGUAGES (Two Relationships): This application table lists all installed languages. GR_LABELS_TL references it twice:
    • Via GR_LABELS_TL.LANGUAGE → FND_LANGUAGES to validate the language of the translation.
    • Via GR_LABELS_TL.SOURCE_LANG → FND_LANGUAGES to validate the original source language of the data.

The table's primary key, GR_LABELS_TL_PK, is defined on the combination of LABEL_CODE and LANGUAGE, enforcing uniqueness of a label's translation per language.