Skip to the content.

MSC Vertical 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: Vertical Plan from the Planners Workbench.

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

Planning Instance, Plan, Organization, Category Set, Category, Item, Cutoff Date, Exclude Zero Quantity, Show Item Descriptive Attributes

Oracle EBS Tables Used

msc_period_start_dates, msc_trading_partners, msc_cal_week_start_dates, msc_vertical_plan_v, msc_apps_instances, msc_plans, msc_system_items, msc_item_categories, msc_category_sets

Report Categories

Enginatics, R12 only

MSC Horizontal Plan, MSC Plan Orders, MSC Exceptions, MSC Plan Order Upload, MSC Pegging Hierarchy, MRP Plan Orders, MSC Sourcing Rule Assignment Upload, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC Inventory Lot and Locator OPM Value (Period-End)

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 Vertical Plan - Vertical Plan Dasboard 28-Aug-2022 070519.xlsm
Blitz Report™ XML Import MSC_Vertical_Plan.xml
SQL Source MSC Vertical Plan.sql
Full Report on Enginatics www.enginatics.com/reports/msc-vertical-plan/

MSC Vertical Plan - Case Study & Technical Analysis

Executive Summary

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.

Business Challenge

Planners see a total number in the Horizontal Plan (e.g., “Demand: 500”) and need to know what comprises it.

Solution

The MSC Vertical Plan lists the bucketed totals and can be used to drill down into details.

Key Features:

Technical Architecture

The report queries the vertical plan view in ASCP.

Key Tables and Views

Core Logic

  1. Aggregation: Groups supply and demand data by Item, Organization, and Date Bucket.
  2. Presentation: Lists the buckets vertically (hence the name), allowing for more detailed columns than the horizontal pivot.

Business Impact


© Enginatics GmbH