Search Results mtl_physical_inventory_tags




Overview
Explore in AI Chat

Overview

The MTL_PHYSICAL_INVENTORY_TAGS table is a core transactional entity within Oracle E-Business Suite Inventory (INV) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for all physical inventory tag definitions generated during a cycle count or full physical inventory. Each record represents a single, pre-numbered or system-generated tag that is used to identify and record the count of a specific item at a specific location within an organization. The table's primary role is to capture the initial counted quantity before any adjustments are applied, forming the critical link between the physical counting process and the subsequent system reconciliation and adjustment workflows.

Key Information Stored

The table's primary key is TAG_ID, which uniquely identifies each physical inventory tag. Key columns store the essential context of the count, including the PHYSICAL_INVENTORY_ID linking to the parent inventory event, and ORGANIZATION_ID. It holds identifiers for the counted item (INVENTORY_ITEM_ID), its location (SUBINVENTORY and LOCATOR_ID), and lot/serial control attributes (LOT_NUMBER, SERIAL_NUM). The counted quantity is stored in the COUNT column. The table also tracks the tag's status (e.g., New, Used, Approved) and maintains relationships to adjustment records via the ADJUSTMENT_ID foreign key. For Warehouse Management Systems (WMS) implementations, it stores license plate information via PARENT_LPN_ID and OUTERMOST_LPN_ID.

Common Use Cases and Queries

This table is central to reporting and troubleshooting the physical inventory process. Common use cases include analyzing count progress by comparing used versus unused tags, investigating count variances before approval, and auditing historical inventory snapshots. A typical query retrieves all tags with their current status and counted details for a specific physical inventory.

  • Sample Query - Tags with Variances: SELECT tag_id, inventory_item_id, subinventory, locator_id, lot_number, count, adjustment_quantity FROM mtl_physical_inventory_tags WHERE physical_inventory_id = :p_inv_id AND adjustment_id IS NOT NULL;
  • Reporting Use Case: Generating a report of all uncounted items (tags still in 'New' status) for a given subinventory to direct count teams.
  • Data Fix Scenario: Identifying tags missing lot numbers for lot-controlled items to correct data before posting adjustments.

Related Objects

The table has extensive foreign key relationships, as documented, integrating it deeply with the inventory data model. Key related objects include: