Search Results bom_workday_patterns




Overview
Explore in AI Chat

Overview

The BOM_WORKDAY_PATTERNS table is a core data structure within the Oracle E-Business Suite (EBS) Bills of Material (BOM) module, specifically for versions 12.1.1 and 12.2.2. It serves as the definitive repository for defining the detailed on/off workday patterns that constitute manufacturing calendars and shifts. These calendars are fundamental to scheduling and capacity planning across the manufacturing and supply chain execution systems. The table stores the sequential, day-by-day working pattern for a given calendar and shift, enabling the system to model complex work schedules, including non-standard work weeks, holidays, and shift rotations. Its integrity is maintained through a primary key and foreign key relationships to master calendar definitions.

Key Information Stored

The table's structure is designed to define a repeating pattern of workdays. The primary key is a composite of three columns: CALENDAR_CODE, SHIFT_NUM, and SEQ_NUM. The CALENDAR_CODE links to the BOM_CALENDARS table, identifying the specific manufacturing calendar. The SHIFT_NUM, often linked to BOM_CALENDAR_SHIFTS, specifies the shift within that calendar. The SEQ_NUM represents the sequential position of a day within the defined pattern cycle. While the ETRM excerpt does not list all data columns, typical columns in this table include an indicator (e.g., WORKDAY_TYPE or ON_OFF_FLAG) to specify whether the day at the given sequence number is a working ("On") or non-working ("Off") day. This pattern repeats to define the calendar's continuous timeline.

Common Use Cases and Queries

This table is primarily accessed for scheduling calculations, such as determining lead times, calculating operation start and end dates, and assessing resource availability. A common reporting need is to validate or list the complete work pattern for a specific calendar and shift. A typical query would join BOM_WORKDAY_PATTERNS with BOM_CALENDARS and BOM_CALENDAR_SHIFTS for descriptive information.

  • Sample Query to Retrieve a Calendar Pattern:
    SELECT calendar_code, shift_num, seq_num, workday_type
    FROM bom.bom_workday_patterns
    WHERE calendar_code = 'STANDARD'
    AND shift_num = 1
    ORDER BY seq_num;
  • Scheduling Logic: Applications use the sequential pattern to programmatically calculate the next or previous working day by iterating through sequence numbers and applying the on/off flags.

Related Objects

The BOM_WORKDAY_PATTERNS table is central to the EBS manufacturing calendar framework. Its key relationships, as documented, are:

  • BOM_CALENDARS: The parent table. The foreign key on CALENDAR_CODE ensures every workday pattern belongs to a valid, defined calendar.
  • BOM_CALENDAR_SHIFTS: The foreign key on the composite of CALENDAR_CODE and SHIFT_NUM ties the detailed pattern to a specific shift definition within the calendar.
  • Dependent Modules: While not direct foreign keys, this table's data is critically referenced by the Manufacturing Scheduling, Capacity Planning, Work in Process (WIP), and Master Production Scheduling (MPS) modules for all time-phased calculations.