MRP Pegging – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Master Scheduling/MRP · all Master Scheduling/MRP reports

Overview

Detail report for MRP planning pegging showing the hierarchy from demand, including forecast, sales orders, work order to supply (WIP jobs, purchase orders and on hand stock)

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

Organization Code, Plan, Sales Order, Order Type, Item, Supplier, Planner, Buyer, Make or Buy, Pegging, Exception, Origination Type, Plan Delay Days from, Actual Delay Days from, Supply Type, Receipt Date older than x days, Exclude On Hand

Oracle EBS Tables Used

bom_calendar_dates, rcv_transactions, oe_sets, per_people_x, po_headers_all, po_document_types_all_vl, po_lines_all, mrp_exception_details, mtl_safety_stocks, mrp_forecast_designators, mrp_forecast_dates, po_line_locations_all, mrp_full_pegging, mtl_system_items_vl, mtl_onhand_quantities_detail, mtl_secondary_inventories, dual, mrp_workbench_display_options, mrp_sr_assignments, mrp_sr_receipt_org, mrp_sr_source_org, mtl_units_of_measure_tl, mtl_planners, fnd_lookup_values, mrp_recommendations, mrp_item_purchase_orders, wip_entities, wip_discrete_jobs, mrp_gross_requirements, oe_order_lines_all, oe_order_headers_all, oe_transaction_types_tl, mtl_parameters, cst_item_costs, wip_operations, bom_departments, bom_standard_operations, wip_operation_resources, bom_resources, po_requisition_lines_all, ap_suppliers

Report Categories

Enginatics

INV Item Upload, INV Item Upload 11i, INV Items, PO Headers and Lines

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 MRP Pegging 02-Aug-2018 222325.xlsx
Blitz Report™ XML Import MRP_Pegging.xml
SQL Source MRP Pegging.sql
Full Report on Enginatics www.enginatics.com/reports/mrp-pegging/

MRP Pegging - Case Study & Technical Analysis

Executive Summary

The MRP Pegging report provides a comprehensive view of the supply-demand links established by the planning engine. Unlike the “End Assembly Pegging” report which focuses on the final product, this report details the immediate parent-child relationships for any item, showing exactly what demand is driving a specific supply order.

Business Challenge

Planners need to justify every supply order.

Solution

The MRP Pegging report exposes the “pegging” tree.

Key Features:

Technical Architecture

The report queries the pegging data generated during the MRP run.

Key Tables and Views

Core Logic

  1. Root Identification: Starts with a specific item or order.
  2. Traversal: Follows the PEGGING_ID links in MRP_FULL_PEGGING to find the related transactions.
  3. Enrichment: Joins to source tables (PO, WIP, OE) to get human-readable details like Order Numbers and Customer Names.

Business Impact

© Enginatics GmbH