Search Results bom_mixed_model_map_processes




Overview
Explore in AI Chat

Overview

BOM_MIXED_MODEL_MAP_PROCESSES is an Oracle EBS Bills of Material (BOM) table that stores the process or line-operation detail, together with aggregated summary metrics, for each mixed model map. Mixed model maps are used in mixed model production environments to balance work across lines, cells, and operations when multiple product models share capacity. This table captures, per operation, the loading requirements and assignments for machine and labor resources, takt time, and in-process kanban quantities that drive line-balancing decisions.

The table resides in the BOM schema and is classified as VALID in the ETRM 12.1.1 / 12.2.2 metadata. Its primary key constraint, BOM_MIXED_MODEL_MAP_PROC_PK, is composed of the columns MIXED_MODEL_MAP_ID, GROUP_NUMBER, and SEQUENCE_ID. A unique index, BOM_MIXED_MODEL_MAP_U1, covers the same three columns, confirming them as the business-key candidate. From a Data Vault modeling perspective, the metadata's heuristic classification is satellite-leaning: the table supplies descriptive and derived measures keyed to a parent map and a grouping/sequence, rather than acting as a standalone hub or pure transactional link.

Key Information Stored

The table documents 26 columns in the 12.2.2 physical schema; the surrogate row identity is the composite primary key rather than a single sequence-generated ID.

Common Use Cases and Queries

Typical use cases include line-balancing analysis, machine and labor capacity reporting, and takt-time monitoring for mixed model maps. Analysts join the table to its header to obtain map-level context and to BOM_MIXED_MODEL_MAP_CELLS where cell-level loading detail is required.

A representative query retrieves operations where assigned resources fall short of need:

  • SELECT p.MIXED_MODEL_MAP_ID, p.OPERATION_CODE, p.MACHINES_NEEDED, p.MACHINES_ASSIGNED, p.MACHINES_NEEDED_DELTA, p.LABOR_NEEDED, p.LABOR_ASSIGNED, p.LABOR_NEEDED_DELTA FROM BOM.BOM_MIXED_MODEL_MAP_PROCESSES p WHERE p.MIXED_MODEL_MAP_ID = :map_id ORDER BY p.GROUP_NUMBER, p.SEQUENCE_ID;

Reporting commonly aggregates weighted time by operation to compare total weighted time against takt time, and to reconcile in-process kanban against its delta. Because REQUEST_ID and the program columns are populated by concurrent processes, purging or auditing refreshes can be scoped by PROGRAM_UPDATE_DATE.

Related Objects

  • BOM_MIXED_MODEL_MAP_HEADER — Parent table; join on MIXED_MODEL_MAP_PROCESSES.MIXED_MODEL_MAP_ID = MAP_HEADER.MIXED_MODEL_MAP_ID.
  • BOM_MIXED_MODEL_MAP_CELLS — Cell-level detail; the documented relationship maps MIXED_MODEL_MAP_ID, GROUP_NUMBER, and SEQUENCE_ID between the two tables.
  • BOM_OPERATION_SEQUENCES / BOM_OPERATION_RESOURCES — Source of operation and resource definitions referenced by OPERATION_CODE.
  • BOM_RESOURCES — Resource master used to interpret machine and labor assignments.
  • BOM_DEPARTMENTS — Departments under which line operations are defined.
  • MTL_SYSTEM_ITEMS_B — Item context for the models and maps being balanced.
  • FND_CONCURRENT_REQUESTS — Resolves REQUEST_ID to the concurrent program execution that populated the row.
  • FND_USER — Resolves CREATED_BY and LAST_UPDATED_BY to application users for audit reporting.