Search Results inv_install




Overview
Explore in AI Chat

Overview

INV_INSTALL is a lightweight Oracle EBS inventory utility package owned by APPS and classified under the API classification category OTHER. Its sole documented purpose is to determine whether the Oracle Warehouse Management System (WMS) capability is installed and available for a given inventory organization. The package exposes a single programmatic entry point, ADV_INV_INSTALLED, which acts as an installation/feature flag check rather than performing any transactional or data-modifying work.

In the Oracle EBS 12.1.1 and 12.2.2 environments, many Inventory and Warehouse Management processes behave differently depending on whether WMS is licensed and configured. Rather than binding WMS logic unconditionally, Oracle code and customer extensions use this package to branch at runtime. The function signature is intentionally simple, returning a BOOLEAN (TRUE when WMS is installed, FALSE otherwise), which allows callers to conditionally execute WMS-specific rules such as license plate processing, advanced task execution, and directed put-away.

Key Procedures and Functions

  • ADV_INV_INSTALLED — Returns a BOOLEAN indicating whether WMS is installed for the organization passed in. Per the source header comment, the function "Checks to see if WMS is installed" and returns "TRUE if WMS installed, else FALSE." The organization id is supplied as input; no other parameters are documented. The function takes no action beyond this determination and does not modify any data.

No other procedures or functions are documented for INV_INSTALL in the ETRM metadata. The package is deliberately narrow in scope and should not be confused with inventory transaction APIs or install scripts that share a similar naming theme.

Tables Accessed

The ETRM metadata for INV_INSTALL lists no directly referenced tables via APPS synonyms. This is consistent with a feature-detection function, which typically resolves its answer by querying installation or configuration registries (for example, checking whether the WMS product is installed and whether the organization is WMS-enabled) rather than reading or writing operational inventory tables. Because the documented metadata does not enumerate table dependencies, integrators should treat the package as a read-only detection utility and should not assume it exposes or mutates business data.

Usage Notes

INV_INSTALL is referenced by 24 other packages, making it a widely used internal dependency within the Inventory and Warehouse Management code base. Typical invocation patterns include:

  • Conditional branching in PL/SQL — calling ADV_INV_INSTALLED to gate WMS-specific logic before executing warehouse routines.
  • Forms and concurrent programs — indirectly, where form logic or concurrent managers call packages that depend on the installation check.
  • Custom code and extensions — developers writing Inventory/WMS customizations can call the same function to align behavior with the seeded application.

Because the function returns a BOOLEAN rather than a character or numeric value, it is intended for use inside PL/SQL and cannot be called directly from SQL statements or used as a concurrent program argument without conversion. The header timestamp (115.3) reflects an early release, and the package has remained stable, indicating that its contract is considered frozen. When adapting customizations across 12.1.1 and 12.2.2, developers can rely on the documented behavior of ADV_INV_INSTALLED as a stable WMS installation check.