MSC Plan Order Upload actions Oracle ASCP (Advanced Supply Chain Planning) plan-order recommendations from Excel – selecting them for release or releasing them, and optionally amending the implement date and implement quantity. It only updates existing recommendations; it never creates or deletes plan data.
When to use it
- Release ASCP planned-order recommendations in bulk instead of one by one in the Planner Workbench.
- Mass “select for release” many planned orders for later execution.
- Apply Reschedule In / Reschedule Out recommendations on existing supply orders.
- Override the suggested implement date and/or quantity before releasing.
- Attach comments to planned orders while actioning them.
Before you start
- Blitz Report is installed and you are signed in with access to the planning organizations.
- An ASCP plan exists and is populated on a reachable planning instance.
- Your user is defined on the planning instance with a responsibility that allows releasing planned orders there.
- The recommendations are actionable (Reschedule In/Out or Release) and not already implemented.
Choose a template
| Template | Use it for |
|---|---|
| Plan Order Recommendations (default) | Download the recommendations, then tick the rows you want to action. |
| Plan Order Recommendations – Automatic Release | Every downloaded recommendation arrives pre-flagged for automatic release (pre-sets Auto Populate Release Status = Yes and Upload Mode = Release the Order), so it can be saved and uploaded without hand-picking rows. Check its Planning Instance default before downloading. |
Step 1 – Choose a template, set the parameters and download
In Blitz Report, open MSC Plan Order Upload, choose your template, and set the parameters:
| Parameter | Purpose |
|---|---|
| Upload Mode | Select for Release (default) or Release the Order. |
| Auto Populate Release Status | Yes pre-fills the action column on every downloaded recommendation. |
| Planning Instance | The ASCP source instance (required). |
| Plan | The plan whose recommendations are downloaded (required). |
| Organization / Item / Category / Order Type / Action / dates and other filters | Restrict which recommendations are downloaded. |
Run the upload to download and open the Excel file. Most columns are read-only and carry the recommendation details for identification.
Step 2 – Action the recommendations
For each row you want to action, set the Update Release Status (Select for Release or Release the Order). Optionally amend the Implement Date and Implement Quantity. For a plan order not yet selected for release, you must set Update Release Status and supply both Implement Date and Implement Quantity; for an order already selected, you can amend the date/quantity directly.
Step 3 – 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 4 – Upload and view the result
Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which selects and/or releases each actioned recommendation. When it finishes, a result report opens showing each row as success or error; released rows carry the release request id.
What’s produced
- Plan orders selected for release and/or released, with any amended implement date/quantity.
- A result report listing every row with a status (success or error) and a message.
Common questions
Does this create new planned orders?
No. It only actions recommendations that already exist in the plan; non-update rows are rejected.
What’s the difference between “Select for Release” and “Release the Order”?
Select for Release marks the order as selected and applies your implement date/quantity but does not execute it; Release the Order does that and then runs the release process (returning a request id).
I only want to change the Implement Date/Quantity – what do I enter?
If the order is already selected for release, just change the date/quantity. If it is not yet selected, also set Update Release Status, and supply both Implement Date and Implement Quantity.
Why is most of the sheet read-only?
Only Update Release Status, Implement Date and Implement Quantity are editable; everything else is downloaded for identification and reference.
How do I release everything without ticking rows?
Use the Automatic Release template, or set Auto Populate Release Status = Yes.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| User is not defined / does not have access to release planned orders in the ASCP instance | The EBS user has no planning-instance user or no release privilege there. | Have the planning admin set up the user / grant a responsibility with release access on the ASCP instance. |
| Both Implement Date and Implement Quantity must be specified to select or release a Plan Order | Selecting/releasing a not-yet-selected order without both values. | Fill in both Implement Date and Implement Quantity. |
| Update Release Status must be specified to update the Implement Date/Quantity | Changed implement date/quantity on a not-yet-selected order without choosing an action. | Set Update Release Status to Select for Release or Release the Order. |
| Implement Date cannot be in the past / Release Quantity must be >= 0 | Invalid implement date or negative quantity. | Use today or a future date; enter a non-negative quantity. |
| Plan Order has already been implemented / the recommendation has changed | The plan was re-run or the order actioned since download, so the row is stale. | Re-download a fresh template and re-apply your changes. |