Results for “qcunit_code”

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

Overview

GMD_UNITS_TL is the translation table for quality control (QC) units within the Oracle EBS Process Manufacturing Product Development module (GMD). It stores language-specific descriptive text for QC unit codes, enabling multilingual presentation of unit-of-measure definitions used across quality specifications, laboratory results, and process manufacturing transactions. In Oracle EBS 12.1.1 and 12.2.2, the table resides in the GMD schema and is flagged as VALID. Its functional role is to decouple the immutable QC unit code from its user-facing description, so that each operating language can present a localized label without altering the underlying code.

From a data modeling perspective, the heuristic Data Vault classification for this object is standalone, as mined from its foreign-key structure. This suggests modeling GMD_UNITS_TL as an independent, self-contained entity rather than as a hub, link, or satellite within a Data Vault architecture. The translation table therefore functions as a reference/lookup object keyed by a composite of QC unit code and language.

Key Information Stored

GMD_UNITS_TL contains nine documented columns. The most significant are described below:

• QCUNIT_CODE — The business identifier for the QC unit. It is part of the composite primary key and the natural business key.
• QCUNIT_DESC — The translated description or display name of the QC unit for the associated language. This is the principal payload of the table.
• SOURCE_LANG — Identifies the source language from which the translation originates, supporting language-derivation and fallback logic.
• LANGUAGE — The language code for the row. It forms the second component of the composite primary key and determines which locale the description applies to.
• CREATION_DATE, CREATED_BY — Standard audit columns recording when and by whom the row was inserted.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns capturing the most recent modification and the login context.

The surrogate primary key is defined by the unique index GMD_UNITS_TL_PK (QCUNIT_CODE, LANGUAGE). Because this composite is also the unique business-key candidate, the surrogate key and the business key coincide in this design; there is no separate system-generated identifier column documented. The combination of QCUNIT_CODE and LANGUAGE guarantees one description per unit per language.

Common Use Cases and Queries

Typical scenarios include joining the translation table to the base QC units table to retrieve a localized description for reports, quality specifications, and lab result displays. A common pattern is to filter by the session or reporting language:

• Retrieving a localized unit description: SELECT qcunit_desc FROM gmd_units_tl WHERE qcunit_code = :code AND language = :lang;
• Listing all languages available for a unit: SELECT language, qcunit_desc FROM gmd_units_tl WHERE qcunit_code = :code ORDER BY language;
• Detecting missing translations by comparing against the base unit table for a target language.
• Reporting on audit history via LAST_UPDATE_DATE and LAST_UPDATED_BY to track translation maintenance activity.

These queries support multilingual quality documentation, regulatory submissions requiring localized unit labels, and data-quality audits of translation completeness.

Related Objects

The base (non-translated) QC units definition is the primary counterpart that GMD_UNITS_TL supports, joined on QCUNIT_CODE. The standard EBS language reference (FND_LANGUAGES) supplies the valid LANGUAGE values, and the audit columns relate to the FND user/application context. Additional dependencies include the QC unit base table and any quality specification or laboratory tables that consume QC unit codes. Because the documented metadata classifies this object as standalone with no enumerated foreign keys, joins to related tables should be confirmed against the actual instance catalog before being relied upon in production reporting.