Search Results gmd_qc_test_values_tl




Overview
Explore in AI Chat

Overview

GMD_QC_TEST_VALUES_TL is the translation (MLS) table for quality control test values within Oracle Process Manufacturing Product Development (GMD). It stores language-specific display text for test values defined in the base table, enabling multilingual presentation of QC specifications across an Oracle E-Business Suite instance running 12.1.1 or 12.2.2.

In the OPM quality workflow, test values represent the discrete or range-based results that a quality test may yield—for example, "Pass/Fail," "Positive/Negative," or a numeric range such as "0–100." The _TL suffix confirms that this table follows the standard EBS translated-table pattern: it holds the translatable attributes (TEST_VALUE_DESC and DISPLAY_LABEL_NUMERIC_RANGE) keyed by both the entity identifier and LANGUAGE, while non-translatable attributes remain in the corresponding base table.

Under the heuristic Data Vault classification supplied with the ETRM metadata, this object is identified as standalone. This suggests that, in a Data Vault model, GMD_QC_TEST_VALUES_TL would most appropriately be modeled as a satellite hanging off the base test-value hub, keyed by the business key plus the language code, rather than as an independent hub or link. The absence of documented foreign keys reinforces its role as a dependent descriptive table.

Key Information Stored

The table contains 10 documented columns. The most significant are:

  • TEST_VALUE_ID — Surrogate identifier of the parent test value. Together with LANGUAGE, it forms the composite primary key GMD_QC_TEST_VALUES_TL_PK.
  • LANGUAGE — The NLS language code (for example, US or DE) identifying the translation row. This is the second component of the primary key and the discriminator for multilingual content.
  • TEST_VALUE_DESC — The translated description of the test value. This is the primary user-facing text rendered in OPM quality screens and reports.
  • DISPLAY_LABEL_NUMERIC_RANGE — The translated display label for a numeric range associated with the test value, allowing range captions to be localized independently of the description.
  • SOURCE_LANG — The language from which the row was originally derived, used by the MLS translation-maintenance framework.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS WHO columns providing audit and concurrency tracking.

The business-key candidate is the unique index GMD_QC_TEST_VALUES_TL_PK on (TEST_VALUE_ID, LANGUAGE). TEST_VALUE_ID alone is the surrogate key inherited from the base table; the pair establishes uniqueness of a translated row.

Common Use Cases and Queries

Typical uses include multilingual QC specification reporting, translation completeness audits, and joins that resolve a test value to its display text in the session language.

  • Retrieving the localized description for a test value in the current session language:
SELECT t.test_value_desc
FROM   gmd_qc_test_values_tl t
WHERE  t.test_value_id = :test_value_id
AND    t.language = USERENV('LANG');
  • Detecting missing translations by comparing base rows to translated rows across languages.
  • Populating BI Publisher or OBIEE reports where QC test value captions must appear in the user's locale.
  • Data-migration validation, ensuring every base test value has a corresponding row in US at minimum.

Because the table is MLS-protected, direct DML should generally be avoided in favor of the standard translation-maintenance APIs and the OPM Product Development forms.

Related Objects

The documented metadata classifies this table as standalone, so no foreign-key relationships are formally declared. In practice, the following objects are the most significant dependencies:

  • GMD_QC_TEST_VALUES_B — The base table holding non-translatable attributes; joined on TEST_VALUE_ID.
  • GMD_QC_TESTS_B / GMD_QC_TESTS_TL — Parent QC test definitions that reference test values.
  • GMD_QC_RESULTS — QC results recorded against test values; joins via TEST_VALUE_ID.
  • GMD_QC_SPECIFICATIONS — Specifications whose limits and target values are expressed using QC test values.
  • FND_LANGUAGES — Reference for valid LANGUAGE codes used in the composite key.
  • FND_MLS_FUNCTIONS / MLS APIs — Framework utilities supporting insertion and maintenance of translated rows.

These objects collectively form the OPM quality data model in which GMD_QC_TEST_VALUES_TL supplies the localized vocabulary for test-value display.