Search Results bom_shift_times_pk

Overview

The BOM_SHIFT_TIMES table is a core data object within the Bills of Material (BOM) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the detailed repository for defining the precise start and end times of individual shifts within a workday calendar. This table is essential for modeling manufacturing capacity and scheduling, as it provides the granular time-of-day data that, when combined with shift definitions and calendar dates, enables the system to calculate available production hours. Its role is to store the specific time intervals that constitute a shift, allowing for complex shift patterns that may include breaks or multiple time segments within a single work shift.

Key Information Stored

The table's structure is defined by a composite primary key and columns that capture time-specific data. The primary key columns, CALENDAR_CODE and SHIFT_NUM, uniquely identify the shift to which these times belong, linking directly to the BOM_CALENDAR_SHIFTS table. The core data is stored in the FROM_TIME and TO_TIME columns, which hold the beginning and ending times for a specific segment of a shift. A single shift defined in BOM_CALENDAR_SHIFTS can therefore have multiple corresponding rows in BOM_SHIFT_TIMES to model scenarios like a morning work period, a lunch break, and an afternoon work period.

Common Use Cases and Queries

This table is primarily accessed for capacity planning, detailed scheduling, and shop floor control reporting. A common use case is calculating the total available working hours for a resource on a given day by summing the duration (TO_TIME - FROM_TIME) for all time segments of its assigned shift. For reporting, it is often joined to calendar and shift tables to produce detailed shift schedules. A typical query pattern involves joining to BOM_CALENDAR_SHIFTS and BOM_CALENDAR_DATES to retrieve a complete working schedule.

• Sample Query: To list all time segments for a specific calendar and shift: SELECT FROM_TIME, TO_TIME FROM BOM.BOM_SHIFT_TIMES WHERE CALENDAR_CODE = 'STANDARD' AND SHIFT_NUM = 1 ORDER BY FROM_TIME;
• Reporting Use Case: Generating a detailed plant shift timetable for communication to manufacturing personnel, showing exact start, break, and end times.

Related Objects

The BOM_SHIFT_TIMES table has a direct and critical foreign key relationship with the BOM_CALENDAR_SHIFTS table, which defines the higher-level shift (e.g., Day Shift, Night Shift) within a calendar. This relationship enforces that a shift time must belong to a valid, pre-defined shift.

• Foreign Key to BOM_CALENDAR_SHIFTS: The table BOM_SHIFT_TIMES references BOM_CALENDAR_SHIFTS via the columns (CALENDAR_CODE, SHIFT_NUM). This is a many-to-one relationship where multiple time segments belong to one shift definition. This is the primary join path for most queries involving this table.
• Primary Key: The table's primary key, BOM_SHIFT_TIMES_PK, is on (CALENDAR_CODE, SHIFT_NUM, FROM_TIME, TO_TIME), ensuring the uniqueness of each time segment within a shift.