MRP Sourcing Rule Assignment Upload  Help

MRP Sourcing Rule Assignment Upload creates, updates and deletes Oracle MRP/ASCP assignment sets and the sourcing rule assignments within them – tying sourcing rules or bills of distribution to targets at any of the six assignment levels (Global, Category, Item, Organization, Category-Organization, Item-Organization) – from Excel, via the standard Oracle public API.

When to use it

• Mass-create a new assignment set and load many sourcing-rule assignments into it.
• Bulk-assign sourcing rules or bills of distribution to items, categories, organizations, or customers/sites.
• Re-point many assignments to a different sourcing rule in one pass.
• Bulk-remove obsolete assignments, or delete an entire assignment set.
• Maintain assignment-set or assignment descriptive flexfield attributes in bulk.
• Migrate or copy an assignment set’s contents between environments.

Before you start

• Blitz Report is installed and you are signed in to a responsibility with the relevant organization access.
• The sourcing rules / bills of distribution being assigned already exist, are planning-active, and have a currently-effective receipt organization.
• For Category-level assignments, the MRP sourcing-rule category-set profile must be configured.

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

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

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

Step 2 – Enter the assignments

On each row enter the Assignment Set, the Assignment Type (the level), the target for that level (Item, Category, Organization or Customer/site), and the Sourcing Rule Type and Sourcing Rule Name to assign. The required target columns depend on the assignment type.

Step 3 – Delete assignments or sets (optional)

Set the Delete Option column to “Assignment” to delete one assignment, or “Assignment Set” to delete the whole set. Deletion requires Create, Update mode.

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 set and assignment. When it finishes, a result report opens showing each row as success or error.

What’s produced

• Created, updated or deleted assignment sets and sourcing rule assignments.
• A result report listing every row with a status (success or error) and a message.

Common questions

What do the six assignment types mean?
They define the scope a sourcing rule applies to – Global (everything), Category, Item, Organization, Category-Organization, or Item-Organization. The required target columns change accordingly.

Can I assign a bill of distribution at organization level?
No – bills of distribution are only valid for Global, Category and Item assignment types; organization-scoped types accept only sourcing rules.

Why can’t I pick Category as an assignment type?
Category and Category-Organization only appear when the MRP sourcing-rule category-set profile is configured.

How does it know whether to create or update?
It looks the set and assignment up by their keys – found = update, not found = create. The Upload Mode governs whether updates/deletes are allowed.

How do I delete an assignment or a whole set?
Set the Delete Option column to “Assignment” or “Assignment Set” and run in Create, Update mode.

Troubleshooting