Search Results bom_mixed_model_map_u1

Overview

BOM.BOM_MIXED_MODEL_MAP_PROCESSES is a transaction-data table in the Oracle E-Business Suite Bills of Material (BOM) schema that stores the individual processes, or line operations, associated with a mixed model map, together with the summary and weighted timing information used for mixed model production line balancing. A mixed model map represents a production line configuration in which multiple product models are built on the same line, and this table records each process that participates in that configuration. In Oracle EBS 12.1.1 and 12.2.2, the object is owned by the BOM schema, resides in the APPS_TS_TX_DATA tablespace, and carries a VALID status with FND Design Data registration under BOM.BOM_MIXED_MODEL_MAP_PROCESSES.

The table is classified heuristically as satellite-leaning in a Data Vault modeling sense. This classification is a modeling suggestion rather than a documented fact: the table holds descriptive and calculated attributes (weighted times, resource counts, takt times, deltas) that describe a process context owned by the mixed model map header, which is characteristic of a satellite attached to a hub-and-link structure keyed by MIXED_MODEL_MAP_ID.

Key Information Stored

The composite primary key, BOM_MIXED_MODEL_MAP_PROC_PK, is defined on MIXED_MODEL_MAP_ID, GROUP_NUMBER, and SEQUENCE_ID. These three columns also form the unique index BOM_MIXED_MODEL_MAP_U1, which is the business-key candidate for the table.

• MIXED_MODEL_MAP_ID — identifier of the owning mixed model map; the foreign key to the header table.
• GROUP_NUMBER — processes in a mixed model map are grouped in sets of five; this value identifies the group set in which the process resides.
• SEQUENCE_ID — the display position (1 through 5) of the process within its group.
• OPERATION_CODE — the process or line operation name.
• MACHINE_WEIGHTED_TIME, LABOR_WEIGHTED_TIME, TOTAL_WEIGHTED_TIME — weighted time values for machine, labor, and total effort for the process.
• MACHINES_NEEDED, MACHINES_ASSIGNED, MACHINES_NEEDED_DELTA — machine capacity demand, actual assignment, and the variance against the baseline map.
• LABOR_NEEDED, LABOR_ASSIGNED, LABOR_NEEDED_DELTA — labor resource demand, assignment, and baseline variance.
• TAKT_TIME, TAKT_TIME_FOR_ASSIGNED — calculated process cycle time and the recalculated time based on assigned machines or labor.
• IN_PROCESS_KANBAN, IN_PROCESS_KANBAN_DELTA — in-process kanban requirements and their change from the baseline.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) plus the concurrent program columns (REQUEST_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) for audit and traceability.

Common Use Cases and Queries

Typical reporting retrieves all processes for a given map in display order, or compares needed versus assigned resources to identify line balancing exceptions.

SELECT group_number, sequence_id, operation_code,
       machines_needed, machines_assigned, machines_needed_delta,
       labor_needed, labor_assigned, labor_needed_delta,
       takt_time, takt_time_for_assigned
FROM   bom.bom_mixed_model_map_processes
WHERE  mixed_model_map_id = :p_map_id
ORDER  BY group_number, sequence_id;

Baseline variance analysis uses the delta columns to flag processes exceeding the baseline, while capacity reporting aggregates total weighted times across operations. Takt time and takt time for assigned resources support cycle-time studies and machine assignment decisions.

Related Objects

• BOM.BOM_MIXED_MODEL_MAP_HEADER — parent table; joined on MIXED_MODEL_MAP_ID via the foreign key from this table.
• BOM.BOM_MIXED_MODEL_MAP_CELLS — child/referencing table; also keyed by MIXED_MODEL_MAP_ID, containing the cell-level data for the map produced by these processes.
• Mixed model map concurrent programs and the BOM mixed model workbench UI rely on this table for process and operation display.