MSC Sourcing Rule Assignment Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
MSC 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
Planning Instance, 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, Region/Zone, Condition, Include Collected Data
Oracle EBS Tables Used
msc_assignment_sets, msc_sr_assignments_v, msc_sourcing_rules, msc_trading_partners, msc_trading_partner_sites, msc_regions
Report Categories
Related Reports
MSC Plan Orders, MSC Vertical Plan, MSC Horizontal Plan, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, MSC Exceptions, MSC Pegging Hierarchy, MSC Plan Order Upload, CAC Inventory Lot and Locator OPM Value (Period-End)
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 | MSC_Sourcing_Rule_Assignment_Upload.xml |
| SQL Source | MSC Sourcing Rule Assignment Upload.sql |
| Full Report on Enginatics | www.enginatics.com/reports/msc-sourcing-rule-assignment-upload/ |
MSC Sourcing Rule Assignment Upload - Case Study & Technical Analysis
Executive Summary
The MSC Sourcing Rule Assignment Upload is a configuration tool for the ASCP environment. Similar to the MRP version, it allows for the mass maintenance of Sourcing Rule Assignments. However, this tool is specifically designed for the MSC (ASCP) schema, which is often separate from the transactional (MRP/ERP) schema.
Business Challenge
In distributed environments, sourcing rules might need to be maintained directly in the planning instance or synchronized from the source.
- Simulation: “We want to test a new sourcing strategy in a simulation plan without changing the production system. We need to upload these assignments to the planning instance only.”
- Volume: “We have 50,000 assignments to update. The forms are too slow.”
Solution
The MSC Sourcing Rule Assignment Upload allows bulk updates to the ASCP assignment sets.
Key Features:
- Direct ASCP Update: Updates the tables in the planning schema (
MSC_). - Hierarchy Support: Supports Item, Category, Organization, and Global levels.
- Validation: Ensures referential integrity with ASCP master data.
Technical Architecture
The tool interfaces with the MSC assignment tables.
Key Tables and Views
MSC_ASSIGNMENT_SETS: Defines the assignment set.MSC_SR_ASSIGNMENTS: The table linking rules to items/orgs.MSC_SOURCING_RULES: The rule definitions.
Core Logic
- Context: Operates within the context of a specific Planning Instance.
- Processing: Inserts or updates records in
MSC_SR_ASSIGNMENTS. - Collection Flag: Can optionally include collected data or only local (simulation) data.
Business Impact
- Simulation Capability: Enables powerful “what-if” analysis by allowing planners to rapidly change sourcing logic in a test plan.
- Efficiency: Drastically reduces the time required to set up or modify large supply chain networks.
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