Results for “physical_inventory_name”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MTL_PHYSICAL_INVENTORIES is the foundational definition table for physical inventory counts in Oracle E-Business Suite Inventory (INV). Owned by the INV schema, it stores one row per physical inventory event scheduled or executed within an inventory organization. Each row captures the parameters, tolerances, account assignments, and workflow controls that govern how a count is performed, frozen, tagged, adjusted, and approved. Because Oracle EBS supports both 12.1.1 and 12.2.2 with essentially identical INV schema semantics, this table remains stable across those releases and is central to reconciliation, audit, and period-close reporting.

From a Data Vault modeling perspective, the metadata's heuristic classification of this table is hub-leaning. Its composite primary key — ORGANIZATION_ID plus PHYSICAL_INVENTORY_ID — behaves like a natural business key that uniquely identifies each physical inventory occurrence, while descriptive and control columns can be modeled as satellite attributes. This structure makes the table a natural candidate for a hub with one or more attached satellites.

Key Information Stored

The documented physical schema contains 46 columns. The most significant are:

Common Use Cases and Queries

The table underpins physical inventory setup, execution, and reporting. A typical query retrieves all physical inventories for an organization:

  • SELECT physical_inventory_id, physical_inventory_name, physical_inventory_date, freeze_date, total_adjustment_value FROM mtl_physical_inventories WHERE organization_id = :org_id ORDER BY physical_inventory_date DESC;
  • Reconciliation reporting joins to adjustment and tag tables to compute count completeness and variance exposure.
  • Audit queries examine APPROVAL_REQUIRED, tolerance fields, and audit columns to confirm controls were applied.
  • Period-close reporting aggregates TOTAL_ADJUSTMENT_VALUE and LAST_ADJUSTMENT_DATE by organization and date.

Related Objects

The documented foreign-key relationships define the principal supporting objects:

  • MTL_PARAMETERS — parent for ORGANIZATION_ID, providing organization defaults.
  • MTL_PHYSICAL_ADJUSTMENTS — child via ORGANIZATION_ID and PHYSICAL_INVENTORY_ID; holds posted count adjustments.
  • MTL_PHYSICAL_INVENTORY_TAGS — child via the same key; stores individual tag entries.
  • MTL_PHYSICAL_SUBINVENTORIES — child via the same key; defines subinventories included in the count.
  • GL_CODE_COMBINATIONS — referenced through DEFAULT_GL_ADJUST_ACCOUNT for accounting validation.

These relationships make MTL_PHYSICAL_INVENTORIES the coordination point for physical inventory execution and post-count accounting in Oracle Inventory.