INV Physical Inventory Tag Count Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
INV Physical Inventory Tag Count Upload ================================= This upload enables the user to upload counts against the Physical Inventory Tags defined against the specified Physical Inventory.
The upload supports
- the update of counts against existing Tags
- the generation of new tags. For clients on R12.2.14 or creation of manually entered tag numbers is supported For clients on earlier releases, to generate a new tag leave the tag number blank. The tag number will be automatically generated when the tag is created
For clients on R12.2.3 or later
- the upload also supports the voiding/unvoiding of existing tags as well
Note: There is currently a bug in the R12.2.3+ API that will reject the creation/update of tags for items which do not require Locatiors in Subinvnetories wher the Location Control is set to ‘Check Item Level’. The API is only checking the Locator control level at the subinventory level, and if is not set to ‘Locators not required’ will reject any tags for items where no locator is specified. For this reason, if the physical inventory being uploaded includes any subinventories with Locator Control set to ‘Check Item Level’, the upload will revert to using the older API.
Report Parameters
Upload Mode, Organization Code, Physical Inventory, Counted By, Subinventory, Category Set, Category From, Category To, Item, Item From, Item To, Item Type, Locator, Locator From, Locator To, Tag Number From, Tag Number To, Void Status
Oracle EBS Tables Used
mtl_physical_subinventories, gl_code_combinations_kfv, per_all_people_f, mtl_physical_inventories_v, mtl_physical_inventory_tags, mtl_physical_adjustments, mtl_parameters, mtl_item_locations_kfv, mtl_system_items_vl, mtl_item_categories, mtl_categories_kfv, mpit_qry
Report Categories
Related Reports
GL Account Distribution Analysis, GL Account Analysis (Distributions), GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Analysis, INV Item Upload, INV Items
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | None |
| Blitz Report™ XML Import | INV_Physical_Inventory_Tag_Count_Upload.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-physical-inventory-tag-count-upload/ |
INV Physical Inventory Tag Count Upload - Case Study & Technical Analysis
Executive Summary
The INV Physical Inventory Tag Count Upload is a productivity tool that replaces manual data entry. In a typical physical inventory, thousands of tags are written by hand and then manually keyed into Oracle. This tool allows the counts to be entered into Excel (or captured via scanners into Excel) and then uploaded in bulk.
Business Challenge
Manual data entry of tag counts is:
- Slow: Typing thousands of numbers takes days.
- Error-Prone: Typographical errors (e.g., entering 100 instead of 10) lead to false variances.
- Resource Intensive: Requires a team of data entry clerks during the critical count weekend.
Solution
The INV Physical Inventory Tag Count Upload streamlines the process. Counters can record data electronically, or data entry clerks can type into a spreadsheet (which is faster than the Oracle Forms UI). The sheet is then uploaded directly to the database.
Key Features:
- Bulk Entry: Upload thousands of counts in seconds.
- Validation: Checks for valid Item, Subinventory, Locator, and Lot numbers during upload.
- New Tag Creation: Can create “Dynamic Tags” for items found in locations where they weren’t expected.
- Void/Unvoid: Supports voiding tags that were not used.
Technical Architecture
The tool uses an API or interface table approach to insert data into the physical inventory tag tables.
Key Tables and Views
MTL_PHYSICAL_INVENTORY_TAGS: The table where the counts are stored.MTL_PHYSICAL_INVENTORIES: The parent inventory record.MTL_SYSTEM_ITEMS_VL: Item validation.MTL_ITEM_LOCATIONS_KFV: Locator validation.
Core Logic
- Data Parsing: Reads the Excel rows containing Tag Number, Quantity, and Attributes.
- Validation: Verifies that the tag belongs to the specified physical inventory.
- Update/Insert: Updates the count on existing tags or inserts new tags if they don’t exist (and dynamic tags are allowed).
Business Impact
- Speed: Reduces the “Data Entry” phase of the physical inventory from days to minutes.
- Accuracy: Eliminates transcription errors if data is captured via barcode scanners into Excel.
- Cost Savings: Reduces overtime costs for data entry staff.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics