| layout | default |
|---|---|
| title | MSC Horizontal Plan | Oracle EBS SQL Report |
| description | ASCP: Horizontal Plan from the Planners Workbench. Note: The number of Items included in the HP is restricted by the parameter ‘Item Restriction Limit’… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, MSC, Horizontal, Plan, msc_apps_instances&a2m_dblink, msc_plans&a2m_dblink, mfg_lookups&a2m_dblink |
| permalink | /MSC%20Horizontal%20Plan/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
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.
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
msc_apps_instances&a2m_dblink, msc_plans&a2m_dblink, mfg_lookups&a2m_dblink, dual&a2m_dblink
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
| Resource | Link |
|---|---|
| Excel Example Output | MSC Horizontal Plan - Horizontal Plan Dashboard 02-Apr-2026 120400.xlsm |
| Blitz Report™ XML Import | MSC_Horizontal_Plan.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/msc-horizontal-plan/ |
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.
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?"
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.
The report mimics the Horizontal Plan view in the ASCP Planner's Workbench.
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.
- 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.
- 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.
- 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
© 2026 Enginatics