MSC Pegging Hierarchy – 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 Pegging Hierarchy. This reports shows the pegging hierarchy from the Top Level Demand.

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, Show Source Org. Pegging, Category Set, Category, End Assembly, Item, Project, Planner, Buyer, Make / Buy, Supply Type, Supplier, Supply Date From, Supply Date To, Exception, Demand Origination, Demand Order, Other Demand Origination, Exclude Other Demand, Demand Date From, Demand Date To, Pegging, Show End Pegs Only, Show Item Descriptive Attributes

Oracle EBS Tables Used

msc_boms, msc_safety_stocks, msc_supplies, msc_exception_details, msc_full_pegging, msc_system_items, msc_plans, msc_plan_organizations, msc_item_categories, msc_category_sets, msc_demands

Report Categories

Enginatics

MSC Plan Order Upload, MSC Plan Orders, MSC Horizontal Plan, MSC Exceptions, MSC Vertical Plan, MRP Plan Orders, CAC ICP PII Inventory and Intransit Value (Period-End), CAC ICP PII Inventory Pending Cost Adjustment, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM

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 Pegging Hierarchy - Pivot Full Hierarchy (Default) 26-Sep-2026 174700.xlsm
Blitz Report™ XML Import MSC_Pegging_Hierarchy.xml
SQL Source MSC Pegging Hierarchy.sql
Full Report on Enginatics www.enginatics.com/reports/msc-pegging-hierarchy/

MSC Pegging Hierarchy - Case Study & Technical Analysis

Executive Summary

The MSC Pegging Hierarchy report provides a deep-dive view into the complex supply chain relationships established by ASCP. It traces the lineage from a top-level demand (like a Sales Order) down through all levels of the Bill of Materials and distribution network to the ultimate supply source.

Business Challenge

In a multi-org, multi-level supply chain, it’s hard to know “why” a supply order exists.

Solution

The MSC Pegging Hierarchy report visualizes the full pegging tree.

Key Features:

Technical Architecture

The report uses the MSC_FULL_PEGGING table, which stores the parent-child links generated by the planning engine.

Key Tables and Views

Core Logic

  1. Root Selection: Starts with a specific demand or supply transaction.
  2. Recursive Traversal: Uses a CONNECT BY query (or recursive CTE) to traverse the MSC_FULL_PEGGING table up or down the tree.
  3. Enrichment: Joins to the supply/demand tables to get human-readable details.

Business Impact

© Enginatics GmbH