Search Results gmd_qc_status_tl




Overview
Explore in AI Chat

Overview

GMD_QC_STATUS_TL is the translation table for OPM Quality Status codes within the Oracle E-Business Suite Process Manufacturing Product Development module (GMD). In Release 12.1.1 and 12.2.2, the table stores language-specific textual representations of quality status values used throughout process manufacturing quality operations. Quality status codes drive dispositioning decisions for lots, batches, and inventory, determining whether material is released, quarantined, rejected, or pending inspection. The "_TL" suffix identifies this as a translation table, which holds one row per language per base entity, enabling multilingual display without duplicating the underlying status definition.

From a data modeling perspective, the heuristic Data Vault classification for this object is satellite. The translation rows describe attributes of a quality status entity and are keyed by the status code, entity type, and language, with effective dating and audit columns. This classification is a modeling suggestion rather than a physical implementation detail; the actual table is a conventional EBS translation table with a composite unique index.

Key Information Stored

The most significant columns include:

  • STATUS_CODE — The business identifier for the quality status; part of the composite primary key and a primary business-key candidate.
  • ENTITY_TYPE — Discriminates the type of entity to which the status applies (for example, lot or batch), also part of the primary key.
  • LANGUAGE — The NLS language code for the translated text; completes the primary key.
  • MEANING — The translated display name shown to users in the selected language.
  • DESCRIPTION — The translated longer description of the quality status.
  • SOURCE_LANG — The source language of the base record, used during the translation workflow.
  • ZD_EDITION_NAME — The editioning column introduced in 12.2.2 for online patching and edition-based redefinition support.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit and concurrency columns.

The surrogate primary key, GMD_QC_STATUS_TL_PK, is defined on (STATUS_CODE, ENTITY_TYPE, LANGUAGE). The documented unique index GMD_QC_STATUS_TL_PK uniquely identifies rows and includes ZD_EDITION_NAME, reflecting the 12.2.2 editioning model. Note that in 12.1.1 no ZD_EDITION_NAME column exists; the column count and index definition differ between releases.

Common Use Cases and Queries

Typical usage centers on presenting quality status values in the user's language and on joining status codes to lot and quality data for reporting. A common query retrieves translated meanings for a given language:

SELECT status_code, entity_type, meaning, description
FROM   gmd.gmd_qc_status_tl
WHERE  language = USERENV('LANG')
ORDER  BY status_code;

Reporting scenarios include listing all available quality status values for a territory, auditing which statuses lack translation for a target language, and joining to base quality tables to produce language-specific lot disposition reports. Because the table is used for display, key lookups should join on STATUS_CODE and ENTITY_TYPE while filtering by LANGUAGE.

Related Objects

The following objects are most commonly associated:

  • GMD_QC_STATUS_B — The base (non-translated) quality status table; joins on STATUS_CODE and ENTITY_TYPE.
  • GMD_QC_STATUS_VL — The view combining base and translation rows for language-aware querying.
  • GMD_LOT_QC_RESULTS — Lot-level quality results that reference status codes.
  • GMD_QC_SAMPLES — Quality samples retaining status references.
  • GMD_QUALITY_SPECS — Quality specifications that map to status values.
  • FND_LANGUAGES — Reference for LANGUAGE values used in the translation key.

These relationships are inferred from the documented key structure; the table itself is classified as standalone with no enforced foreign keys in the metadata provided.