Skip to the content.

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

For clients on R12.2.3 or later

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 Locators in Subinventories where the Locator Control is set to ‘Check Item Level’. The API is only checking the Locator control level at the subinventory level, and if it 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.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

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

Report Categories

Enginatics, Upload

GL Account Distribution Analysis, GL Account Analysis, INV Items, INV Item Upload, INV Item Upload 11i, GL Account Analysis (Drilldown) (with inventory and WIP), INV Physical Inventory Tags, INV Transaction Register, INV Material Transactions

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import INV_Physical_Inventory_Tag_Count_Upload.xml
SQL Source INV Physical Inventory Tag Count Upload.sql
Full Report 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:

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:

Technical Architecture

The tool uses an API or interface table approach to insert data into the physical inventory tag tables.

Key Tables and Views

Core Logic

  1. Data Parsing: Reads the Excel rows containing Tag Number, Quantity, and Attributes.
  2. Validation: Verifies that the tag belongs to the specified physical inventory.
  3. Update/Insert: Updates the count on existing tags or inserts new tags if they don’t exist (and dynamic tags are allowed).

Business Impact


© Enginatics GmbH