Results for “item_flex_name”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WSH_CORE is a foundational PL/SQL package in the Oracle EBS Shipping (WSH) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. Its documented purpose is to support the Shipping application's reporting and user-interface layers by resolving internal identifiers into human-readable flexfield names and by returning shipper address information. The package abstracts the complexity of Oracle Applications key flexfield APIs, allowing callers to convert surrogate keys such as inventory_item_id and locator_id into their display names without embedding flexfield structure logic directly in report or form code. This package is classified as OTHER in the ETRM repository, indicating that it is an internal utility package rather than a public, supported business API. The header comment ($Header: WSHCORES.pls 115.0 99/07/16) indicates the package has been stable since the late 1990s and remains present in EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

  • ITEM_FLEX_NAME — Converts an inventory item identifier, combined with a warehouse identifier, into the item's flexfield name. If the name cannot be resolved, the function returns a question mark ('?').
  • LOCATOR_FLEX_NAME — Converts a locator identifier, together with a warehouse identifier, into the locator's flexfield name. It follows the same '?' fallback convention when the name is not found.
  • GENERIC_FLEX_NAME — A generalized resolver that converts an arbitrary entity identifier into its key flexfield name. The caller supplies the entity ID, warehouse ID, application short name, key flexfield code, and structure number, making this function reusable across different flexfield definitions.
  • SHIPPER_ADDRESS — Returns the shipper's address information for reports. It accepts an organization identifier and returns the organization name plus structured address elements (address lines, city, region, and postal code) as output parameters.
  • CITY_REGION_POSTAL — Supports address formatting by resolving city, region, and postal code components for shipping documents and reports.

Tables Accessed

The ETRM metadata does not enumerate specific base tables referenced by WSH_CORE. However, given its documented behavior, the package necessarily reads from the organization and location tables that store shipper address attributes (such as HR_LOCATIONS and HR_OPERATING_UNITS) via APPS synonyms, and from the inventory item and locator key flexfield structures underlying the item and locator identifiers. Flexfield name resolution is performed indirectly through calls to the Oracle Applications Flexfield (FND_FLEX) APIs rather than through direct table access, which is why no table list is published. All access occurs through APPS-owned synonyms, consistent with the package's APPS ownership.

Usage Notes

WSH_CORE is an internal helper package. It is not a public API and is not intended for direct invocation by external integrations. It is most commonly called from Shipping reports and concurrent programs that need to render item, locator, and shipper address values in a printable form, and from Shipping forms that display descriptive flexfield names. The ETRM metadata records that the package is referenced by one other package, reflecting its role as a low-level dependency within the WSH code stack. Because the package is declared AUTHID CURRENT_USER, privileges are evaluated against the invoking user's schema rather than the definer's, so callers must have the necessary grants on the underlying synonyms and flexfield APIs. Custom code should avoid calling WSH_CORE directly; instead, the supported public WSH APIs or standard flexfield views should be used. The '?' return convention means callers must handle unresolved names explicitly when building user-facing output.