MRP Sourcing Rule Upload  Help

MRP Sourcing Rule Upload creates, updates and deletes Oracle MRP/ASCP sourcing rules and bills of distribution – including their receiving organizations and shipping sources (Make At / Transfer From / Buy From) with rank and allocation percentages – in bulk from Excel, via the standard Oracle public API.

When to use it

• Mass-create new sourcing rules or bills of distribution for many items and organizations.
• Model multi-source supply chains with rank and allocation-percentage splits across suppliers or source organizations.
• Roll out Transfer From / Make At / Buy From sourcing across organizations from one spreadsheet.
• Bulk-update effective dates, allocation percentages, ranks, ship methods or intransit times.
• Add or remove a shipping source on existing rules, or delete obsolete rules.

Before you start

• Blitz Report is installed and you are signed in to a responsibility with access to the organizations involved.
• Inventory organizations, interorg shipping networks (ship methods, intransit times) and suppliers/sites are already set up.
• This is an MRP/ASCP planning feature.

Step 1 – Choose a mode, set the parameters and download

In Blitz Report, open MRP Sourcing Rule Upload, choose an Upload Mode, and set the parameters:

Run the upload to download and open the Excel file. Each rule and source is automatically handled as a create or an update depending on whether it already exists.

Step 2 – Enter the rules and sources

Each row carries one shipping source; the rule header and receiving-org values repeat across the rows of the same rule. Enter the Rule Name, Rule Type and All Orgs (Yes for a global rule), the Receipt Organization and Effective Date From/To, then the source: Source Type (Make At / Transfer From / Buy From), the Source Organization or Supplier/Supplier Site, the Allocation Percent and Rank, and any Ship Method/Intransit Time.

Step 3 – Delete rules or sources (optional)

Set the Delete Option column to “Sourcing Rule” to delete the whole rule, or “Shipping Org” to remove that one source entry. The targeted entity must already exist.

Step 4 – Validate and Save

Click Validate and Save. This checks for missing required values and runs the upload’s validation, then saves the file. Correct anything it flags before continuing.

Step 5 – Upload and view the result

Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which creates, updates or deletes each rule and source. When it finishes, a result report opens showing each row as success or error.

What’s produced

• Created, updated or deleted sourcing rules / bills of distribution with their receiving orgs and shipping sources.
• A result report listing every row with a status (success or error) and a message.

Common questions

How do I split demand 60/40 across two suppliers?
Enter two source rows for the same rule and receiving org with the same Source Type, setting Allocation Percent to 60 and 40 (or split by Rank for primary/secondary).

Why is Receipt Organization blank or greyed for my rule?
For global rules (All Orgs = Yes) and for bills of distribution the receipt organization must be blank – these are organization-independent.

Can I change a rule’s Type or Organization later?
No – those cannot be changed on an existing rule; create a new rule instead.

Can I delete just a receiving-organization line?
No – only the whole sourcing rule or an individual shipping-org source can be deleted.

My update failed asking me to use Create, Update mode.
Create mode only accepts brand-new rules; choose Create, Update to mix new and existing rows.

Troubleshooting