Results for “ingredient_end_date”
37 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FM_MATL_DTL (Formula Material Details) is a core table in the Oracle Process Manufacturing Product Development module (GMD). It stores the material composition of a formula, capturing the products, byproducts, and ingredient lines that define what is produced and consumed when a formula is executed. Each row represents a single formula line, and the table serves as the operational backbone for formula definition, cost rollup, batch execution, and quality specification linkage in Oracle EBS 12.1.1 and 12.2.2.
The table resides in the GMD schema and is classified as VALID in the ETRM repository. From a heuristic Data Vault modeling perspective, FM_MATL_DTL leans toward a satellite classification, given its high attribute count and dependence on parent formula and item hubs via foreign keys, though its role as a child of FM_FORM_MST also gives it link-like characteristics. This classification is a modeling suggestion rather than a strict EBS construct.
Key Information Stored
FM_MATL_DTL contains 66 documented columns. The most significant include:
- FORMULALINE_ID — surrogate primary key (FM_MATL_DTL_PK), uniquely identifying each formula line.
- FORMULA_ID — foreign key to FM_FORM_MST, identifying the parent formula.
- LINE_TYPE and LINE_NO — together with FORMULA_ID, form the business-key unique index FM_MATL_DTL_U1, distinguishing ingredient, product, and byproduct lines by sequence.
- ITEM_ID — the material or product associated with the line, referencing IC_ITEM_MST and IC_ITEM_MST_B.
- QTY, ITEM_UM, and DETAIL_UOM — quantity and unit-of-measure information, with ITEM_UM referencing SY_UOMS_MST.
- SCRAP_FACTOR, SCALE_TYPE, SCALE_UOM, SCALE_MULTIPLE, and SCALE_ROUNDING_VARIANCE — scaling and yield behavior for the line.
- COST_ALLOC and PROD_PERCENT — cost allocation and production percentage controls.
- PHANTOM_TYPE, REWORK_TYPE, BY_PRODUCT_TYPE, and BUFFER_IND — behavioral flags governing how the line is processed.
- CONTRIBUTE_STEP_QTY_IND and CONTRIBUTE_YIELD_IND — indicators for step quantity and yield contribution.
- TEXT_CODE — foreign key to FM_TEXT_HDR for associated text notes.
- INGREDIENT_END_DATE and REVISION — effective-dating and revision tracking.
Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and ATTRIBUTE1 through ATTRIBUTE30 with ATTRIBUTE_CATEGORY provide extensibility and change tracking.
Common Use Cases and Queries
Typical reporting scenarios include listing all ingredients for a formula, calculating total batch quantities, and analyzing byproduct and product yields. A basic query joining formula header information follows:
SELECT m.FORMULALINE_ID, m.LINE_NO, m.LINE_TYPE, m.ITEM_ID, m.QTY, m.ITEM_UM FROM GMD.FM_MATL_DTL m WHERE m.FORMULA_ID = :formula_id ORDER BY m.LINE_TYPE, m.LINE_NO;
For cost and yield analysis, joins to IC_ITEM_MST provide item descriptions, while joins to FM_FORM_MST supply formula status and ownership. Quality teams join FM_MATL_DTL to QC_SPEC_MST, QC_SMPL_MST, and QC_RSLT_MST on FORMULALINE_ID to trace specification and sampling results back to specific formula lines. Routing analysis joins FM_ROUT_MTL on FORMULALINE_ID.
Related Objects
- FM_FORM_MST — parent formula header; joined on FM_MATL_DTL.FORMULA_ID.
- IC_ITEM_MST and IC_ITEM_MST_B — item master tables; joined on FM_MATL_DTL.ITEM_ID.
- SY_UOMS_MST — unit of measure definitions; joined on FM_MATL_DTL.ITEM_UM.
- FM_TEXT_HDR — text notes; joined on FM_MATL_DTL.TEXT_CODE.
- FM_ROUT_MTL — routing material linkage; references FM_MATL_DTL.FORMULALINE_ID.
- QC_RSLT_MST, QC_SMPL_MST, and QC_SPEC_MST — quality result, sample, and specification tables; each references FORMULALINE_ID, providing traceability from formula material lines into the quality module.
-
Formula material details - contains products,byproducts and ingredient information
-
Formula material details - contains products,byproducts and ingredient information
-
VIEW: GMD.FM_MATL_DTL# 12.2.2
-
VIEW: GMD.FM_MATL_DTL# 12.2.2
-
APPS.GMD_MATERIAL_EFFECTIVITIES_VW·↳ FM_MATL_DTL·↳ GMD_FORMULA_SUBSTITUTION·↳ GMD_ITEM_SUBSTITUTION_DTL·Explore GMD module →
-
APPS.GMD_MATERIAL_EFFECTIVITIES_VW·↳ FM_MATL_DTL·↳ GMD_FORMULA_SUBSTITUTION·↳ GMD_ITEM_SUBSTITUTION_DTL·Explore GMD module →
-
TABLE: GMD.FM_MATL_DTL 12.2.2
-
TABLE: GMD.FM_MATL_DTL 12.1.1
-
eTRM - GMD Tables and Views 12.1.1
QC Module Text Lines. Descriptive text for all tables in this module.
-
eTRM - GMD Tables and Views 12.2.2
QC Module Text Lines. Descriptive text for all tables in this module.