ONT Order Upload  Help

ONT Order Upload creates new sales orders, updates existing orders, adds lines, books orders and cancels orders in Oracle Order Management from Excel – via the standard Oracle public API. Each spreadsheet row is one order line, grouped under a shared order identifier.

When to use it

• Mass-create new sales orders from a spreadsheet (one or many lines per order).
• Add lines to existing orders in bulk.
• Bulk-update header or line fields (dates, prices, addresses, shipping, salesrep, flexfields) on existing orders.
• Book many entered orders at once.
• Cancel orders (and all their lines) in bulk, with a recorded change reason.
• Apply line-level discounts or price overrides with a proper price-adjustment audit trail.

Before you start

• Blitz Report is installed and you are signed in to a responsibility with access to the operating unit.
• The customer (and its account) exists, is active, and has ship-to/bill-to sites in the operating unit.
• The item exists and is orderable; a valid order type and line type exist for the operating unit.

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

In Blitz Report, open ONT Order Upload, choose an Upload Mode (Create, Update – the default – downloads existing orders to edit; Create gives an empty template), and set the parameters:

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

Step 2 – Enter the orders

Each row is one order line; the Upload Order Identifier groups a single order’s lines. For a new order leave Order Number blank and put a unique reference (e.g. new1) in the identifier; repeat it on every line. On the header enter the Operating Unit, Customer, Order Type, Header Ship To and Header Bill To; on each line the Item, Ordered Quantity, UOM and Line Request Date.

Step 3 – Book or cancel (optional)

Set Order Action to Book to submit the order for booking, or to Cancel to cancel the order and all its lines (a Header Change Reason is required to cancel).

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

What’s produced

• Created and updated sales orders with their lines; orders booked or cancelled as requested.
• A result report listing every row with a status (success or error) and a message.

Common questions

How do I create a brand-new order?
Leave Order Number blank and put a unique reference (e.g. new1) in Upload Order Identifier; repeat that identifier on every line of the order.

How do I put several lines on one order?
Give all those rows the same Upload Order Identifier; the header columns are read from the first row.

How do I book an order?
Set Order Action to Book (you can pre-set it for the whole download via the Order Action parameter).

How do I cancel an order?
Set Order Action to Cancel and supply a Header Change Reason – this cancels the order and all its lines. There is no separate delete.

Why must I enter a Discount Modifier when I change the selling price?
A manual price override must be backed by a price adjustment so it’s auditable; the upload enforces this exactly as the Order Management form does.

Troubleshooting