Search Results pos_org_hash_pkg




Overview
Explore in AI Chat

Overview

The APPS.POS_ORG_HASH_PKG package body is a server-side PL/SQL construct in Oracle E-Business Suite, owned by the APPS schema and reported with a status of VALID. Its name and dependent objects indicate that it provides a hash-key mechanism for resolving Oracle Purchasing organization (operating unit) identifiers. In EBS, the POS module corresponds to Purchasing, and "ORG" refers to the inventory/operating unit organization. The package supplies a lightweight, indexable surrogate derived from organization identifiers, allowing consumers to look up an organization by a stable hash key rather than by repeating a direct ORG_ID comparison. This is useful in application contexts—particularly iProcurement and other ICX-based self-service flows, evidenced by the dependency on ICX_CALL—where organization context must be carried efficiently through a session or query. The package is catalogued with an API classification of OTHER, meaning it is an internal support utility rather than a published business API. It is documented in ETRM for both 12.1.1 and 12.2.2, confirming its continued presence across the two release lines.

Key Procedures and Functions

Two program units are documented in the package body:

  • GET_HASHKEY — returns the hash key value associated with a given organization. It encapsulates the transformation that converts an organization identifier into the surrogate key stored in the hash table.
  • GET_ORG_ID_BY_KEY — performs the inverse lookup, returning the organization identifier that corresponds to a supplied hash key. This is the primary retrieval path used by callers that hold a key rather than an ORG_ID.

The metadata does not publish parameter lists; only the names and roles above should be relied upon. Both routines are consistent with a deterministic key-generation and key-resolution pairing.

Tables Accessed

The package references POS_ORG_HASH through its APPS synonym. This table persists the mapping between organization identifiers and their hash keys and is the backing store for both documented routines: GET_HASHKEY derives or resolves a key against it, and GET_ORG_ID_BY_KEY reads it to return the organization. The remaining dependencies—HR_OPERATING_UNITS, ICX_CALL, DBMS_STANDARD, and STANDARD—are supporting objects. HR_OPERATING_UNITS supplies the authoritative organization definition for the Purchasing operating unit, while ICX_CALL reflects the self-service invocation path typical of iProcurement. The two SYS packages are standard PL/SQL infrastructure.

Usage Notes

POS_ORG_HASH_PKG is an internal utility rather than a user-facing API; it is not referenced by any other database object according to the documentation, though one other package is recorded as referencing it at the package level. It is most commonly invoked indirectly through iProcurement and related ICX self-service pages, where organization context is resolved during page and query processing, and it may also be called from custom PL/SQL that needs an efficient organization lookup by key. Because the object is classified as OTHER and depends on an internal mapping table, it should be treated as a private implementation detail: integrators should prefer supported Purchasing or HR organization APIs. When troubleshooting organization resolution, verify the integrity and synchronization of POS_ORG_HASH, since a stale or incomplete mapping will cause GET_ORG_ID_BY_KEY to fail to return the expected ORG_ID.