Search Results gmd_coa_headers

Overview

GMD.GMD_COA_HEADERS is the Certificate of Analysis (COA) report header table within the Oracle Process Manufacturing (OPM) Product Development module. In Oracle EBS 12.1.1 and 12.2.2, it stores the header-level context required to generate COA documents that accompany shipments of process-manufactured goods. Each row represents one COA header, tying together order, customer, shipment, item, lot, and quality specification references so that a printable certificate can be produced for a specific delivered lot or sublot.

The table physically resides in the GMD schema and, per the 12.2.2 ETRM documentation, contains 52 columns. Because the object is a header record for a transactional COA event, it functions as a transactional satellite in Data Vault terms. The heuristic classification supplied in the metadata is "standalone," reflecting that the only documented foreign-key relationship is the BOL_ID reference to OP_BILL_LAD, with no other enforced FK dependencies. In practice, however, the table behaves as a hub-anchored satellite keyed on surrogate COA identity and natural business keys drawn from order, customer, item, and lot.

Key Information Stored

The primary surrogate identifier is GMD_COA_ID, which uniquely identifies each COA header record. Business-key candidates include ORDER_NO combined with LINE_ID, CUST_NO with CUST_ID, and LOT_NO with SUBLOT_NO, which together describe the delivery context of the certificate.

• Order context: ORDER_ID, ORDER_NO, ORDER_QTY1, ORDER_QTY2, ORDER_UM1, ORDER_UM2, ORDER_UOM1, ORDER_UOM2, and ORDER_INV_UOM capture the originating sales order line and its quantities and units of measure.
• Customer context: CUST_ID, CUST_NO, CUST_NAME, and the OPM-specific OPM_CUST_ID identify the ship-to or sold-to party, while CUSTPO_NO preserves the customer purchase order reference.
• Shipment context: SHIPDATE, BOL_ID and BOL_NO link to the bill of lading, WHSE_CODE and WHSE_NAME identify the warehouse, and SHIP_QTY1, SHIP_QTY2, SHIP_UOM1, SHIP_UOM2, SHIP_QTY_UOM1, and SHIP_QTY_UOM2 record shipped quantities in dual units of measure.
• Item and lot identity: ITEM_ID, ITEM_NO, ITEM_NUMBER, ITEM_DESC1, ITEM_DESCRIPTION, INVENTORY_ITEM_ID, LOT_ID, LOT_NO, LOT_NUMBER, LOT_DESC, LOT_DESCRIPTION, SUBLOT_NO, REVISION, and SUBINVENTORY describe the specific material and lot being certified.
• Report and audit attributes: REPORT_TITLE, SPEC_HDR_TEXT_CODE, SESSION_ID, ORGN_CODE or ORGANIZATION_CODE and ORGANIZATION_ID, plus standard audit columns CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage includes regenerating historical COAs, auditing lot traceability to customers, and reporting shipment-level quality documentation. A common query pattern joins the header to its bill of lading and quality results:

• Retrieve all COA headers for a given order: SELECT * FROM GMD.GMD_COA_HEADERS WHERE ORDER_NO = :order_no;
• Trace certificates by lot: SELECT GMD_COA_ID, ORDER_NO, CUST_NAME, SHIPDATE FROM GMD.GMD_COA_HEADERS WHERE LOT_NO = :lot_no;
• Link to bill of lading details: SELECT h.*, b.* FROM GMD.GMD_COA_HEADERS h JOIN OP_BILL_LAD b ON h.BOL_ID = b.BOL_ID;
• Report shipped quantities in dual UOM: select SHIP_QTY1, SHIP_UOM1, SHIP_QTY2, SHIP_UOM2 filtered by SHIPDATE range.

Related Objects

• OP_BILL_LAD — referenced via BOL_ID → BOL_ID; provides bill of lading line detail linked to the COA header.
• GMD_COA_DETAILS — the detail table holding individual test/specification results associated with each GMD_COA_ID.
• OE_ORDER_HEADERS_ALL / OE_ORDER_LINES_ALL — sales order source for ORDER_ID and LINE_ID.
• HZ_CUST_ACCOUNTS — customer master referenced through CUST_ID and OPM_CUST_ID.
• MTL_SYSTEM_ITEMS_B / MTL_LOT_NUMBERS — inventory item and lot master for ITEM_ID, INVENTORY_ITEM_ID, and LOT_ID.
• GMD_SPEC_HEADERS / GMD_SPEC_TESTS — specification definitions aligned through SPEC_HDR_TEXT_CODE.
• INV_SUBINVENTORIES / ORG_ORGANIZATION_DEFINITIONS — resolve SUBINVENTORY and ORGANIZATION_ID values to inventory organizations.