MSC Exceptions – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
ASCP: Export Planning Exceptions from the Planners Workbench.
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&a2m_dblink, msc_apps_instances&a2m_dblink, msc_plans&a2m_dblink, msc_exception_details_v&a2m_dblink, msc_system_items&a2m_dblink, msc_demands&a2m_dblink
Report Categories
Related Reports
MSC Pegging Hierarchy 11i, MSC Pegging Hierarchy, MSC Plan Orders, MSC Vertical Plan, MSC Horizontal Plan, MSC Plan Order Upload, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC ICP PII Inventory Pending Cost Adjustment, CAC ICP PII Inventory and Intransit Value (Period-End)
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | MSC Exceptions - Dashboard 17-Jan-2023 234651.xlsm |
| Blitz Report™ XML Import | MSC_Exceptions.xml |
| Full SQL 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
© 2026 Enginatics