INV Physical Inventory Purge Upload  Help

INV Physical Inventory Purge Upload submits Oracle’s standard purge program for the physical inventories you select – purging either the tags only or the entire physical inventory – from Excel. The actual deletion is done by the Oracle program; the upload validates each row and submits the request.

When to use it

• Purge many physical inventories at once instead of running the purge program one by one.
• Clean up old physical inventories – use the date or “older than months” filters to find candidates.
• Purge only the tags of a physical inventory, or the entire physical inventory.
• Review the list of physical inventories before deciding which to purge.

Before you start

• Blitz Report is installed and you are signed in to an Inventory responsibility with access to the organization and the right to run the purge program.
• The physical inventories you want to purge already exist.

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

In Blitz Report, open INV Physical Inventory Purge Upload, choose an Upload Mode (Create, Update downloads existing physical inventories to pick from; Create gives an empty template), and set the parameters:

Run the upload to download and open the Excel file.

Step 2 – Choose what to purge

Each row is one physical inventory. Set its Purge Option – purge the tags only, or the entire physical inventory. In an empty (Create) template, fill the Organization Code, Physical Inventory Name and Purge Option.

Step 3 – Validate and Save

Click Validate and Save. This checks that each physical inventory exists and that a valid purge option is set, 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 submits Oracle’s purge program for each physical inventory. A successful row means the purge request was submitted – check the submitted concurrent request to confirm the purge completed. When it finishes, a result report opens showing each row as success or error.

What’s produced

• A submitted purge request for each selected physical inventory.
• A result report listing every row with a status and a message, including the submitted request id.

Common questions

Does the upload itself delete the data?
No. It submits Oracle’s standard purge program, which performs the purge. The upload validates and submits one request per row.

When a row shows success, is the purge finished?
No. Success means the purge request was submitted. Check the submitted concurrent request to confirm the purge actually completed.

What’s the difference between the two purge options?
One purges only the tags of the physical inventory; the other purges the entire physical inventory. Choose per row in the Purge Option column.

How do I purge several physical inventories with the same option?
Set the Default Purge Option parameter – it pre-fills the Purge Option column on every row.

Can I purge across multiple organizations in one upload?
Yes – each row carries its own Organization Code.

Troubleshooting