INV Physical Inventory Tag Count Upload enters counted quantities against the tags of an Oracle Inventory physical inventory, from Excel – updating counts on existing tags, generating new tags where allowed, and voiding tags on supported releases. It records counts; it does not post the inventory adjustments.
When to use it
- Enter physical count results in bulk from count sheets instead of keying each tag in the form.
- Update counted quantities against many existing tags at once.
- Add new count tags for combinations not pre-tagged, where dynamic tag entry is allowed.
- Record dual-unit-of-measure counts, or counts for lot- and serial-controlled items.
- Void tags that should be excluded from adjustment (on supported releases).
Before you start
- Blitz Report is installed and you are signed in to an Inventory responsibility with access to the organization.
- The physical inventory exists, its snapshot has been taken, and its adjustments are not yet posted.
- Tags have been generated, unless dynamic tag entry is enabled.
Step 1 – Choose a mode, set the parameters and download
In Blitz Report, open INV Physical Inventory Tag Count Upload, choose an Upload Mode, and set the parameters:
| Parameter | Purpose |
|---|---|
| Upload Mode | Update existing tags (default), Create new tags, or both. |
| Organization Code | The inventory organization. |
| Physical Inventory | The physical inventory whose tags are downloaded. |
| Counted By | The default employee recorded as having counted. |
| Subinventory / Item / Tag Number filters | Restrict which tags are downloaded. |
Run the upload to download and open the Excel file. Each row is automatically handled as an update to an existing tag or a new tag.
Step 2 – Enter the counts
On each tag row enter the UOM and counted Quantity (and the Secondary UOM and Secondary Quantity for dual-unit items). For a new tag, enter the Item, Subinventory, Locator and any Lot Number or Serial Number – leave the Tag Number blank to have it generated. On an existing tag you can change only the count, not the item or location.
Step 3 – Void tags (optional)
On supported releases, set Void to Yes on an existing tag to exclude it from adjustment.
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 records the counts against the tags. When it finishes, a result report opens showing each row as success or error.
What’s produced
- Counted quantities recorded against the physical inventory’s tags, and any new tags created.
- A result report listing every row with a status (success or error) and a message.
Common questions
Does this post the inventory adjustments?
No. It only records counts and tags. Approving and posting adjustments is done separately after counting.
How do I create a new tag?
Use an Upload Mode that allows creation, enter the item, subinventory, locator and so on, and leave the Tag Number blank to have it generated. Dynamic tag entry must be allowed and tag numbers must already have been generated.
Can I change which item or location an existing tag points to?
No. On an existing tag only the count, units of measure and void flag can change.
Who is recorded as having counted the tag?
The Counted By employee, defaulting to your own employee record.
Why can’t I see a particular physical inventory?
Only physical inventories in the organization whose adjustments are not yet posted are listed.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| New Tags cannot be created in Update Mode / Existing Tags cannot be updated in Create Mode | The row’s action conflicts with the chosen Upload Mode. | Set the Upload Mode that matches your rows, or the mode that allows both. |
| Dynamic Tag Number creation is not enabled for this Physical Inventory | Trying to create a tag where dynamic tag entry is off. | Enable dynamic tag entry for the physical inventory, or only update existing tags. |
| Matching Tag exists already | A tag with the same item, location, lot and serial already exists. | Update that existing tag instead of creating a duplicate. |
| Tag details cannot be changed | An identifying field was changed on an existing tag. | Restore the original item and location values; change only the count. |
| Tag UOM and Quantity are required | A non-void tag has no count quantity or unit of measure. | Enter the UOM and Quantity, unless the tag is being voided. |