Search Results synonym_sequence_number




Overview
Explore in AI Chat

Overview

The GR_OTHER_NAMES_TL table is a core data entity within the Process Manufacturing Regulatory Management (GR) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a translation table, designated by the '_TL' suffix, designed to store alternative names or synonyms for regulated items in multiple languages. Its primary role is to support global regulatory compliance by enabling the management of item nomenclature across different regions and languages. The sequencing of these synonyms is configurable via the application's 'SYNONYM STORAGE SEQUENCE' preference, which can order entries alphabetically or by a user-defined sequence number.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each synonym entry. The key columns are ITEM_CODE, which references the specific regulated item; LANGUAGE, which references the language code from FND_LANGUAGES; ORGN_CODE, which references the organization from SY_ORGN_MST_B; and SYNONYM_SEQUENCE_NUMBER, which dictates the display order. While the exact full column list is not detailed in the provided metadata, a '_TL' table typically includes a TRANSLATED_NAME or SYNONYM_TEXT column to hold the actual alternative name. The primary key ensures that multiple alternative names can be stored for a single item, differentiated by language, organization, and sequence.

Common Use Cases and Queries

This table is central to generating regulatory documents, such as safety data sheets or product labels, that require item names in a locale-specific language. A common reporting use case involves retrieving all translated names for an item to verify comprehensive global coverage. A typical query would join to the base item table and the languages table.

  • Sample Query for Item Synonyms: SELECT got.synonym_sequence_number, fl.nls_language, got.translated_name FROM gr_other_names_tl got, fnd_languages fl WHERE got.language = fl.language_code AND got.item_code = '<ITEM_CODE>' AND got.orgn_code = '<ORGN_CODE>' ORDER BY got.synonym_sequence_number;
  • Data Validation: Queries are often used to identify items missing critical translations for key markets by checking for null or missing LANGUAGE entries for a given ORGN_CODE.

Related Objects

The integrity and utility of GR_OTHER_NAMES_TL are defined by its documented foreign key relationships, which anchor it to master data within the EBS architecture.

  • GR_ITEM_GENERAL: Joined via GR_OTHER_NAMES_TL.ITEM_CODE. This is the primary relationship, linking a synonym to its base regulated item definition.
  • FND_LANGUAGES: Joined via GR_OTHER_NAMES_TL.LANGUAGE. This standard EBS table validates and provides metadata for the language used in the translation.
  • SY_ORGN_MST_B: Joined via GR_OTHER_NAMES_TL.ORGN_CODE. This relationship scopes the synonym to a specific business entity or organization, allowing for region-specific naming conventions.