Search Results gr_eurohazards_tl_pk




Overview
Explore in AI Chat

Overview

The GR_EUROHAZARDS_TL table is a core data object within the Oracle E-Business Suite Process Manufacturing Regulatory Management (GR) module. Specifically, it functions as a translation table (indicated by the '_TL' suffix) designed to support the multilingual capabilities of the application. Its primary role is to store language-specific textual descriptions for hazard classifications, a critical component for managing regulatory compliance, particularly with European Union (EU) regulations like CLP (Classification, Labelling and Packaging). This table enables the system to present hazard information in the language of the end-user or as required by regional regulatory submissions, ensuring accurate and locale-appropriate communication of safety data.

Key Information Stored

The table stores translated descriptions linked to a base hazard classification code. Its structure is defined by a composite primary key and several foreign key relationships. The most critical columns include:

  • HAZARD_CLASSIFICATION_CODE: The unique identifier for a hazard classification, serving as the link to the base data table (GR_EUROHAZARDS_B).
  • LANGUAGE: The code (e.g., 'US', 'DE', 'FR') representing the language for the translated description in this row. It references the FND_LANGUAGES table.
  • SOURCE_LANG: Indicates the original language in which the data was entered. This column is used by the Oracle Applications translation architecture to identify which records require translation and to manage the synchronization of translated data. It also references FND_LANGUAGES.
  • DESCRIPTION: The actual translated textual description of the hazard classification in the specified LANGUAGE.

Common Use Cases and Queries

This table is essential for any process or report requiring hazard information in a language other than the base installation language. Common scenarios include generating Safety Data Sheets (SDS) or product labels for different countries, populating multilingual regulatory reports for EU authorities, and displaying hazard data within the EBS user interface based on a user's session language. A typical query to retrieve all French translations for active hazards would join the translation table with its base table and the languages table:

SELECT b.HAZARD_CLASSIFICATION_CODE, tl.DESCRIPTION AS FRENCH_DESCRIPTION
FROM GR.GR_EUROHAZARDS_B b,
GR.GR_EUROHAZARDS_TL tl,
FND_LANGUAGES l
WHERE b.HAZARD_CLASSIFICATION_CODE = tl.HAZARD_CLASSIFICATION_CODE
AND tl.LANGUAGE = l.LANGUAGE_CODE
AND l.NLS_LANGUAGE = 'French'
AND b.ENABLED_FLAG = 'Y';

Related Objects

The GR_EUROHAZARDS_TL table has defined dependencies on several key EBS objects, as documented in its foreign key relationships:

  • GR_EUROHAZARDS_B: This is the base table. The relationship is defined on the column GR_EUROHAZARDS_TL.HAZARD_CLASSIFICATION_CODE, which references the primary key in GR_EUROHAZARDS_B. Every translation record must correspond to a valid record in this base table.
  • FND_LANGUAGES (Two References): The table references the FND_LANGUAGES table twice for validation.
    • First, on the column GR_EUROHAZARDS_TL.LANGUAGE to ensure the translation language is a valid, installed language in EBS.
    • Second, on the column GR_EUROHAZARDS_TL.SOURCE_LANG to validate the code for the source language of the record.

The primary key for the table is GR_EUROHAZARDS_TL_PK, which is a composite key on the columns (HAZARD_CLASSIFICATION_CODE, LANGUAGE).