Search Results gr_sub_headings_tl




Overview
Explore in AI Chat

Overview

The GR_SUB_HEADINGS_TL table is a core data object within Oracle E-Business Suite 12.1.1 and 12.2.2, specifically for the Process Manufacturing Regulatory Management (GR) module. It functions as a translation table, storing multilingual descriptions for regulatory sub-headings. Its primary role is to support global operations by enabling the storage of sub-heading descriptions in multiple languages, which is critical for compliance reporting and documentation across different regions. The table is intrinsically linked to its base table, GR_SUB_HEADINGS_B, which holds the language-independent transactional data.

Key Information Stored

The table's structure is designed to manage translated text. The primary key is a composite of SUB_HEADING_CODE and LANGUAGE, ensuring a unique description per language for each sub-heading code. Key columns include SUB_HEADING_CODE, which is the foreign key to the base table GR_SUB_HEADINGS_B; LANGUAGE, which stores the language code (e.g., 'US', 'FR') and references FND_LANGUAGES; and SOURCE_LANG, which indicates the original language of the translated data and also references FND_LANGUAGES. The table typically contains a DESCRIPTION column (implied by the ETRM's title "The Sub Heading Description") to hold the actual translated text. Other standard Translation Table columns, such as CREATED_BY and LAST_UPDATE_DATE, are also present.

Common Use Cases and Queries

This table is essential for any user interface or report within the Regulatory Management module that must display sub-heading descriptions in a user's session language. A common use case is generating regulatory reports or compliance certificates for international shipments, where descriptions must appear in the destination country's official language. A typical query retrieves the description for a specific sub-heading in the current session language, often joining through the base table. For example:

  • SELECT t.description FROM gr_sub_headings_tl t, gr_sub_headings_b b WHERE t.sub_heading_code = b.sub_heading_code AND t.language = USERENV('LANG') AND b.sub_heading_code = '<CODE>';
  • Data maintenance involves inserting or updating rows in this table when new languages are supported or when sub-heading descriptions require localization updates.

Related Objects

The GR_SUB_HEADINGS_TL table has defined foreign key relationships with several key EBS objects, as documented in the provided metadata:

  • GR_SUB_HEADINGS_B: This is the primary base table. The relationship is via the SUB_HEADING_CODE column. Every record in the TL table must correspond to a valid record in the _B table.
  • FND_LANGUAGES: The table references this Oracle Applications foundation table twice. The LANGUAGE column ensures the language code is valid within the EBS instance. The SOURCE_LANG column also references FND_LANGUAGES to track the original language of the translation.

These relationships enforce data integrity, ensuring that translations are only stored for valid sub-headings and recognized application languages.