MSC Plan Orders – 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: Export Supply and Demand Orders 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, Source Organiziation, Category Set, Category, Item, Supply/Demand, Planner, Buyer, Make/Buy, Order Type, Exclude Onhand Supply, Suggested Due Date From, Suggested Due Date To, Suggested Start Date From, Suggested Start Date To, Show Pegging, Show Item Descriptive Attributes
Oracle EBS Tables Used
msc_demands, msc_supplies, msc_safety_stocks, msc_trading_partner_sites, msc_trading_partners, msc_location_associations, msc_orders_v, msc_apps_instances, msc_plans, msc_system_items, msc_planners, msc_category_sets, msc_full_pegging
Report Categories
Related Reports
MSC Vertical Plan, MSC Horizontal Plan, MSC Plan Order Upload, MSC Pegging Hierarchy, MSC Sourcing Rule Assignment Upload, MSC Exceptions, MRP Plan Orders, CAC Inventory Lot and Locator OPM Value (Period-End), CAC Interface Error Summary
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 | Example |
| Blitz Report™ XML Import | MSC_Plan_Orders.xml |
| SQL Source | MSC Plan Orders.sql |
| Full Report on Enginatics | www.enginatics.com/reports/msc-plan-orders/ |
MSC Plan Orders - Case Study & Technical Analysis
Executive Summary
The MSC Plan Orders report exports the detailed supply and demand transactions from the ASCP plan. It is the raw data feed for any detailed analysis of the plan’s output, listing every Planned Order, Purchase Order, Work Order, and Sales Order considered by the engine.
Business Challenge
Planners and analysts need access to the raw planning data for custom analysis.
- Custom Reporting: “I need to build a pivot table showing the total planned spend by supplier for the next quarter.”
- Data Validation: “I need to check if the plan is respecting the ‘Fixed Days Supply’ modifier for these 20 items.”
- Integration: “We need to export the planned orders to a third-party logistics system.”
Solution
The MSC Plan Orders report provides a flat-file export of the plan data.
Key Features:
- Comprehensive: Includes all transaction types (Supply and Demand).
- Detailed: Includes dates (Suggested, Original), quantities, order numbers, and action messages.
- Filtering: Allows filtering by Plan, Organization, Item, Planner, and Order Type.
Technical Architecture
The report queries the core supply and demand tables in the ASCP schema.
Key Tables and Views
MSC_SUPPLIES: Stores all supply transactions (PO, WIP, Planned Orders, On-Hand).MSC_DEMANDS: Stores all demand transactions (SO, Forecast, WIP Component Demand).MSC_SYSTEM_ITEMS: Item attributes.MSC_TRADING_PARTNERS: Organization and Supplier details.
Core Logic
- Union: Combines data from
MSC_SUPPLIESandMSC_DEMANDSinto a single list. - Joins: Links to item and partner tables to resolve IDs to names.
- Filtering: Applies user-selected parameters to limit the output.
Business Impact
- Flexibility: Enables unlimited custom analysis using Excel or BI tools.
- Transparency: Provides full visibility into the inputs and outputs of the planning engine.
- Collaboration: Facilitates data sharing with external partners or internal departments.
Useful Links
- 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
© Enginatics GmbH