Search Results process_file

Overview

WSH_ROUTING_REQUEST is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is classified as an "OTHER" API object within the ETRM repository, indicating that it is not a formalized public interface such as an Open Interface or PL/SQL API certified for external integration, but rather an internal processing utility invoked by other Warehouse Management (WSH) components. Functionally, the package supports the routing and dispatch preparation of outbound delivery data by consuming inbound flat-file records and translating them into delivery-detail and routing constructs within the WSH schema. It is most closely associated with the inbound logistics processing pipeline, where supplier-originated data (for example, advance ship notices or routing instructions tied to a supplier party) must be validated, matched to party sites, and staged as new delivery records.

Key Procedures and Functions

The ETRM metadata documents a single entry point for this package:

• PROCESS_FILE — The primary processing procedure. It reads source records supplied through the WSH file message mechanism (WSH_FILE_MSG_TABLE and WSH_FILE_RECORD_TYPE, as listed in the dependency information) and applies routing logic to create or update delivery information. It orchestrates the sequence of validation, lookup, and insert operations that convert file content into WSH operational data.

No additional parameters, overloads, or private helper subprograms are published in the documented metadata; accordingly, no parameter signatures are asserted here.

Tables Accessed

The documented table references, resolved through APPS synonyms, are:

• HZ_PARTY_SITES and HZ_PARTY_SITE_USES — Used to resolve and validate the trading partner or supplier party site associated with an incoming routing record, ensuring deliveries are attributed to a valid party site and its designated use.
• MTL_UNITS_OF_MEASURE — Provides unit-of-measure validation for quantities carried on the inbound records.
• WSH_DELIVERY_DETAILS — The core delivery line table; the procedure writes or reconciles delivery detail rows derived from the file.
• WSH_NEW_DELIVERIES — Holds newly created delivery headers pending further processing.
• WSH_INBOUND_TXN_HISTORY — Records processing history for inbound transactions, supporting audit and reprocessing.
• PLITBLM — A standard PL/SQL table (index-by table) type used internally for array-based bulk processing.

The package also references WSH_FILE_MSG_TABLE and WSH_FILE_RECORD_TYPE from the WSH file framework, which supply the record structure consumed by PROCESS_FILE.

Usage Notes

WSH_ROUTING_REQUEST is referenced by one other package and, per the dependency listing, appears in the dependent-code chains of WSH_ROUTING_REQUEST (self-reference within the shared package structure) and WSH_SUPPLIER_PARTY. This linkage explains the user search term "wsh_supplier_party": the package is invoked in scenarios where supplier party information must be resolved during routing request processing. Typical invocation occurs from concurrent programs or internal WSH processing flows rather than directly from a form or user action. Because it is classified as OTHER rather than a certified public API, custom development should not call PROCESS_FILE directly; instead, the supported inbound interfaces and concurrent programs that wrap this logic should be used. The dependency on WSH_INBOUND_TXN_HISTORY further indicates the procedure is designed for repeatable, auditable batch execution, where failures can be diagnosed from history records and the source file re-submitted.