MRP Item Forecast Upload creates, updates and deletes individual time-phased item forecast entries inside an existing Oracle MRP/ASCP forecast (forecast designator), from Excel, loaded through Oracle’s standard MRP forecast interface.
When to use it
- Mass-load a new item forecast into an existing forecast from a spreadsheet.
- Bulk-update quantities, dates, bucket types or comments on existing forecast entries.
- Delete specific forecast entries (set the quantity to 0) without opening the forecast form per line.
- Completely replace a forecast’s contents in one pass.
- Copy entries from one forecast to another.
- Maintain project/task- or production-line-specific forecast demand in bulk.
Before you start
- Blitz Report is installed and you are signed in to a responsibility with inventory-organization access.
- The target forecast (forecast designator) already exists – item forecasts load to a forecast, never directly to a forecast set.
- Items exist in the organization and are forecastable.
Choose a template
| Template | Use it for |
|---|---|
| Default (default) | The standard template showing all columns, including the read-only Original Quantity. |
| Create | An empty sheet to enter brand-new entries (pre-sets Upload Mode to Create). |
| Create and Update | Download existing entries and/or add new ones (pre-sets Upload Mode to Create, Update). |
| Update | Download existing entries and add/update/delete them within the downloaded forecasts (pre-sets Upload Mode to Update). |
Step 1 – Choose a template, set the parameters and download
In Blitz Report, open MRP Item Forecast Upload, choose your template, and set the parameters:
| Parameter | Purpose |
|---|---|
| Upload Mode | Create, Update, or Create, Update. Default is Create. |
| Delete Existing Forecast | In Create mode, choose to DELETE all existing entries and replace, or KEEP and update. |
| Default Bucket Type / Default Workday Control | Defaults for entries that don’t specify their own; overridable per row. |
| Organization Code / Forecast Set / Forecast Name / Planner / Item / Project / Forecast Date From / To | Restrict which existing entries are downloaded. |
Run the upload to download and open the Excel file. Each entry is automatically handled as a create or an update; a quantity of 0 deletes the entry.
Step 2 – Enter the forecast entries
On each row enter the Organization Code, Forecast, Item, Forecast Date and Quantity. Optionally set the Forecast End Date, Bucket Type, Workday Control, Comments, Project/Task and WIP Line Code.
Step 3 – Delete entries (optional)
To remove a forecast entry, set its Quantity to 0. The result report shows “Forecast Entry Deleted” for those rows. To wipe and reload a whole forecast, use Create mode with Delete Existing Forecast set to “DELETE all existing forecast entries and replace”.
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 loads the entries through the MRP forecast interface. When it finishes, a result report opens showing each row as success or error.
What’s produced
- Created, updated or deleted forecast entries inside the chosen forecast.
- A result report listing every row with a status (success or error) and a message.
Common questions
How do I delete a forecast entry?
Set its Quantity to 0 and upload; the result shows “Forecast Entry Deleted”.
Can I wipe a whole forecast and reload it?
Yes – run in Create mode with Delete Existing Forecast set to “DELETE all existing forecast entries and replace”. This option is only available in Create mode.
Can I create a forecast (designator) with this upload?
No – the forecast must already exist; this upload only manages the entries within it. Item forecasts also cannot go to a forecast set.
What does Bucket Type default to?
From the selected forecast, else the forecast set, else Days; you can override it per row.
What if my date falls on a non-workday?
The Workday Control value (reject, shift backward, or shift forward) decides; set a default and override per row.
Why can’t I add entries to a forecast I didn’t download?
That’s Update mode (downloaded forecasts only). Use Create or Create, Update to add entries to any accessible forecast.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Invalid Forecast Name | The forecast designator doesn’t exist in that organization. | Use an existing forecast for the chosen organization. |
| Invalid Item | The item is not in the organization, or not forecastable. | Pick an item from the dropdown for that organization. |
| Invalid Bucket Type / Invalid Workday Control | The value is not a valid choice. | Use the dropdown values, or clear the cell to take the run-time default. |
| A Forecast Set and/or Forecast Name must be entered in Update Mode | Update mode was run without naming a forecast or set. | Enter a Forecast Set and/or Forecast Name and re-run. |
| Row errors after processing | The MRP forecast interface rejected the entry. | Read the message in the result and correct the field, then re-upload. |