MRP Sourcing Rule Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
MRP Sourcing Rule Upload ====================
- Upload new Sourcing Rules
- Update Existing Sourcing Rules
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
Upload Mode, Sourcing Rule Type, Include Global Sourcing Rules, Sourcing Rule Organization, Sourcing Rule Name, Sourcing Rule Name Like
Oracle EBS Tables Used
mrp_sourcing_rules, mtl_parameters, mrp_sr_receipt_org_v, mrp_sr_source_org_v, ap_suppliers, ap_supplier_sites_all, hr_all_organization_units_vl, org_access_view
Report Categories
Related Reports
CAC Inventory Organization Summary, CAC Intercompany SO Price List vs. Item Cost Comparison, MRP Sourcing Rules and Bills of Distribution, CAC Last Standard Item Cost, 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
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 | MRP_Sourcing_Rule_Upload.xml |
| SQL Source | MRP Sourcing Rule Upload.sql |
| Full Report on Enginatics | www.enginatics.com/reports/mrp-sourcing-rule-upload/ |
MRP Sourcing Rule Upload - Case Study & Technical Analysis
Executive Summary
The MRP Sourcing Rule Upload is a tool for creating and maintaining the Sourcing Rules themselves (the “How” and “Where”). While the Assignment Upload determines which items use a rule, this tool defines what the rule actually does (e.g., “Buy from Supplier A with 60% allocation and Supplier B with 40%”).
Business Challenge
Defining complex sourcing logic manually is slow.
- Multi-Sourcing: “We want to split our volume for this commodity: 50% to Vendor A, 30% to Vendor B, and 20% to Vendor C.”
- Inter-Org Transfers: “We need to define transfer rules for 50 different distribution centers.”
- Updates: “Vendor A is changing their name/site. We need to update 200 sourcing rules to reflect the new site.”
Solution
The MRP Sourcing Rule Upload allows bulk definition of these rules.
Key Features:
- Rule Definition: Create new rules or update existing ones.
- Source Types: Supports “Buy From” (Supplier), “Transfer From” (Org), and “Make At” (Org).
- Allocations: Allows defining split percentages and rankings (Rank 1 vs. Rank 2).
Technical Architecture
The tool interfaces with the Sourcing Rule definition tables.
Key Tables and Views
MRP_SOURCING_RULES: The header table for the rule.MRP_SR_RECEIPT_ORG: Defines the receiving organization (for local rules).MRP_SR_SOURCE_ORG: Defines the source (Supplier, Org) and allocation %.
Core Logic
- Header Creation: Creates the rule header in
MRP_SOURCING_RULES. - Detail Creation: Creates the source details (Supplier/Org, Allocation %, Rank) in
MRP_SR_SOURCE_ORG. - Validation: Checks that allocations sum to 100% (if required) and that suppliers/orgs are valid.
Business Impact
- Procurement Strategy: Enables the rapid implementation of strategic sourcing decisions (e.g., dual-sourcing initiatives).
- Network Optimization: Facilitates the setup of complex distribution networks (Hub-and-Spoke).
- Data Integrity: Ensures that sourcing rules are defined consistently and accurately.
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