Search Results bom_operational_routings




Overview
Explore in AI Chat

Overview

The BOM_OPERATIONAL_ROUTINGS table is the central repository for routing definitions within Oracle E-Business Suite's Bills of Material (BOM) module. It stores the master data that defines the sequence of manufacturing operations required to produce an assembly item. This table is fundamental to manufacturing execution, as it provides the standard instructions referenced by Work in Process (WIP) for discrete jobs, repetitive schedules, and flow schedules. Each record represents a unique routing for a specific assembly within a manufacturing organization, which may include an alternate routing designator.

Key Information Stored

The table's structure is designed to uniquely identify and describe a routing. Its primary key is ROUTING_SEQUENCE_ID, a unique system-generated identifier. A composite unique key ensures that a routing is uniquely defined by the combination of ASSEMBLY_ITEM_ID, ORGANIZATION_ID, and ALTERNATE_ROUTING_DESIGNATOR. Critical columns include ASSEMBLY_ITEM_ID (the item being built), COMMON_ROUTING_SEQUENCE_ID (for referencing a common routing), COMMON_ASSEMBLY_ITEM_ID (the common item from which the routing is copied), and ALTERNATE_ROUTING_DESIGNATOR (to define primary or alternate manufacturing paths). Operational details such as the COMPLETION_SUBINVENTORY, COMPLETION_LOCATOR_ID, and LINE_ID are also stored here to provide default values for production transactions.

Common Use Cases and Queries

This table is central to manufacturing setup, reporting, and integration. Common use cases include validating routing existence before creating jobs, listing all alternate routings for an assembly, and identifying routings that reference a common routing template. A typical query to retrieve routing headers for an item would join with MTL_SYSTEM_ITEMS_B and optionally BOM_ALTERNATE_DESIGNATORS.

  • Sample Query: SELECT bor.ROUTING_SEQUENCE_ID, bor.ASSEMBLY_ITEM_ID, msi.CONCATENATED_SEGMENTS ASSEMBLY, bor.ALTERNATE_ROUTING_DESIGNATOR, bor.COMMON_ROUTING_SEQUENCE_ID FROM BOM.BOM_OPERATIONAL_ROUTINGS bor, INV.MTL_SYSTEM_ITEMS_B msi WHERE bor.ASSEMBLY_ITEM_ID = msi.INVENTORY_ITEM_ID AND bor.ORGANIZATION_ID = msi.ORGANIZATION_ID AND bor.ORGANIZATION_ID = :p_org_id;
  • Reporting often involves aggregating data from this table with BOM_OPERATION_SEQUENCES to analyze the complexity and steps of manufacturing processes.

Related Objects

BOM_OPERATIONAL_ROUTINGS has extensive relationships with core manufacturing tables. It is the parent table for BOM_OPERATION_SEQUENCES, which holds the detailed operation steps. It is referenced by WIP_DISCRETE_JOBS, WIP_REPETITIVE_ITEMS, and WIP_FLOW_SCHEDULES to assign a routing to a production entity. Foreign key relationships enforce integrity with inventory items (MTL_SYSTEM_ITEMS_B), subinventories (MTL_SECONDARY_INVENTORIES), locators (MTL_ITEM_LOCATIONS), and production lines (WIP_LINES). The BOM_DELETE_ENTITIES table references it for managing pending deletions, and the BOM_ALTERNATE_DESIGNATORS table validates the ALTERNATE_ROUTING_DESIGNATOR.