Results for “fm_form_mst”

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

Overview

FM_FORM_MST is the formula header master table within the Oracle E-Business Suite Process Manufacturing (GMD) module, specifically the Process Manufacturing Product Development product. It stores the top-level definition of a formula — the master recipe structure that governs how a manufactured product is produced from its constituent ingredients. In Oracle Process Manufacturing, a formula defines the quantitative composition of a product at a given version, and FM_FORM_MST serves as the anchor record from which formula effects, material details, and batch headers derive their context. It is the parent object that links a formula's identity, classification, versioning, and textual attributes into a single controlled record.

Based on the foreign-key topology provided in the metadata, the object exhibits a hub-leaning Data Vault classification. Under this modeling heuristic, FM_FORM_MST is best treated as a hub: its surrogate primary key, FORMULA_ID, is referenced by numerous downstream tables, and it references several smaller descriptive tables. This classification suggests FM_FORM_MST functions as a durable business concept — the formula — around which satellite and link structures (effects, material details, batch headers) are organized.

Key Information Stored

The table is organized around a surrogate primary key defined by the constraint FM_FORM_MST_PK on the FORMULA_ID column. This is the internal identifier used by all child tables to reference a specific formula. In addition to this surrogate key, the metadata documents a unique constraint, FM_FORM_MST_UC1, established over the columns FORMULA_NO and FORMULA_VERS. These two columns therefore constitute the business-key candidate: FORMULA_NO carries the human-readable formula number, and FORMULA_VERS identifies the specific version of that formula, together enforcing uniqueness of a formula definition.

The table also holds several foreign keys that classify and describe the formula. FMCONTROL_CLASS references FM_FMCT_CLS, capturing the formula control class used to drive control parameters. FORMULA_CLASS references FM_FORM_CLS, storing the formula class used for grouping and reporting. TEXT_CODE references FM_TEXT_HDR, linking the formula to associated descriptive text. Together, FORMULA_ID, FORMULA_NO, FORMULA_VERS, FMCONTROL_CLASS, FORMULA_CLASS, and TEXT_CODE represent the most significant columns, providing identity, version control, classification, and annotation for each formula header.

Common Use Cases and Queries

Typical uses include retrieving all versions of a formula, joining formula headers to their material detail lines, and tracing which formulas a given batch header was executed against. A common query retrieves the latest version of a formula by number:

• SELECT formula_id, formula_no, formula_vers FROM fm_form_mst WHERE formula_no = :formula_no ORDER BY formula_vers DESC;
• SELECT h.formula_no, h.formula_vers, d.* FROM fm_form_mst h, fm_matl_dtl d WHERE h.formula_id = d.formula_id;
• SELECT h.formula_no, b.* FROM fm_form_mst h, pm_btch_hdr b WHERE h.formula_id = b.formula_id;

Reporting scenarios include formula composition reports, version history audits, and batch-to-formula traceability for compliance and quality investigations.

Related Objects

FM_FORM_MST sits at the center of a hub of dependencies. Its three outbound foreign keys reference FM_FMCT_CLS (via FMCONTROL_CLASS), FM_FORM_CLS (via FORMULA_CLASS), and FM_TEXT_HDR (via TEXT_CODE). In the reverse direction, six tables reference FM_FORM_MST through the FORMULA_ID column: FM_FORM_EFF, FM_MATL_DTL, GMP_FORM_EFF, MR_ACTN_TBL, MR_MESG_TBL, and PM_BTCH_HDR. These children carry formula effects, material detail lines, GMP effect records, action and message definitions, and batch header data respectively, making FM_FORM_MST the pivotal formula definition object in Process Manufacturing.