Search Results flm_mmm_plans




Overview
Explore in AI Chat

Overview

FLM_MMM_PLANS is a table in the Oracle E-Business Suite Flow Manufacturing (FLM) module that stores Mixed Model Map Plans. In Oracle EBS 12.1.1 and 12.2.2, this object serves as the header-level repository for the definition of mixed model production plans, which are used to sequence and level production across a mixed-model flow line. Each row represents a single plan definition scoped to a specific organization, capturing the planning parameters, demand selection criteria, and calendar characteristics that govern how the mixed model map is calculated and displayed.

The table resides in the FLM schema and is owned by the Flow Manufacturing product. From a Data Vault modeling perspective, the heuristic classification of FLM_MMM_PLANS is satellite-leaning, meaning it behaves primarily as a descriptive context table attached to a business key rather than as a pure hub or link. The composite primary key, enforced by FLM_MMM_PLANS_PK, consists of ORGANIZATION_ID and PLAN_ID, which together define the uniqueness of a plan within an inventory organization.

Key Information Stored

The documented physical schema for FLM_MMM_PLANS contains 26 columns. The most significant of these include:

  • PLAN_ID — Surrogate identifier for the mixed model plan; part of the composite primary key.
  • ORGANIZATION_ID — Inventory organization that owns the plan; the second component of the primary key and the foreign key to MTL_PARAMETERS.
  • PLAN_CODE — User-defined short code identifying the plan.
  • DESCRIPTION — Free-text description of the plan's purpose or scope.
  • PRODUCT_FAMILY_ID — Product family associated with the plan, driving the set of items included in the mixed model map.
  • LINE_ID — Flow line to which the plan applies.
  • DEMAND_TYPE and DEMAND_CODE — Define the source and classification of demand used in the mixed model calculation.
  • START_DATE and END_DATE — Effective date range for the plan's demand horizon.
  • DEMAND_DAYS — Number of demand days considered in the plan calculation.
  • HOURS_PER_DAY — Working hours per day used to convert demand into a daily rate.
  • BOOST_PERCENT — Percentage uplift applied to demand during calculation.
  • CALCULATION_OPTION — Determines the algorithm used to compute the mixed model map.
  • TIME_UOM — Unit of measure for time values in the plan.
  • VIEW_BY — Controls how the plan is displayed or grouped.
  • PRECISION — Numeric precision applied to calculated quantities.

The unique index FLM_MMM_PLANS_U1 on (ORGANIZATION_ID, PLAN_ID) is redundant with the primary key but is documented as the business-key candidate. Audit columns such as LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE follow standard EBS conventions.

Common Use Cases and Queries

Typical usage centers on retrieving plan definitions for a given organization, reporting on active plans by product family or line, and joining plan headers to their associated detail lines. A representative query retrieves all plans for an organization:

  • SELECT plan_id, plan_code, description, product_family_id, line_id, start_date, end_date FROM flm_mmm_plans WHERE organization_id = :org_id;
  • Reporting on demand parameters: selecting DEMAND_TYPE, DEMAND_CODE, DEMAND_DAYS, and HOURS_PER_DAY to audit calculation inputs.
  • Date-effectiveness checks filtering on START_DATE and END_DATE to identify currently active plans.
  • Joining to FLM_MMM_LINES to expand a plan into its line-level detail for mixed model map reporting.

Related Objects

The most significant related objects, based on documented foreign key and dependency metadata, include:

  • MTL_PARAMETERS — Referenced via FLM_MMM_PLANS.ORGANIZATION_ID; supplies organization context.
  • FLM_MMM_LINES — Child table referencing FLM_MMM_PLANS through ORGANIZATION_ID; holds the line-level detail rows belonging to each plan.
  • FLM_MMM_LINES join columns: ORGANIZATION_ID and PLAN_ID link parent to child.
  • MTL_SYSTEM_ITEMS_B — Used indirectly through product family and line definitions.
  • BOM_DEPARTMENTS / BOM_RESOURCES — Referenced when resolving line capacity for mixed model calculations.
  • Flow Manufacturing concurrent programs and the Mixed Model Map workbench, which read and write this table through the FLM application modules.