Search Results bom_calendar_shifts




Overview
Explore in AI Chat

Overview

The BOM_CALENDAR_SHIFTS table is a core data object within the Oracle E-Business Suite Bills of Material (BOM) module. It serves as the master definition table for work shift patterns associated with manufacturing calendars. This table is fundamental to the application's capacity planning and scheduling engine, defining the distinct operational shifts (e.g., Day, Night, Swing) that can be assigned to a specific workday calendar. Each shift record is uniquely tied to a calendar defined in the BOM_CALENDARS table, enabling precise modeling of an organization's available production time across multiple work periods per day.

Key Information Stored

The table's structure is designed to define shift identifiers within the context of a specific calendar. Its primary key is a composite of CALENDAR_CODE and SHIFT_NUM, ensuring uniqueness. The CALENDAR_CODE is a foreign key referencing BOM_CALENDARS, anchoring the shift to a specific calendar. The SHIFT_NUM is a sequential identifier for the shift within that calendar. While the provided ETRM metadata does not list all columns, the table's relationships imply it stores high-level shift definitions. Detailed shift timing (start/stop times, break patterns) is managed in related child tables, such as BOM_SHIFT_TIMES and BOM_SHIFT_EXCEPTIONS, which use this table's primary key as a foreign key reference.

Common Use Cases and Queries

This table is primarily accessed during manufacturing and capacity planning setups, and during runtime scheduling processes. Common operational and reporting queries involve listing all shifts for a given calendar, validating shift definitions, and integrating calendar data into capacity reports. A typical query to retrieve basic shift information for a calendar would be:

  • SELECT calendar_code, shift_num FROM bom_calendar_shifts WHERE calendar_code = '&CALENDAR_CODE' ORDER BY shift_num;

In practice, direct data manipulation in this table is performed via the Oracle EBS user interface, typically through the "Calendar" forms in the Bills of Material or Capacity menus, which maintain referential integrity with all related tables. Reporting often involves joining this table to BOM_CALENDARS for calendar descriptions and to BOM_SHIFT_TIMES to analyze scheduled hours.

Related Objects

As indicated by the foreign key relationships, BOM_CALENDAR_SHIFTS is a central hub in the calendar data model. Its primary parent table is BOM_CALENDARS. It has several critical child tables that depend on its primary key: BOM_SHIFT_DATES (for assigning shifts to specific dates), BOM_SHIFT_TIMES (for detailed shift start/end times), BOM_SHIFT_EXCEPTIONS (for non-standard shift days), and BOM_WORKDAY_PATTERNS. This network of tables allows Oracle EBS to model complex, real-world manufacturing calendars with multiple shifts, exceptions, and precise timing, which is essential for accurate material requirements planning (MRP), capacity requirements planning (CRP), and shop floor scheduling.