Search Results org_hierarchy_list

Overview

The APPS.INV_MGD_POS_ORGANIZATION_MDTR package body is a component of the Inventory Management (INV) module in Oracle E-Business Suite, specifically supporting the Inventory Position View and Export feature set. Its documented purpose is to act as an "Organization Mediator," meaning it resolves the set of inventory organizations that participate in a given organizational hierarchy and hierarchy level. In EBS reporting and inquiry flows, particularly those that aggregate on-hand or position information across multiple inventory organizations, the application needs a reliable way to determine which organizations fall under a selected hierarchy level. This package encapsulates that resolution logic behind a single public entry point, isolating callers from the underlying hierarchy-traversal mechanics.

The package header records a creation date of 09/05/2000 by Paolo Juvara, placing it among the older architectural layers of the INV module. Later maintenance entries document evolution of the implementation: a 2002 fix (Bug#2563291) replaced the legacy org_hierarchy_list API with the newer get_organization_list API, and a subsequent performance change limited diagnostic output to the log only when the AFLOG_ENABLED profile option is set. The package carries the ETRM API classification "OTHER," reflecting its role as an internal mediator rather than a formally registered public API.

Key Procedures and Functions

• BUILD_ORGANIZATION_LIST — The single documented public procedure. It builds the list of organizations that belong to a specified hierarchy level. It accepts a hierarchy identifier and a hierarchy level identifier, and returns a collection of organizations. Its documented post-condition is that the returned organization table is not empty, which is an important contract for callers that assume at least one organization resolves from a valid level selection.

Tables Accessed

• MTL_PARAMETERS — The Inventory organization definition table. Accessed to validate and resolve inventory organizations within the hierarchy so that only genuine inventory-enabled organizations are returned in the result set.
• PLITBLM — A standard Oracle EBS temporary/logging table used for diagnostic output. Access to this table is conditioned on the debug profile option, consistent with the documented performance modification that suppresses logging unless AFLOG_ENABLED is enabled.

Usage Notes

This package is typically invoked indirectly rather than directly by end users. It is referenced by one other package in the ETRM metadata, indicating it is consumed by a higher-level Inventory Position View and Export routine that orchestrates organization resolution before querying position data. Custom code that needs the same hierarchy-to-organization expansion can call BUILD_ORGANIZATION_LIST directly, but developers must supply valid hierarchy and hierarchy level identifiers and must honor the documented non-empty post-condition.

Because the implementation was migrated from org_hierarchy_list to get_organization_list, any legacy customizations that referenced the older API should be reviewed for consistency with the current behavior. In EBS 12.1.1 and 12.2.2, the deployment location and calls remain consistent; the 12.2 online patching model simply changes how the file is applied, not how the API is called. Debug logging should be enabled only transiently, since log writes to PLITBLM occur solely when the profile option is active.