Results for “assay_code”

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

Overview

GMD_COA_DETAILS is a table in the GMD schema (Process Manufacturing Product Development) within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores Certificate of Analysis (COA) report detail information. A Certificate of Analysis is the formal document that a manufacturer issues to a customer or regulator to certify that a produced batch or lot conforms to its approved specification. Each row in GMD_COA_DETAILS represents a single analytical result line printed or stored on such a certificate — for example, the measured assay value, the corresponding specification limits, the test method applied, and the unit of measure.

In the Process Manufacturing (OPM) quality model, the COA is generated from quality results that were captured against a quality specification during inspection. GMD_COA_DETAILS therefore sits downstream of the quality data capture process: it is a reporting-oriented structure that flattens specification and result information into the format required by the printed certificate. The table is physically implemented in the GMD schema with 21 documented columns in the 12.2.2 ETRM reference.

From a data-modeling perspective, the ETRM relationship analysis classifies GMD_COA_DETAILS as standalone under the heuristic Data Vault classification. This suggestion indicates that the table functions primarily as a descriptive detail store rather than as a pure hub, link, or satellite, although its column profile — a surrogate identifier plus business attributes with creation and audit columns — is characteristic of a satellite-style structure carrying descriptive context.

Key Information Stored

The table is keyed by GMD_COA_ID, which serves as the surrogate primary key for each certificate-of-analysis detail row. The most significant business attributes include:

• QC_RESULT_ID – foreign key to QC_RSLT_MST, linking the certificate line to the underlying quality result record.
• QC_SPEC_ID – foreign key to QC_SPEC_MST, identifying the quality specification that governs the tested characteristic.
• RESULT_DATE – the date on which the analytical result was obtained.
• ASSAY_CODE / ASSAY_DESC – the code and description of the assay or test performed.
• RESULT – the measured value reported on the certificate.
• SPECIFICATION – the target specification value for the characteristic.
• MIN_SPEC / MAX_SPEC – the lower and upper specification limits used to judge conformance.
• UOM / INV_UOM – the unit of measure for the result and the inventory unit of measure, respectively.
• RSLT_TEXT_CODE / SPEC_TEXT_CODE – text codes for textual results and specifications.
• TEST_UNIT / TEST_METHOD – the unit associated with the test and the analytical method employed.
• Audit columns – CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard EBS auditability.

The two foreign keys on QC_RESULT_ID and QC_SPEC_ID are the documented business-key entry points into the quality model; no additional unique indexes are listed in the ETRM metadata.

Common Use Cases and Queries

Typical usage centers on COA printing, quality reporting, and customer or regulatory submission. A straightforward query joins the detail table to its master result and specification tables to reproduce the certificate content:

• List all detail lines for a given certificate: SELECT * FROM GMD.GMD_COA_DETAILS WHERE GMD_COA_ID = :p_coa_id;
• Retrieve specification context: SELECT d.assay_desc, d.result, d.specification, d.min_spec, d.max_spec FROM GMD.GMD_COA_DETAILS d, GMD.QC_SPEC_MST s WHERE d.qc_spec_id = s.qc_spec_id;
• Trace results back to their quality origin: SELECT r.*, d.* FROM GMD.GMD_COA_DETAILS d, GMD.QC_RSLT_MST r WHERE d.qc_result_id = r.qc_result_id;
• Identify out-of-specification lines: SELECT * FROM GMD.GMD_COA_DETAILS WHERE result < min_spec OR result > max_spec;

These patterns support batch-release review, trend analysis of assay results over time, and audit preparation for regulated manufacturing environments.

Related Objects

The most significant related objects, based on the documented foreign-key relationships, include:

• QC_RSLT_MST – master quality results table, referenced via GMD_COA_DETAILS.QC_RESULT_ID.
• QC_SPEC_MST – master quality specification table, referenced via GMD_COA_DETAILS.QC_SPEC_ID.

Additional dependent structures in the quality and COA reporting flow typically include the COA header or master table that owns GMD_COA_ID, quality result detail and specification detail tables that enrich the assay values, and the OPM quality APIs used to generate and print certificates. Because the ETRM relationship data classifies this table as standalone with only the two documented inbound references, GMD_COA_DETAILS should be treated primarily as a dependent detail store whose lineage flows from QC_RSLT_MST and QC_SPEC_MST.