MSC Exceptions – 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 Planning Exceptions 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, Planner, Buyer, Exception Group, Exception Type, Due Date From, Due Date To, From Date From, From Date To, To Date From, To Date To, Show Item Descriptive Attributes
Oracle EBS Tables Used
msc_category_sets, msc_apps_instances, msc_plans, msc_exception_details_v, msc_system_items, msc_demands
Report Categories
Related Reports
MSC Plan Orders, MSC Vertical Plan, MSC Pegging Hierarchy, MSC Plan Order Upload, MSC Horizontal Plan, MRP Plan Orders, CAC Interface Error Summary, CAC ICP PII Inventory Pending Cost Adjustment, CAC ICP PII Inventory and Intransit 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 Exceptions - Dashboard 17-Jan-2023 234651.xlsm |
| Blitz Report™ XML Import | MSC_Exceptions.xml |
| SQL Source | MSC Exceptions.sql |
| Full Report on Enginatics | www.enginatics.com/reports/msc-exceptions/ |
MSC Exceptions - Case Study & Technical Analysis
Executive Summary
The MSC Exceptions report is the primary alerting mechanism for the Advanced Supply Chain Planning (ASCP) engine. It highlights critical issues in the supply chain plan that require planner intervention, such as late orders, resource overloads, or material shortages.
Business Challenge
ASCP plans are complex and cover the entire supply chain. Planners cannot review every single order. They need to know:
- Criticality: “Which customer orders are in danger of being late?”
- Capacity: “Which manufacturing lines are overloaded next week?”
- Data Quality: “Which items have invalid lead times or missing costs?”
Solution
The MSC Exceptions report filters the plan results into actionable alerts.
Key Features:
- Exception Groups: Categorizes exceptions (e.g., “Late Sales Orders”, “Resource Overloaded”, “Material Shortage”).
- Drill-Down: Provides the specific details (Item, Order, Date, Quantity) for each exception.
- Prioritization: Allows filtering by Exception Type and Planner to focus on the most urgent issues.
Technical Architecture
The report queries the exception tables in the ASCP schema (often on a separate planning server).
Key Tables and Views
MSC_EXCEPTION_DETAILS_V: The primary view for exception messages.MSC_PLANS: Defines the plan being analyzed.MSC_SYSTEM_ITEMS: Provides item details within the plan.MSC_DEMANDS: Links exceptions to specific demand records.
Core Logic
- Exception Generation: During the ASCP run, the engine identifies violations of constraints (time, capacity, material).
- Storage: These violations are stored in the exception tables with a specific Exception Type ID.
- Reporting: The report retrieves these records, joined with the relevant entity (Item, Resource, Order) for context.
Business Impact
- Proactive Management: Enables planners to fix problems before they impact the customer.
- Resource Optimization: Helps identify bottlenecks (overloaded resources) and excess capacity.
- Plan Quality: Highlights data issues that are causing poor planning results.
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