Skip to the content.

BOM Calendars – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Bills of Material · all Bills of Material reports

Overview

Bill of material calendars and calendar dates

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Calendar, Show Organizations, Organization Code, Show Dates, Future only

Oracle EBS Tables Used

bom_calendars, bom_calendar_dates, mtl_parameters, hr_all_organization_units_vl

Report Categories

Enginatics

MRP Pegging, CAC ICP PII Inventory and Intransit Value (Period-End), INV Organization Parameters, CAC ICP PII Inventory Pending Cost Adjustment, BOM Department Upload, BOM Calendar Exceptions, PA Project Upload, CRP Resource Plan

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output BOM Calendars 04-Apr-2026 123137.xlsx
Blitz Report™ XML Import BOM_Calendars.xml
SQL Source BOM Calendars.sql
Full Report on Enginatics www.enginatics.com/reports/bom-calendars/

Case Study & Technical Analysis: BOM Calendars Report

Executive Summary

The BOM Calendars report provides a comprehensive operational view of the manufacturing and planning calendars defined within Oracle E-Business Suite. These calendars are the backbone of supply chain planning, determining working days, shifts, and exceptions for manufacturing resources. This report offers a streamlined way to audit, validate, and visualize calendar configurations across the enterprise, ensuring that production schedules align with actual working capacity.

Business Challenge

In complex manufacturing environments, maintaining accurate calendars is critical but often overlooked.

The Solution

The BOM Calendars report solves these challenges by extracting calendar definitions and their associated dates directly from the database into a flexible Excel format.

Technical Architecture (High Level)

This report is built on a robust SQL query that joins calendar header information with detailed date records and organization assignments.

Primary Tables

Logical Relationships

Parameters & Filtering

The report includes several parameters to tailor the output to specific needs:

Performance & Optimization

FAQ

Q: Why don’t I see any dates in the output? A: Ensure the “Show Dates” parameter is set to ‘Yes’. By default, the report may only show the calendar header information to keep the output concise.

Q: How can I see which organizations are using a specific calendar? A: Set the “Show Organizations” parameter to ‘Yes’. This will add columns for Organization Code and Name to the output.

Q: Can I use this report to find expired calendars? A: Yes, the report includes Calendar End Date. You can filter the Excel output to find calendars that have already ended or are expiring soon.


© Enginatics GmbH