Search Results bom_setup_types_pk

Overview

The BOM_SETUP_TYPES table is a foundational setup table within the Oracle E-Business Suite Bills of Material (BOM) module. It serves as a master repository for defining and classifying different types of manufacturing setup operations. In discrete manufacturing, a setup is a preparatory process required on a resource, such as a machine or work center, before it can begin production of a specific item or operation. This table standardizes the categorization of these setup activities, enabling consistent definition, costing, and scheduling across the manufacturing floor. Its primary role is to provide a controlled list of setup types that can be assigned to resources, thereby linking setup requirements to specific manufacturing operations and facilitating accurate production planning.

Key Information Stored

The core data stored in BOM_SETUP_TYPES centers on the unique identification and description of each setup type. While the full column list is not detailed in the provided metadata, the structure is defined by its primary key. The critical column is SETUP_ID, which is the table's primary key (BOM_SETUP_TYPES_PK). This column holds a unique numeric identifier for each distinct setup type record. Typically, companion columns would include fields such as SETUP_TYPE (a code or name), a DESCRIPTION, and control columns like DISABLE_DATE, CREATION_DATE, and LAST_UPDATE_DATE. The table acts as a simple but essential lookup, ensuring referential integrity for any setup-related data elsewhere in the application.

Common Use Cases and Queries

This table is primarily referenced during the configuration of manufacturing resources and the definition of routing operations. A common use case is when a process engineer defines a new work center and needs to specify the standard setup activities required. They would select from the predefined types in this table. For reporting, the table is often joined to resource information to analyze setup time allocations or costs. A typical query would retrieve all active setup types for a user interface LOV (List of Values) or to validate data in transactional tables.

• Sample Query to List All Setup Types:
  SELECT setup_id, setup_type, description
FROM bom.bom_setup_types
WHERE disable_date IS NULL
ORDER BY setup_type;
• Integration Point: The setup type is assigned to a resource via the BOM_RESOURCE_SETUPS table, which then influences the standard cost calculation for manufacturing overhead and the scheduling duration in Work in Process (WIP).

Related Objects

The BOM_SETUP_TYPES table has a direct parent-child relationship with one key transactional table, as documented in the provided foreign key metadata. This relationship is fundamental to the setup data model.

• BOM_RESOURCE_SETUPS: This is the primary table that references BOM_SETUP_TYPES. The foreign key BOM_RESOURCE_SETUPS.SETUP_ID links to BOM_SETUP_TYPES.SETUP_ID. The BOM_RESOURCE_SETUPS table stores the specific setup time and cost details for individual manufacturing resources. Each record in BOM_RESOURCE_SETUPS must point to a valid, predefined setup type in BOM_SETUP_TYPES, enforcing data integrity for all resource setup definitions.