MRP Sourcing Rules and Bills of Distribution – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Sourcing rules for all or a selected assignment set, along with with the item’s make / buy flag and based on rollup flag for costing. You can either choose Organization or Vendor (Supplier) sourcing rules or get all sourcing rules by not selecting a sourcing rule type.
Report Parameters
Assignment Set, Assignment Type, Assignment Organization, Assignment Customer, Assignment Item Number, Assignment Category, Sourcing Rule Type, Sourcing Rule Name, Global Sourcing Rules, Sourcing Rule Organization, Receipt Organization, Active Receipt Orgs Only, Source Type, Source Organization, Source Supplier, Source Supplier Site, Category Set 1, Category Set 2
Oracle EBS Tables Used
mrp_sourcing_rules, mtl_parameters, mrp_sr_receipt_org_v, mrp_sr_source_org_v, org_access_view, mrp_sr_assignments_v, mtl_system_items_b, mrp_assignment_sets, mtl_system_items_vl, mtl_units_of_measure_vl, mtl_item_status_vl, cst_item_costs, mtl_categories_kfv
Report Categories
Related Reports
CAC Last Standard Item Cost, CAC New Items, CAC Calculate ICP PII Item Costs, CAC Item vs. Component Include in Rollup Controls, CAC New Standard Item Costs, CAC User-Defined and Rolled Up Costs, CAC Cost vs. Planning Item Controls, CAC Intercompany SO Price List vs. Item Cost Comparison, CAC Calculate ICP PII Item Costs by Where Used
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 | MRP Sourcing Rules and Bills of Distribution 10-Jun-2024 034927.xlsx |
| Blitz Report™ XML Import | MRP_Sourcing_Rules_and_Bills_of_Distribution.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/mrp-sourcing-rules-and-bills-of-distribution/ |
MRP Sourcing Rules and Bills of Distribution - Case Study & Technical Analysis
Executive Summary
The MRP Sourcing Rules and Bills of Distribution report provides a comprehensive listing of the defined sourcing logic. It documents the supply chain network, showing how items are sourced (Make, Buy, Transfer) and from where.
Business Challenge
Understanding the supply chain network requires visibility into the sourcing rules.
- Network Visualization: “What is our current strategy for sourcing ‘Electronics’? Are we single-sourced or dual-sourced?”
- Audit: “Show me all rules where we are sourcing from ‘Supplier X’ so we can assess the impact of their bankruptcy.”
- Validation: “Do we have any rules where the allocation percentages don’t add up to 100%?”
Solution
The MRP Sourcing Rules and Bills of Distribution report lists the rules and their details.
Key Features:
- Rule Details: Shows the name, description, and type (Sourcing Rule vs. Bill of Distribution).
- Source Logic: Lists the sources (Supplier, Org), Ranks, and Allocation Percentages.
- Assignments (Optional): Can optionally show which items or categories are assigned to these rules.
Technical Architecture
The report queries the sourcing rule definition tables.
Key Tables and Views
MRP_SOURCING_RULES: The rule header.MRP_SR_SOURCE_ORG_V: The details of the sources (Suppliers/Orgs).MRP_SR_RECEIPT_ORG_V: The receiving organizations.MRP_ASSIGNMENT_SETS: (If joined) shows where the rules are used.
Core Logic
- Retrieval: Selects rules based on parameters (Name, Organization).
- Expansion: Joins to the source details to show the specific suppliers or transfer origins.
- Formatting: Presents the data in a hierarchical or flat format for analysis.
Business Impact
- Supply Chain Visibility: Provides a clear map of the physical flow of goods through the supply chain.
- Risk Management: Helps identify single points of failure (single-sourced items).
- Compliance: Ensures that sourcing strategies are being implemented as designed in the system.
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