Search Results qc_unit_mst




Overview
Explore in AI Chat

Overview

The QC_UNIT_MST table is a master data object within the Oracle E-Business Suite Process Manufacturing (GMD) Product Development module. It serves as the central repository for defining and managing units of measure (UOM) specifically for quality control (QC) assays. In the context of process manufacturing, where precise measurement of materials and product characteristics is critical, this table provides the standardized UOM codes required for defining test methods, recording analytical results, and establishing product specifications. Its role is foundational to the quality management processes, ensuring consistency and accuracy in the measurement data captured throughout the product lifecycle.

Key Information Stored

Based on the provided ETRM metadata, the primary data element stored in this table is the QC unit code. The table's structure is designed to support this master list, with the QCUNIT_CODE column serving as the primary key. While the full column list is not detailed in the excerpt, typical master UOM tables in Oracle EBS also contain descriptive fields such as a unit name, an abbreviation, and potentially a conversion factor to a base unit. The existence of a foreign key relationship from QC_TEXT_HDR.TEXT_CODE to QC_UNIT_MST.TEXT_CODE suggests the table may also store a reference to associated descriptive text, allowing for detailed documentation of the unit.

Common Use Cases and Queries

The primary use case for QC_UNIT_MST is the maintenance of valid UOMs for the quality system. Administrators use this table to define new assay units before they can be referenced in specification or test method setup. For reporting and data validation, common queries involve joining this master table to transactional data. A fundamental pattern is retrieving the unit description for a recorded test result. For example:

  • Joining to Result Records: SELECT r.result_val, u.qcunit_code, u.unit_name FROM qc_rslt_mst r, qc_unit_mst u WHERE r.qcunit_code = u.qcunit_code;
  • Listing All Active Units: SELECT qcunit_code FROM qc_unit_mst ORDER BY qcunit_code;

This table is essential for any report that presents QC data, as it translates the stored unit code into a human-readable format for analysis and compliance reporting.

Related Objects

The ETRM documentation explicitly lists several key tables that have foreign key dependencies on QC_UNIT_MST, highlighting its central role in the data model:

  • QC_SPEC_MST: Specifications master table references the unit code to define the UOM for a specification limit.
  • QC_RSLT_MST: Results master table references the unit code to record the UOM for an analytical test result.
  • QC_ASSY_TYP: Assay types table references the unit code, likely to define a default or standard UOM for a particular test method.
  • QC_TEXT_HDR: A relationship exists where QC_UNIT_MST may store a TEXT_CODE to link to descriptive text, indicating integration with the generic text engine in Oracle EBS.

It is important to note the metadata states "Not implemented in this database," which may indicate this specific table name is a legacy or reference object in certain versions, and its functionality may be provided by a more generalized UOM table (like INV_UNITS_OF_MEASURE) within a full implementation.