MRP Sourcing Rule Assignment Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
MRP Sourcing Rule Assignment Upload =============================
- Upload new Assignment Sets and Sourcing Rule Assignments
- Update Existing Assignment Sets and Sourcing Rule Assignments
Notes: If an Assignment Organization is specified, then this determines the selecatable items. If an Assignment Organization is not specified, then the Master Organization determines the selectable Items. The selectable Assignment Organizations is not restricted by the Master Organization. This is the same logic as used in the Sourcing Assignments form
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
Master Organization Code, Upload Mode, Assignment Set, Assignment Type, Sourcing Rule Type, Sourcing Rule Name, Organization Code, Category, Item, Customer, Customer Number, Customer Operating Unit
Oracle EBS Tables Used
mrp_assignment_sets, mrp_sr_assignments_v, mrp_sourcing_rules, mtl_parameters, mtl_system_items_vl, hz_cust_accounts, hz_cust_site_uses_all, hr_all_organization_units_vl, mtl_system_items_b
Report Categories
Related Reports
CAC Intercompany SO Price List vs. Item Cost Comparison, CAC New Items, MRP Sourcing Rules and Bills of Distribution, CAC Last Standard Item Cost, 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_Assignment_Upload.xml |
| SQL Source | MRP Sourcing Rule Assignment Upload.sql |
| Full Report on Enginatics | www.enginatics.com/reports/mrp-sourcing-rule-assignment-upload/ |
MRP Sourcing Rule Assignment Upload - Case Study & Technical Analysis
Executive Summary
The MRP Sourcing Rule Assignment Upload is a configuration tool used to mass-maintain the “Assignment Sets” that determine how the planning engine sources material. It allows users to assign Sourcing Rules to Items, Categories, or Organizations in bulk.
Business Challenge
Sourcing rules control the supply chain network (e.g., “Buy Item X from Supplier Y” or “Transfer Item Z from Warehouse A to Warehouse B”).
- Network Redesign: “We are closing a warehouse and need to repoint 10,000 items to source from a new distribution center.”
- New Product Introduction: “We just launched a new product line (Category ‘NEW_TECH’) and need to assign the standard sourcing rule to all 50 items in that category.”
- Maintenance: “We need to switch the sourcing for all ‘Steel’ items from ‘Global’ to ‘Local’ rules.”
Solution
The MRP Sourcing Rule Assignment Upload automates the assignment process.
Key Features:
- Hierarchy Support: Supports assignments at all levels: Item-Org, Item, Category-Org, Category, Organization, and Global.
- Bulk Processing: Can upload thousands of assignments in a single run.
- Validation: Ensures that the Sourcing Rules and Items exist before creating the assignment.
Technical Architecture
The tool interfaces with the Sourcing Rule Assignment tables.
Key Tables and Views
MRP_ASSIGNMENT_SETS: Defines the set of assignments (e.g., “Supplier Scheduling Set”).MRP_SR_ASSIGNMENTS: The table linking the Sourcing Rule to the assignment level (Item, Category, etc.).MRP_SOURCING_RULES: The definition of the rule itself.
Core Logic
- Parameter Check: Validates the Assignment Set name.
- Level Determination: Determines the assignment level (e.g., Item vs. Category) based on the provided columns.
- Execution: Inserts or updates records in
MRP_SR_ASSIGNMENTS.
Business Impact
- Strategic Agility: Allows companies to rapidly reconfigure their supply chain network in response to business changes.
- Accuracy: Ensures consistent sourcing logic across large groups of items.
- Time Savings: Eliminates days of manual clicking in the Sourcing Rule Assignment form.
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