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:

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.