Search Results bom_calendar_exceptions_pk

Overview

The BOM_CALENDAR_EXCEPTIONS table is a core data structure within the Bills of Material (BOM) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the repository for defining specific non-working days or exceptions within a manufacturing calendar. In EBS, manufacturing calendars are critical for scheduling production, calculating lead times, and planning material requirements. This table allows for the precise modeling of real-world operational schedules by overriding the standard pattern of a calendar to account for holidays, planned shutdowns, or other unique non-working periods. Its role is integral to ensuring that manufacturing and planning applications generate accurate and realistic schedules.

Key Information Stored

The table stores the linkage between a calendar, an exception set, and the specific dates designated as exceptions. The primary key, as defined by the BOM_CALENDAR_EXCEPTIONS_PK constraint, is a composite of three columns, ensuring a unique exception date for a given calendar and exception set combination. The key columns are:

• CALENDAR_CODE: Identifies the specific manufacturing calendar to which the exception applies. This column is a foreign key to the BOM_CALENDARS table.
• EXCEPTION_SET_ID: Identifies a predefined grouping of exception dates. This column is a foreign key to the BOM_EXCEPTION_SETS table, allowing for the reuse of common exception patterns across multiple calendars.
• EXCEPTION_DATE: The specific calendar date that is defined as a non-working day or exception.

Common Use Cases and Queries

The primary use case is the maintenance and application of manufacturing calendars for scheduling. A common reporting requirement is to list all exceptions for a given calendar within a date range, which is essential for capacity planning and validating schedule inputs. For example, to retrieve all exceptions for calendar 'USMFG' in the year 2024, one might use:

SELECT exception_date FROM bom_calendar_exceptions WHERE calendar_code = 'USMFG' AND exception_date BETWEEN TO_DATE('01-JAN-2024') AND TO_DATE('31-DEC-2024') ORDER BY exception_date;

Another critical use case is integration with Master Production Scheduling (MPS) and Material Requirements Planning (MRP). These planning engines query this table to skip non-working days when calculating planned order start and completion dates, ensuring that plans are feasible against the actual operating calendar.

Related Objects

The BOM_CALENDAR_EXCEPTIONS table has defined relationships with two key parent tables, as per the provided foreign key metadata:

• BOM_CALENDARS: This is the master table for manufacturing calendars. The CALENDAR_CODE in BOM_CALENDAR_EXCEPTIONS references BOM_CALENDARS.CALENDAR_CODE, establishing which calendar an exception belongs to.
• BOM_EXCEPTION_SETS: This table defines reusable groups of exception dates. The EXCEPTION_SET_ID in BOM_CALENDAR_EXCEPTIONS references BOM_EXCEPTION_SETS.EXCEPTION_SET_ID, allowing efficient management of common holidays (e.g., a "Corporate Holidays" set).

Data from this table is typically accessed via the BOM and MRP application forms and is fundamental to the scheduling logic embedded within the planning and manufacturing APIs.