Results for “gmd_test_values_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMD_TEST_VALUES_TL is the translation table for quality test values defined within Oracle Process Manufacturing Product Development (GMD). In Oracle EBS 12.1.1 and 12.2.2, translation tables follow the standard multi-language architecture: a base table (GMD_TEST_VALUES_B) stores language-independent attributes, while the _TL table stores the language-dependent descriptive text. This table is owned by the GMD schema and is valid in both releases. Its role is to resolve a given test value identifier into a human-readable description in each installed language, supporting global implementations that require quality specifications to be presented in the operator's local language.

The metadata classifies this object heuristically as standalone within a Data Vault model. Taken as a modeling suggestion, the table behaves most like a satellite: its composite key attaches descriptive, language-specific attributes to a parent test value entity, and it carries audit columns characteristic of a satellite rather than a hub or link. No foreign key relationships were mined from the physical structure, consistent with the standalone classification.

Key Information Stored

The table contains eleven documented columns. The composite primary key, GMD_TEST_VALUES_TL_PK, is defined on QCASSY_VAL_ID and LANGUAGE, making both columns the surrogate-and-business key pair for row uniqueness.

• QCASSY_VAL_ID — Identifier of the quality test value. This is the column surfaced by the search term "qcassy_val_id" and forms the parent-side join to the base test value definition.
• LANGUAGE — The language code of the translated text, completing the composite primary key.
• QCASSY_TYP_ID — Identifier of the quality test type to which the value belongs, providing the classification context for the translated value.
• VALUE_DESC — The translated description of the test value; this is the primary payload of the translation row.
• SOURCE_LANG — The source language from which the translation was derived, supporting translation workflow and fallback logic.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each row and when.
• MIGRATION_STATUS — Status flag used during data migration or upgrade processing.

Common Use Cases and Queries

Typical usage is resolving a quality test value to its translated description for a specific language. A standard pattern joins the translation table to the base table on the value identifier and filters by language:

• Retrieve a single translated description: SELECT value_desc FROM gmd_test_values_tl WHERE qcassy_val_id = :id AND language = USERENV('LANG');
• List all test values for a given test type in a language, joining QCASSY_TYP_ID to the type definition.
• Detect missing translations by comparing base table rows to translation rows for a target language, useful for global rollouts.
• Audit recent changes using LAST_UPDATE_DATE and LAST_UPDATED_BY for compliance reporting.
• Extract bilingual value lists for specification reports and label printing.

Related Objects

Because the mined relationship data shows a standalone classification with no foreign keys, associations below are based on the documented column semantics and the standard GMD translation pattern.

• GMD_TEST_VALUES_B — Base table holding language-independent test value attributes; joined on QCASSY_VAL_ID.
• GMD_TEST_VALUES_TL — The object itself, keyed by QCASSY_VAL_ID and LANGUAGE.
• GMD_QCASSY_TYPES (and its translation table) — Test type definitions referenced via QCASSY_TYP_ID.
• FND_LANGUAGES — Language validation source joined on LANGUAGE.
• GMD_SPEC_TESTS / QC specification tables — Consume test values when quality specifications are assembled.
• Translation maintenance APIs and concurrent programs — Populate VALUE_DESC and SOURCE_LANG during translation uploads.

In summary, GMD_TEST_VALUES_TL is the language-sensitive descriptor layer for quality test values, keyed by QCASSY_VAL_ID and LANGUAGE, and is best treated as a satellite-like object supporting multilingual quality data in Process Manufacturing Product Development.