Results for “gmd_units_b”

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

Overview

GMD_UNITS_B is a Process Manufacturing Product Development (GMD) base table that stores the units of measure used by Quality Control (QC) assays in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It provides the master list of QC measurement units referenced when defining specifications, recording results, and attaching descriptive text. Because QC results and specification limits must be expressed against a defined unit of measure, GMD_UNITS_B acts as a foundational reference table for the quality module within Process Manufacturing.

Under the documented ETRM physical schema the table resides in the GMD schema and contains 41 columns. The primary key is GMD_UNITS_B_PK, defined on the QCUNIT_CODE column, and this key is also the sole documented unique index, making QCUNIT_CODE the business-key candidate for the entity. The metadata’s heuristic Data Vault classification is hub-leaning, suggesting that GMD_UNITS_B can reasonably be modeled as a hub entity, with its QCUNIT_CODE acting as the natural business key and dependent descriptive attributes carried in a related satellite.

Key Information Stored

• QCUNIT_CODE — the primary key (GMD_UNITS_B_PK) and the business-key candidate; the code that uniquely identifies each QC unit of measure.
• QCUNIT_DESC — the descriptive name of the unit of measure.
• TEXT_CODE — foreign key to QC_TEXT_HDR, linking the unit record to supplemental descriptive text.
• DELETE_MARK — standard soft-delete flag indicating whether the unit row is logically active.
• TRANS_CNT — transaction counter used by the Process Manufacturing concurrency and audit mechanism.
• CREATION_DATE, CREATED_BY — standard who-column audit fields capturing row creation.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit fields capturing the most recent modification.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — the descriptive flexfield (DFF) columns reserved for customer-defined extensions.

The surrogate key is QCUNIT_CODE, which simultaneously serves as the documented unique index and business key. No separate numeric surrogate identifier is documented, so QCUNIT_CODE carries both roles. The ATTRIBUTE columns are not populated by base functionality unless a DFF context has been configured.

Common Use Cases and Queries

The table is most commonly queried to resolve unit-of-measure codes into descriptions for QC specification and result reporting, and to validate that a requested unit exists before inserting specification or result rows. A typical lookup joins the table to specification and result masters:

• Listing active QC units: SELECT QCUNIT_CODE, QCUNIT_DESC FROM GMD_UNITS_B WHERE DELETE_MARK = 0;
• Resolving units used on specifications: SELECT s.SPEC_CODE, u.QCUNIT_DESC FROM QC_SPEC_MST s, GMD_UNITS_B u WHERE s.QCUNIT_CODE = u.QCUNIT_CODE;
• Resolving units attached to results: SELECT r.RESULT_ID, u.QCUNIT_CODE, u.QCUNIT_DESC FROM QC_RSLT_MST r, GMD_UNITS_B u WHERE r.QCUNIT_CODE = u.QCUNIT_CODE;

Reporting scenarios include QC configuration audits that enumerate every unit referenced by specifications or results, data-cleansing checks for orphaned unit codes, and DFF extraction where ATTRIBUTE_CATEGORY and ATTRIBUTE1–30 have been populated for customer-specific needs.

Related Objects

• QC_TEXT_HDR — referenced by GMD_UNITS_B.TEXT_CODE; supplies long descriptive text for unit records.
• QC_RSLT_MST — references GMD_UNITS_B via QCUNIT_CODE, recording the unit applied to each QC result.
• QC_SPEC_MST — references GMD_UNITS_B via QCUNIT_CODE, defining the unit for QC specifications.
• GMD_UNITS_B_PK — the primary key constraint enforcing uniqueness of QCUNIT_CODE.

Together these relationships confirm GMD_UNITS_B as a central reference entity in the GMD quality data model, supplying the measurement unit context for both specification definition and result capture processes.