Search Results qc_rslt_mst




Overview
Explore in AI Chat

Overview

The QC_RSLT_MST table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMD) module, specifically for Product Development. It functions as the master repository for quality control (QC) test results. This table is central to the quality management lifecycle, capturing the outcome of inspections and analyses performed on materials, batches, or products against defined specifications. Its extensive foreign key relationships integrate quality data with other critical EBS domains, including inventory, process execution, purchasing, and customer management, ensuring traceability and compliance.

Key Information Stored

The table's primary key is QC_RESULT_ID, which uniquely identifies each result record. Key foreign key columns establish critical business relationships: SAMPLE_ID links to QC_SMPL_MST to identify the physical sample tested; QC_SPEC_ID references QC_SPEC_MST for the specification against which the sample was evaluated; and BATCH_ID connects to PM_BTCH_HDR for process manufacturing batch context. Other significant columns include ITEM_ID and LOT_ID for inventory identification, FORMULALINE_ID and OPRN_ID for process step context, and CUST_ID or VENDOR_ID for supply chain partner association. The table also stores unit of measure (QCUNIT_CODE) and organizational (ORGN_CODE) data.

Common Use Cases and Queries

Primary use cases involve querying and reporting on quality results for analysis and compliance. Common queries include retrieving all results for a specific batch to assess overall quality, finding results that fall outside specification limits for non-conformance reporting, and tracing results back to a specific sample or inventory lot. A typical reporting query might join QC_RSLT_MST with batch, item, and specification tables. For technical integrations, such as custom data loads or interfaces, the QC_RESULT_ID sequence must be respected, and all mandatory foreign key relationships (e.g., to a valid sample and specification) must be populated to maintain data integrity.

Related Objects

QC_RSLT_MST is a hub table with dependencies across multiple modules. Its most direct relationships are within the GMD quality suite: QC_SMPL_MST (samples), QC_SPEC_MST (specifications), and QC_ASSY_TYP (test types). It is fundamentally linked to Process Manufacturing execution via PM_BTCH_HDR, FM_MATL_DTL, FM_OPRN_MST, and FM_ROUT_DTL. For inventory and item context, it references IC_ITEM_MST, IC_LOTS_MST, IC_WHSE_MST, and IC_LOCT_MST. External entity relationships are established through PO_VEND_MST (suppliers) and OP_CUST_MST (customers). This network of foreign keys makes it essential for any cross-functional reporting involving quality metrics.