Search Results gr_multilingual_name_tl




Overview
Explore in AI Chat

Overview

The GR_MULTILINGUAL_NAME_TL table is a core data object within the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as a translation table, centralizing the storage of multilingual textual names associated with regulated items. Its primary role is to support global regulatory compliance by enabling the management of item names—such as Document, Shipping, Trade, and Chemical Family Names—in multiple languages. This functionality is critical for generating accurate safety data sheets, product labels, and shipping documentation that adhere to regional legal requirements across different countries and languages.

Key Information Stored

The table's structure is designed to link an item with specific name types (labels) and their corresponding translations. The primary key is a composite of ITEM_CODE, LANGUAGE, and LABEL_CODE, ensuring a unique entry for each item-label-language combination. Key columns include ITEM_CODE, which references the base regulated item in GR_ITEM_GENERAL; LANGUAGE and SOURCE_LANG, which reference FND_LANGUAGES to store the translation language and the original language of the data, respectively; and LABEL_CODE, which references GR_LABELS_B to define the type of name being stored (e.g., trade name, shipping name). The table also contains columns for the translated NAME itself and standard WHO columns (CREATION_DATE, CREATED_BY, etc.) for auditing.

Common Use Cases and Queries

A primary use case is the retrieval of all translated names for an item to populate localized regulatory documents. For instance, generating a Safety Data Sheet (SDS) in French for a chemical would require querying this table. Common SQL patterns include fetching all names for a specific item or retrieving a specific name type for a set of languages. An example query is:

  • SELECT item_code, label_code, language, name FROM gr_multilingual_name_tl WHERE item_code = 'CHEM_001' AND language IN ('US', 'FR', 'DE');

Reporting use cases often involve joining this table with GR_ITEM_GENERAL and GR_LABELS_B to produce comprehensive item master lists with multilingual descriptions for compliance audits or global product information systems.

Related Objects

GR_MULTILINGUAL_NAME_TL has integral relationships with several key EBS objects. Its primary foreign key dependency is on GR_ITEM_GENERAL (ITEM_CODE), the master table for regulated items. It also references GR_LABELS_B (LABEL_CODE) to validate the type of name being stored. For language management, it has two foreign key relationships to the application's standard language table, FND_LANGUAGES (for both LANGUAGE and SOURCE_LANG columns). These relationships ensure data integrity and enforce valid codes for items, label types, and language translations within the regulatory framework.