Search Results wsh_u_util




Overview
Explore in AI Chat

Overview

WSH_U_UTIL is a utility package in the APPS schema belonging to the Oracle Warehouse Management (WSH) product family, specifically aligned with the Warehouse Management shipping execution and carrier integration infrastructure. Within the Oracle EBS 12.1.1 and 12.2.2 releases, packages bearing the WSH_U_ prefix serve as shared helper libraries for the broader WSH module, and WSH_U_UTIL is no exception. Its API classification in ETRM is recorded as UTIL, confirming that it exposes general-purpose routines rather than a public, business-facing API.

The package depends on FND_API, the standard Oracle Application Object Library API package used across EBS for message handling, return status structures, and error management, and on the SYS.STANDARD package. This dependency profile indicates that WSH_U_UTIL performs low-level plumbing work — resolving configuration values, calculating derived tokens, and returning environment-specific endpoints — and surfaces results using EBS-standard calling conventions.

Key Procedures and Functions

ETRM documents three procedures or functions within WSH_U_UTIL:

  • CALCULATE_TOKEN — Derives or computes a token value used by downstream shipping and carrier-integration routines. Tokens of this type are typically used for authentication, session correlation, or message signing when communicating with external carrier or tracking services.
  • GET_CARRIER_API_URL — Resolves and returns the API endpoint URL associated with a given carrier. This supports Oracle's carrier integration framework, where outbound calls to carrier web services (rate shopping, label generation, manifesting, tracking) require a configurable base URL that may differ by carrier, environment, or profile.
  • GET_PROXY — Returns proxy server configuration used for outbound HTTP/HTTPS communication. This allows shipping-related integrations to traverse corporate network proxies without hard-coding network details into individual integration packages.

Parameter lists are not reproduced here; the package is invoked through whatever internal signatures are defined in the shipped package body, and callers should not assume a stable public interface.

Tables Accessed

The ETRM metadata records no direct table references for WSH_U_UTIL via APPS synonyms. This is consistent with a utility package whose responsibilities center on computation and configuration lookup rather than persistent data manipulation. Where configuration values are required (for example, proxy settings or carrier URL definitions), these are typically obtained through profile options, lookup codes, or other WSH configuration packages rather than direct DML against base tables.

Usage Notes

WSH_U_UTIL is referenced by several sibling packages in the WSH_U_ family, including WSH_U_CSPV, WSH_U_GTT, WSH_U_RASS, and WSH_U_TRACK, as well as by itself. This pattern confirms its role as an internal shared library: it is consumed by other WSH utility and tracking packages rather than being invoked directly from Oracle Forms or concurrent programs as a user-facing entry point.

In practice, the package is called as part of the shipping execution and carrier integration flows — for example, when a tracking or rate-shopping package must determine the correct carrier endpoint URL, negotiate a proxy, or compute a token prior to an outbound request. Customizations and extensions in this area should treat WSH_U_UTIL as an Oracle-owned internal object; direct calls should be avoided where a documented public API exists, since the package body is subject to change across patch sets and release upgrades. Any extension development should target the higher-level WSH public APIs and carrier integration hooks instead.