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™. Oracle EBS module: Master Scheduling/MRP · all Master Scheduling/MRP reports
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.
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
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, xxen_report_org_access, 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 Intercompany SO Price List vs. Item Cost Comparison, INV Items, INV Item Upload, CAC Last Standard Item Cost, CAC New Standard Item Costs, CAC Calculate ICP PII Item Costs by Where Used, INV Item Upload 11i, CAC Cost vs. Planning Item Controls, CAC Calculate ICP PII Item Costs
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 Sourcing Rules and Bills of Distribution 10-Jun-2024 034927.xlsx |
| Blitz Report™ XML Import | MRP_Sourcing_Rules_and_Bills_of_Distribution.xml |
| SQL Source | MRP Sourcing Rules and Bills of Distribution.sql |
| Full Report 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
© Enginatics GmbH