Results for “from_setup_id”

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

Overview

BOM_SETUP_TRANSITIONS is a Bills of Material (BOM) module table owned by the BOM schema in Oracle E-Business Suite 12.1.1 and 12.2.2. As its description indicates, it stores the setup transition definitions that govern changeover or sequence-dependent setup behavior between resource setups on a manufacturing resource. Each row describes a directed transition from one resource setup to another, providing the time, unit of measure, and penalty associated with moving between those setup states during a producing operation.

In the manufacturing execution and scheduling context, setup transitions are consumed by sequencing and scheduling logic (for example, Oracle Advanced Supply Chain Planning and shop floor scheduling) to model sequence-dependent setup cost and time. The table acts as the master definition of these transition rules, keyed to a specific resource and organization.

Under the heuristic Data Vault classification derived from its foreign key structure, BOM_SETUP_TRANSITIONS is modeled as a link. This reflects its role as an associative object that resolves a many-to-many style relationship between two references to BOM_RESOURCE_SETUPS (the FROM_SETUP_ID and TO_SETUP_ID), keyed against a resource and organization. This is a modeling suggestion rather than a physical mandate; in the operational schema the object is a standard relational table.

Key Information Stored

The table's unique business key, enforced by the unique index BOM_SETUP_TRANSITIONS_U1 (and documented Primary Key BOM_SETUP_TRANSITIONS_UK), is the composite of RESOURCE_ID, ORGANIZATION_ID, FROM_SETUP_ID, and TO_SETUP_ID. This composite uniquely identifies each transition rule within an organization's resource definition; the table does not expose a single-column surrogate key in the documented metadata, so this composite serves as the effective primary key.

• RESOURCE_ID — the resource to which the transition applies; foreign key to BOM_RESOURCE_SETUPS.
• ORGANIZATION_ID — the inventory/organization context that scopes the resource and setup definitions.
• FROM_SETUP_ID — the originating resource setup for the transition; references BOM_RESOURCE_SETUPS.
• TO_SETUP_ID — the destination resource setup for the transition; references BOM_RESOURCE_SETUPS.
• TRANSITION_TIME — the setup time incurred when changing from the FROM to the TO setup.
• TRANSITION_UOM — the unit of measure associated with TRANSITION_TIME (for example, minutes or hours).
• TRANSITION_PENALTY — a cost or penalty value applied to the transition, used by sequencing/scheduling optimization.
• OPERATION_ID — reference to the operation context in which the transition is relevant.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Oracle EBS Who columns capturing audit and user history.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard flex/descriptive attribute block for extensibility.

Common Use Cases and Queries

Typical uses include retrieving the setup time matrix for a resource to feed scheduling engines, maintaining transition penalties, and reporting on changeover costs for capacity or sequencing analysis.

• List all transitions defined for a resource within an organization:
  SELECT FROM_SETUP_ID, TO_SETUP_ID, TRANSITION_TIME, TRANSITION_UOM, TRANSITION_PENALTY FROM BOM.BOM_SETUP_TRANSITIONS WHERE RESOURCE_ID = :resource_id AND ORGANIZATION_ID = :org_id;
• Join transitions back to their setup descriptions via BOM_RESOURCE_SETUPS on the FROM and TO setup identifiers to produce a readable setup matrix.
• Aggregate average transition time or penalty per resource for capacity and cost reporting.
• Identify missing or unmaintained transitions where TRANSITION_TIME or TRANSITION_PENALTY is null for active resources.

Related Objects

• BOM_RESOURCE_SETUPS — the parent setup definition table. BOM_SETUP_TRANSITIONS references it twice: (RESOURCE_ID, ORGANIZATION_ID, FROM_SETUP_ID) and (RESOURCE_ID, ORGANIZATION_ID, TO_SETUP_ID). Both FROM_SETUP_ID and TO_SETUP_ID resolve against this table for the given resource and organization.
• BOM_RESOURCES / BOM_RESOURCE_CHARGES — define the resources whose setups and transitions are described here.
• BOM_OPERATION_RESOURCES / BOM_OPERATIONS — relate transitions to the operations (OPERATION_ID) executed on the resource.
• Standard Who columns and attribute flexfields — governed by common Oracle EBS audit and DFF conventions.

Because the table's documented foreign keys all resolve to BOM_RESOURCE_SETUPS, any query or report must join through that parent to obtain setup names and descriptions rather than assuming denormalized setup text in this table.