INV Physical Inventory Purge Upload purges Oracle EBS physical inventories from Excel. Download the physical inventories that match your selection, choose per physical inventory whether to purge only its tags or the entire physical inventory, and upload: for each row the upload submits Oracle’s standard Purge physical inventory information program, which performs the purge.
When to use it
- Purge many physical inventories at once instead of submitting the purge program one by one.
- Clean up old physical inventories, using the date range or the “older than months” filter to find them.
- Remove only the tags of a physical inventory and keep its header, or purge the entire physical inventory.
- Review the list of candidates in Excel before deciding which ones to purge.
Before you start
- Use an Inventory responsibility with access to the organizations of the physical inventories. The download only lists physical inventories of organizations your responsibility can access.
- A purge cannot be undone. Make sure the physical inventories you select are no longer needed.
Step 1 – Set the parameters
Open INV Physical Inventory Purge Upload in Blitz Report and set the parameters:
| Parameter | Meaning |
|---|---|
| Upload Mode | Create, Update (default) downloads the matching physical inventories for review; Create opens an empty sheet into which you enter or paste the physical inventories to purge. |
| Default Purge Option | Full physical inventory purge or Purge physical inventory tags only. Fills the Purge Option of every downloaded row and marks every row for upload, so all downloaded physical inventories are purged unless you change them. Leave it empty to download the list without selecting anything. |
| Organization Code | The inventory organization. |
| Physical Inventory | A specific physical inventory. |
| Physical Inventory Like | Physical inventories whose name starts with this text (not case sensitive). |
| Physical Inventory Date From / To | Restricts the download to a range of physical inventory dates. |
| Phys. Inv. Date Older Than (Mths) | Physical inventories dated more than this number of months before today. |
| Snapshot Complete | Yes (default) lists only frozen physical inventories, No only those not yet frozen; leave it empty for both. |
The downloaded file must include the Purge Option column. The R12.1 Default Template does not include it, so clear the template field before you click Run.
Step 2 – Run to download the Excel file
Click Run. The Excel file downloads and opens with one row per physical inventory, showing its organization, name, description, physical inventory date and whether its snapshot is complete. With Upload Mode Create the sheet is empty.
Step 3 – Choose what to purge
Each row is one physical inventory. Set its Purge Option: Full physical inventory purge removes the entire physical inventory, Purge physical inventory tags only removes its tags and keeps the physical inventory. Setting or changing the Purge Option marks the row for upload. To keep a physical inventory, clear the Action of its row; rows without an Action are not uploaded. In an empty sheet, enter the Organization Code, Physical Inventory Name and Purge Option. The other columns are for information only.
Step 4 – Validate and Save
Click Validate and Save. This checks for missing required values and saves the file. Correct any rows it flags before uploading.
Step 5 – Upload the file
In Blitz Report click Upload and select the saved file. This submits the upload request, which checks each row and submits one Purge physical inventory information request per physical inventory. The upload does not wait for the purge requests to finish.
Step 6 – Review the result report
When the request completes, a result report opens listing every uploaded row with its status and message. The message of a successful row gives the request id of the submitted purge request; check that request in View Requests to confirm the purge completed.
What’s produced
- One Purge physical inventory information request per uploaded physical inventory, purging either its tags or the entire physical inventory.
- A result report listing every row with a status (success or error) and a message with the submitted request id.
Common questions
Does the upload delete the data itself?
No. It submits Oracle’s standard Purge physical inventory information program for each row, and that program performs the purge.
When a row shows Success, is the purge finished?
Not necessarily. Success means the purge request was submitted. Check the request id from the message to confirm it completed normally.
How do I purge many physical inventories with the same option?
Set the Default Purge Option parameter. Every downloaded row then carries that option and is marked for upload; clear the Action of any row you want to keep.
Can I purge physical inventories of several organizations in one upload?
Yes. Each row has its own Organization Code; leave the Organization Code parameter empty to download all organizations your responsibility can access.
Why is a physical inventory missing from the download?
The Snapshot Complete parameter defaults to Yes, which lists only frozen physical inventories. Set it to No or clear it, and check the date and name filters and your responsibility’s organization access.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Physical Inventory does not exist | No physical inventory with this name exists in the organization. | Correct the Organization Code or Physical Inventory Name, or download the physical inventories to pick from. |
| Invalid Purge Option | The Purge Option is empty, for example because the file was downloaded with a template that does not include the Purge Option column. | Clear the template field, download again and set the Purge Option of each row. |
| Purge physical inventory information request not submitted due to “…” | Oracle could not submit the purge program; the reason is quoted. | Check that your responsibility can run the Purge physical inventory information program, then upload the row again. |