Search Results gmd_qc_tests_tl




Overview
Explore in AI Chat

Overview

GMD_QC_TESTS_TL is the translation (language) table for Quality Control test definitions in the Oracle Process Manufacturing (OPM) Product Development module. It is owned by the GMD schema and forms part of the ETRM (Enterprise Transaction Repository Model) footprint documented for Oracle EBS 12.1.1 and 12.2.2. In EBS, the "_TL" suffix identifies a table that stores the translatable, descriptive attributes of a base entity for multiple installed languages. The base operational row lives in the corresponding base table (GMD_QC_TESTS_B), while GMD_QC_TESTS_TL carries the language-specific description used in forms, reports, and quality specifications.

The table's primary key, GMD_QC_TESTS_TL_PK, is defined on (TEST_ID, LANGUAGE), meaning each QC test can hold one translated description row per installed language. The Data Vault classification mined from the foreign-key structure is "standalone," indicating no outgoing dependency relationships in the documented FK topology. As a modeling suggestion, this pattern corresponds most closely to a satellite: it hangs off the TEST_ID business key (the hub), is keyed additionally by LANGUAGE, and stores descriptive, auditable attributes (the description and audit columns) that change over time with the base record.

Key Information Stored

The documented physical schema for GMD_QC_TESTS_TL in 12.2.2 contains nine columns. The most important include:

  • TEST_ID — surrogate/foreign key to the base QC test row in GMD_QC_TESTS_B. Part of the composite primary key.
  • LANGUAGE — the installed language code for the translated row. Part of the composite primary key and the discriminator between translations.
  • TEST_DESC — the translatable test description shown to users in their session language.
  • SOURCE_LANG — the language in which the description was originally entered, used by the translation framework for fallback and refresh logic.
  • CREATED_BY — the user who created the translated row.
  • CREATION_DATE — timestamp the translated row was created.
  • LAST_UPDATED_BY — the user who last modified the translation.
  • LAST_UPDATE_DATE — timestamp of the last modification to the translation.
  • LAST_UPDATE_LOGIN — login identifier associated with the last update.

The surrogate primary key is (TEST_ID, LANGUAGE). There are no separate business-key unique indexes beyond this PK; TEST_ID functions as the business key linking to the base entity, and LANGUAGE is the translation discriminator.

Common Use Cases and Queries

Typical use cases include multilingual QC test reporting, specification printing, and verifying that all installed languages have been seeded for a given test. A common query filters by language to display the appropriate description:

  • Selecting the description for a specific language: SELECT TEST_ID, TEST_DESC FROM GMD_QC_TESTS_TL WHERE TEST_ID = :test_id AND LANGUAGE = USERENV('LANG');
  • Identifying tests missing a translation for a target language via a LEFT JOIN from GMD_QC_TESTS_B.
  • Joining to the base table to produce a bilingual listing for validation.
  • Audit reporting on LAST_UPDATE_DATE and LAST_UPDATED_BY to track description changes.

Because the table is a translation child, reports should always join through TEST_ID to the base QC test definition to obtain operational attributes such as test type, unit of measure, and validity rules.

Related Objects

The documented relationship data classifies this table as standalone, so its dependencies are structural rather than explicit FKs in the extracted metadata. Significant related objects typically include:

  • GMD_QC_TESTS_B — base table; joined on TEST_ID = GMD_QC_TESTS_B.TEST_ID.
  • GMD_QC_TESTS_VL — the translated view over the base and _TL tables, providing language-resolved rows.
  • GMD_QC_SPECS / QC specification tables — reference QC tests for specification definitions.
  • GMD_QC_RESULTS — quality results reference the QC test executed.
  • OPM Product Development forms and validation concurrent programs that consume the translated description.

Among these, GMD_QC_TESTS_B and GMD_QC_TESTS_VL are the most critical join partners for any query or report built against GMD_QC_TESTS_TL.