Search Results gmd_tests_tl




Overview
Explore in AI Chat

Overview

The GMD_TESTS_TL table is a core translation table within the Oracle E-Business Suite (EBS) Process Manufacturing Product Development (GMD) module. It stores the language-specific, translatable descriptions for quality tests. In a multi-language deployment, the base table GMD_TESTS_B holds the invariant test definition data, while GMD_TESTS_TL provides the corresponding translated text for different installed languages. This structure is a standard Oracle Applications pattern (Base Table + "_TL" suffix) that enables global enterprises to manage product specifications and quality procedures in a multilingual environment. Its primary role is to support the user interface and reporting by displaying test names and descriptions in the user's session language.

Key Information Stored

The table's structure is designed to map invariant keys to translated text. The primary key is a composite of QCASSY_TYP_ID and LANGUAGE. The QCASSY_TYP_ID is a foreign key referencing the unique identifier for a test in the base table GMD_TESTS_B. The LANGUAGE column holds the ISO language code (e.g., 'US' for American English, 'KO' for Korean). The most critical data column is DESCRIPTION, which contains the translated name or detailed explanation of the quality test in the specified language. Additional standard columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY track row history.

Common Use Cases and Queries

The primary use case is retrieving a test description in the current application session language for display in forms, such as the Quality Tests setup or Specification Definition forms. It is also essential for generating localized quality reports and certificates of analysis. A common SQL pattern joins this table to its base table, filtered by the user's language preference.

  • Sample Query for Test Details:
    SELECT b.qcassy_typ_id, tl.description, b.assy_type
    FROM gmd_tests_b b,
    gmd_tests_tl tl
    WHERE b.qcassy_typ_id = tl.qcassy_typ_id
    AND tl.language = USERENV('LANG')
    AND b.assy_type = 'TEST';
  • Reporting Use Case: Generating a list of all test descriptions available in a specific language for audit or translation completeness checks.

Related Objects

GMD_TESTS_TL has a direct, integral relationship with its base table, GMD_TESTS_B. The documented primary key (GMD_TESTS_TL_PK) confirms that QCASSY_TYP_ID is a foreign key to GMD_TESTS_B. This table is also referenced by other translation-dependent application objects and views within the GMD module. Key related objects include:

  • GMD_TESTS_B: The base table for test definitions. The join column is QCASSY_TYP_ID.
  • GMD_SPEC_TESTS_TL: The translation table for specification test details, which may indirectly rely on test descriptions.
  • Various application views (e.g., GMD_QC_TESTS_VL) that present a complete, language-sensitive view of test data by joining GMD_TESTS_B and GMD_TESTS_TL.