Search Results gmd_spec_tests_tl

Overview

The GMD_SPEC_TESTS_TL table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing (OPM) Product Development module (GMD). It functions as a translation table, storing multilingual descriptions and names for specification tests. In the context of OPM, a specification defines the quality and physical property requirements for a material, and tests are the individual criteria or analyses performed. This table enables the global deployment of EBS by allowing test descriptions to be maintained in multiple languages, supporting international regulatory and operational requirements. Its role is critical for ensuring that specification data is accurately presented in the user's preferred language throughout the application interface and in localized reports.

Key Information Stored

The table's structure is designed to hold language-specific textual attributes for specification tests. As defined by its primary key, each record is uniquely identified by a combination of three columns. The SPEC_ID column links to the parent specification definition. The TEST_ID column identifies the specific test within that specification. The LANGUAGE column holds the language code (e.g., 'US' for American English, 'F' for French) for the translated text. While the specific column names for the translated text are not detailed in the provided metadata, typical translation tables in EBS include columns such as TEST_DESC (test description) and TEST_NAME. These fields contain the actual translated strings that are displayed to users.

Common Use Cases and Queries

The primary use case is retrieving a test's description in a user's session language for display in forms, such as the Specification Definition form, or within quality results entry screens. A common reporting requirement is to generate specification documents with test descriptions in a specific target language for customers or regulatory bodies. A typical SQL query would join this table to its base table (commonly GMD_SPEC_TESTS_B) and filter on the LANGUAGE column.

• Sample Query for Session Language:
  SELECT tl.test_desc
  FROM gmd_spec_tests_tl tl
  WHERE tl.spec_id = :p_spec_id
  AND tl.test_id = :p_test_id
  AND tl.language = USERENV('LANG');
• Reporting Use Case: Extracting a full specification with French test descriptions for a product shipped to France, by joining GMD_SPEC_TESTS_TL (language='F') to relevant specification and item tables.

Related Objects

GMD_SPEC_TESTS_TL has a direct foreign key relationship to its corresponding base table, which lacks the language suffix (typically GMD_SPEC_TESTS_B). The primary key relationship, GMD_SPEC_TESTS_TL_PK, explicitly documents that SPEC_ID and TEST_ID are foreign keys referencing the primary key of the base specification tests table. The LANGUAGE column is a foreign key to the FND_LANGUAGES table, which maintains the list of installed languages in EBS. This table is also referenced by various views in the GMD schema that present specification data, and it is accessed through the standard Oracle Translation (TL) APIs for data loading and maintenance. Queries will almost always involve an inner join from the base table to this translation table on the SPEC_ID and TEST_ID columns.