Results for “qc_rslt_mst”

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

Overview

QC_RSLT_MST (QC Results Master) is the central results table in Oracle E-Business Suite's Process Manufacturing Product Development module (GMD). It stores the outcome of every quality control assay performed against a sample, specification, batch, or process step, capturing both numeric and textual results along with the disposition decisions that follow. In Oracle Process Manufacturing (OPM) Quality, this table is the transactional heart of the quality lifecycle: sample collection feeds QC_SMPL_MST, specification limits reside in QC_SPEC_MST, and the actual measured values are written to QC_RSLT_MST. The table is owned by the GMD schema and is present in both EBS 12.1.1 and 12.2.2.

The documented physical schema shows 78 columns. ETRM's heuristic Data Vault classification of QC_RSLT_MST is link, which is a reasonable modeling suggestion: the table records associations between quality events and the many business entities they touch — items, lots, formulas, routings, operations, warehouses, customers, vendors, batches, and specifications — while the surrogate key QC_RESULT_ID identifies each association instance.

Key Information Stored

The surrogate primary key is QC_RESULT_ID, enforced by the unique index QC_RSLT_MST_PK. No separate business-key unique index is documented; business identity is conveyed by the composite of sample, specification, and organization.

• QC_RESULT_ID — Surrogate primary key for each result record.
• SAMPLE_ID — Foreign key to QC_SMPL_MST; identifies the sample being tested.
• QC_SPEC_ID — Foreign key to QC_SPEC_MST; the specification against which the sample is evaluated.
• ASSAY_CODE — The quality test or assay performed.
• NUM_RESULT and TEXT_RESULT — The measured numeric value and/or textual observation returned by the assay.
• QCUNIT_CODE — Unit of measure for the numeric result (references GMD_UNITS_B and QC_UNIT_MST).
• RESULT_DATE — Date the result was recorded.
• ACCEPT_ANYWAY and FINAL_MARK — Disposition flags indicating an overridden acceptance and the final result for the sample.
• QCASSY_TYP_ID — Assay type (references QC_ASSY_TYP).
• ITEM_ID, LOT_ID, WHSE_CODE, LOCATION — Material context of the tested quantity (references IC_ITEM_MST, IC_LOTS_MST, IC_WHSE_MST, IC_LOCT_MST).
• BATCH_ID — Production batch associated with the result (references PM_BTCH_HDR).
• ORGN_CODE — Owning organization (references SY_ORGN_MST).
• CUST_ID, VENDOR_ID — Customer or supplier context (references OP_CUST_MST, PO_VEND_MST).
• FORMULA_ID, FORMULALINE_ID, ROUTING_ID, ROUTINGSTEP_ID, OPRN_ID — Formula, routing, and operation context (references FM_MATL_DTL, FM_ROUT_DTL, FM_OPRN_MST).

Common Use Cases and Queries

Quality analysts use QC_RSLT_MST to retrieve the complete test history for a lot or batch, to identify results that were accepted outside specification, and to drive Certificate of Analysis (COA) generation. A typical query joins results to the sample master and item master:

SELECT r.qc_result_id, r.assay_code, r.num_result, r.text_result, r.qcunit_code, r.final_mark
FROM gmd.qc_rslt_mst r
WHERE r.sample_id = :p_sample_id
ORDER BY r.result_date;

A second pattern identifies batches whose results were overridden:

SELECT r.batch_id, r.assay_code, r.accept_anyway, r.assay_retest
FROM gmd.qc_rslt_mst r
WHERE r.accept_anyway = 1 AND r.orgn_code = :p_orgn;

Downstream, GMD_COA_DETAILS references QC_RESULT_ID, so results flow directly into certificate-of-analysis reporting. Result records are also used for trending charts and specification-limit violation reports.

Related Objects

• QC_SMPL_MST — Source of SAMPLE_ID; parent sample record.
• QC_SPEC_MST — Source of QC_SPEC_ID; specification limits.
• QC_ASSY_TYP and QC_UNIT_MST — Assay type and unit definitions.
• PM_BTCH_HDR — Batch header via BATCH_ID.
• IC_LOTS_MST and IC_ITEM_MST — Lot and item context.
• GMD_COA_DETAILS — Child table referencing QC_RESULT_ID.
• FM_ROUT_DTL and FM_OPRN_MST — Process routing and operation context.
• SY_ORGN_MST — Organization definition via ORGN_CODE.