MSC Horizontal Plan – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Advanced Supply Chain Planning · all Advanced Supply Chain Planning reports
Overview
ASCP: Horizontal Plan from the Planners Workbench.
Note: The number of Items included in the HP is restricted by the parameter ‘Item Restriction Limit’. This parameter defaults from the profile option ‘MSC: HP Maximum Displayed Item Count’ in the ASCP Planning Instance. The value set in the Item Restriction Limit parameter will override the value specified in profile option.
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
Report Type, Planning Instance, Plan, Operating Unit, Organization, Planner, Buyer, Category Set, Category, Item, Unit of Measure, Item Restriction Limit, Cutoff Date, Buckets, Preference, Include Supply Demand Types, Exclude Supply Demand Types, Days Stock Cover Aggregation, Show Item Descriptive Attributes
Oracle EBS Tables Used
msc_apps_instances, msc_plans, mfg_lookups, dual, msc_form_query, msc_material_plans, msc_plan_organizations, msc_system_items, msc_item_categories, msc_trading_partners
Report Categories
Related Reports
MSC Vertical Plan, MSC Plan Order Upload, MSC Plan Orders, CAC ICP PII Inventory and Intransit Value (Period-End), CAC Inventory Pending Cost Adjustment - No Currencies, CAC ICP PII Inventory Pending Cost Adjustment, CAC Inventory and Intransit Value (Period-End), MSC Exceptions, MSC Pegging Hierarchy
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 | MSC Horizontal Plan - Horizontal Plan Dashboard 02-Apr-2026 120400.xlsm |
| Blitz Report™ XML Import | MSC_Horizontal_Plan.xml |
| SQL Source | MSC Horizontal Plan.sql |
| Full Report on Enginatics | www.enginatics.com/reports/msc-horizontal-plan/ |
MSC Horizontal Plan - Case Study & Technical Analysis
Executive Summary
The MSC Horizontal Plan is the ASCP equivalent of the MRP Horizontal Plan. It provides a time-phased, bucketed view of supply, demand, and projected inventory across the entire supply chain. It is the fundamental tool for visualizing the flow of materials over time.
Business Challenge
Planners need to see the “big picture” of inventory flow, not just a list of orders.
- Inventory Projection: “What will our stock level be at the end of each week for the next 6 months?”
- Supply/Demand Balance: “Are we consistently producing more than we are selling?”
- Safety Stock: “When do we dip below our safety stock target?”
Solution
The MSC Horizontal Plan aggregates planning data into time buckets.
Key Features:
- Bucketing: Aggregates data into Daily, Weekly, and Monthly buckets.
- Row Types: Displays rows for Gross Requirements, Scheduled Receipts, Planned Orders, Projected On Hand, and Safety Stock.
- Flexibility: Can include or exclude specific supply/demand types based on user preference.
Technical Architecture
The report mimics the Horizontal Plan view in the ASCP Planner’s Workbench.
Key Tables and Views
MSC_PLANS: Defines the plan.MSC_SUPPLIES/MSC_DEMANDS: The core tables storing all supply and demand transactions.MSC_CAL_WEEK_START_DATES: Used to aggregate daily data into weekly buckets.
Core Logic
- Aggregation: Sums the quantities of supply and demand for each item within each time bucket.
- Calculation: Calculates the Projected Available Balance (PAB) cumulatively:
Previous PAB + Supply - Demand. - Presentation: Pivots the data to display time periods as columns.
Business Impact
- Strategic Planning: Helps identify long-term trends in inventory and capacity.
- Inventory Optimization: Visualizes excess inventory and potential stockouts.
- Communication: Provides a standard format for sharing the plan with stakeholders.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH