Search Results inv_quantity_tree_ue




Overview
Explore in AI Chat

Overview

INV_QUANTITY_TREE_UE is an Oracle E-Business Suite inventory package owned by the APPS schema. Its name reflects its role as a user-exit style program unit that constructs a hierarchical, multi-dimensional representation of available inventory quantity for a given item, organization, and optional demand context. This "quantity tree" reconciles on-hand balances with reservations, pending transactions, lot, serial, and revision controls, producing the net available and on-hand figures that downstream Oracle Inventory and Order Management logic relies upon when validating supply.

The package encapsulates the various control-flag and source-type constants used to steer that calculation, such as lot control, serial control, revision control, subinventory scoping, and quantity source indicators. It is classified under the ETRM taxonomy as OTHER rather than as a published public API, which indicates that it is generally treated as internal supporting infrastructure rather than a formally supported integration interface.

Key Procedures and Functions

The documented interface exposes seven program units, of which four are highlighted in the ETRM metadata:

  • CREATE_TREE — The core builder. Given an organization and inventory item, together with control inputs for revision, lot, serial, demand context, tree mode, negative-inventory tolerance, UOM, and subinventory scoping, it assembles the quantity tree and returns available quantity, on-hand quantity, return status, and a message payload. An overloaded variant is also documented to support alternate calling conventions.
  • QUERY_TREE — Provides read access to an already constructed tree, allowing callers to interrogate the computed hierarchy without rebuilding it. This is the procedure most directly associated with the "query_tree" search context.
  • XACT_QTY — Derives quantity values associated with transaction activity, folding pending or staged transaction volumes into the availability picture.
  • PRINT_DEBUG — A diagnostic routine used to emit debug output during tree construction and interrogation, supporting troubleshooting of quantity discrepancies.

The remaining three documented procedures follow the same internal-utility character; their exact parameter lists are not reproduced here.

Tables Accessed

The ETRM metadata records MTL_SYSTEM_ITEMS as the referenced table, accessed via an APPS synonym. This master item definition supplies the item attributes — lot control, serial control, and revision control flags in particular — that CREATE_TREE uses to determine which branches of the quantity tree are applicable. Additional quantity sources such as on-hand balances, material transaction temp records, and demand reservations are referenced through the source-type constants defined in the package specification, though these are not itemised as separate tables in the documented metadata.

Usage Notes

Because INV_QUANTITY_TREE_UE is an "UE" (user exit) package, it is typically invoked indirectly by Oracle Inventory forms, transaction validation logic, or concurrent processes that need an authoritative available-to-promise or available-to-reserve figure for an item in a specific organization.

  • The package does not appear as a dependency of any other documented package, indicating it is called from forms or external code rather than from a package-to-package chain.
  • Custom code should treat it as an internal API: the specification has seen bug fixes (for example around demand header defaults), so version stability is not guaranteed across releases.
  • When debugging availability discrepancies, PRINT_DEBUG should be enabled and QUERY_TREE used to inspect the resulting hierarchy before assuming an error.