Search Results qc_spec_mst




Overview
Explore in AI Chat

Overview

The QC_SPEC_MST table is the central master data repository for quality control (QC) specifications within Oracle E-Business Suite Process Manufacturing (GMD). It serves as the core definition table for quality tests and standards that can be associated with various manufacturing and inventory entities. Its primary role is to define the criteria—such as acceptable value ranges, measurement units, and associated actions—against which materials, batches, and processes are validated, ensuring product quality and compliance throughout the manufacturing lifecycle.

Key Information Stored

The table stores metadata that defines a quality specification. The primary key is QC_SPEC_ID, which uniquely identifies each specification record. Critical foreign key columns establish relationships to other master data, defining the specification's context and applicability. These include ITEM_ID (inventory item), BATCH_ID (production batch), OPRN_ID (operation), FORMULALINE_ID (formula line), and ROUTING_ID with ROUTINGSTEP_NO (routing step). Additional essential columns specify the test parameters, such as QCUNIT_CODE (unit of measure), QCASSY_TYP_ID (assay or test type), OUTACTION_CODE (action to take based on results), and ORGN_CODE (owning organization). The table also links to descriptive text via TEXT_CODE and references specific inventory locations through WHSE_CODE and LOCATION.

Common Use Cases and Queries

This table is fundamental for quality assurance processes. Common use cases include defining quality tests for raw material receipt, in-process checks at specific manufacturing steps, and final product release criteria. For reporting, it is frequently joined with result tables like QC_RSLT_MST to analyze test outcomes against defined standards. A typical query retrieves all active specifications for a given item to understand its full quality profile:

  • SELECT qc_spec_id, spec_name, qcunit_code FROM gmd.qc_spec_mst WHERE item_id = :p_item_id AND delete_mark = 0;

Another common pattern is to identify specifications linked to a specific production batch for quality review:

  • SELECT * FROM gmd.qc_spec_mst WHERE batch_id = :p_batch_id;

Related Objects

QC_SPEC_MST has extensive relationships, as indicated by its numerous foreign keys. It is a parent table to QC_RSLT_MST, which stores the actual results of tests performed against these specifications. Key referenced (parent) tables include IC_ITEM_MST (items), PM_BTCH_HDR (batches), FM_MATL_DTL (formula details), FM_OPRN_MST (operations), FM_ROUT_DTL (routing details), QC_ASSY_TYP (assay types), QC_UNIT_MST (units of measure), and SY_ORGN_MST (organizations). These relationships integrate quality control deeply with inventory, production, and procurement modules, enabling quality checks at points of receipt from a vendor (PO_VEND_MST) or shipment to a customer (OP_CUST_MST).