| layout | default |
|---|---|
| title | MSC Vertical Plan | Oracle EBS SQL Report |
| description | ASCP: Vertical Plan from the Planners Workbench. – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, MSC, Vertical, Plan, msc_period_start_dates&a2m_dblink, msc_trading_partners&a2m_dblink, msc_cal_week_start_dates&a2m_dblink |
| permalink | /MSC%20Vertical%20Plan/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
ASCP: Vertical Plan from the Planners Workbench.
Planning Instance, Plan, Organization, Category Set, Category, Item, Cutoff Date, Exclude Zero Quantity, Show Item Descriptive Attributes
msc_period_start_dates&a2m_dblink, msc_trading_partners&a2m_dblink, msc_cal_week_start_dates&a2m_dblink, msc_vertical_plan_v&a2m_dblink, msc_apps_instances&a2m_dblink, msc_plans&a2m_dblink, msc_system_items&a2m_dblink, msc_item_categories&a2m_dblink, msc_category_sets&a2m_dblink
MSC Horizontal Plan, MSC Plan Orders, MSC Exceptions, MSC Pegging Hierarchy 11i, MSC Pegging Hierarchy, MSC Plan Order Upload, MRP Plan Orders, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC ICP PII Inventory and Intransit Value (Period-End)
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 Vertical Plan - Vertical Plan Dasboard 28-Aug-2022 070519.xlsm |
| Blitz Report™ XML Import | MSC_Vertical_Plan.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/msc-vertical-plan/ |
The MSC Vertical Plan provides a bucketed view of the plan, similar to the Horizontal Plan, but typically oriented to show the detailed composition of supply and demand within each bucket. It is often used to analyze the specific transactions that make up the totals seen in the Horizontal Plan.
Planners see a total number in the Horizontal Plan (e.g., "Demand: 500") and need to know what comprises it.
- Drill-Down: "The Horizontal Plan shows a huge spike in demand in Week 4. What orders are causing that?"
- Composition: "How much of this week's supply is coming from Purchase Orders versus Work Orders?"
The MSC Vertical Plan lists the bucketed totals and can be used to drill down into details.
Key Features:
- Bucketed View: Shows data in time periods (Days/Weeks).
- Detailed Rows: Can break down the totals by transaction type or specific order.
- Comparison: Useful for comparing supply vs. demand side-by-side for each period.
The report queries the vertical plan view in ASCP.
MSC_VERTICAL_PLAN_V: A view specifically designed to aggregate and present plan data in a vertical format.MSC_PLANS: Plan definition.MSC_PERIOD_START_DATES: Defines the time buckets.
- Aggregation: Groups supply and demand data by Item, Organization, and Date Bucket.
- Presentation: Lists the buckets vertically (hence the name), allowing for more detailed columns than the horizontal pivot.
- Root Cause Analysis: Helps planners quickly identify the specific orders driving aggregate plan results.
- Plan Validation: Used to verify that the bucketing logic is working as expected.
- 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