Search Results oe_wsh_bulk_grp




Overview
Explore in AI Chat

Overview

WSH_IB_TXN_MATCH_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports inbound (IB) transaction matching within the Oracle Warehouse Management and shipping execution flow. Its principal business function is to reconcile inbound logistics transactions — including receipts, shipment lines, trips, delivery legs, and delivery details — against the expected inbound shipment data recorded in the WSH and RCV schemas. This reconciliation ensures that goods received are correctly matched to their originating deliveries, trips, and trading partners, allowing downstream receiving and inventory processes to proceed with accurate data.

The package is classified as OTHER within the documented API taxonomy, meaning it is an internal processing utility rather than a public, supported API. In EBS 12.1.1 and 12.2.2 it operates as part of the broader inbound transaction handling infrastructure that coordinates data between Oracle Shipping Execution (WSH) and Oracle Receiving (RCV).

Key Procedures and Functions

The ETRM documentation identifies two documented procedures/functions:

  • MATCHTRANSACTION — The primary routine responsible for performing the matching of an inbound transaction against the relevant shipment, delivery, and trip records. It evaluates the transaction context and aligns it with expected inbound data, recording match outcomes in the inbound transaction history.
  • HANDLEPRIORRECEIPTS — A supporting routine that manages scenarios involving previously processed receipts. It addresses the case where receipts already exist for a given inbound transaction, ensuring that match logic does not duplicate or conflict with prior receipt activity.

Parameter lists are not published in the available metadata and should be obtained from the package specification in the EBS instance.

Tables Accessed

The package accesses a range of WSH, RCV, and HZ tables through APPS synonyms. Inbound transaction history and match key sequences — WSH_INBOUND_TXN_HISTORY and WSH_INBOUND_TXN_MATCH_KEY_S — provide the audit trail and unique key generation for matching operations. Receiving data is drawn from RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, and RCV_TRANSACTIONS, giving visibility into expected and actual receipt activity. Delivery and trip structures are read from WSH_DELIVERY_DETAILS, WSH_DELIVERY_LEGS, WSH_NEW_DELIVERIES, WSH_TRIPS, and WSH_TRIP_STOPS, allowing the package to correlate inbound goods with their transport context. Partner identification uses HZ_PARTIES, while WSH_LOCATIONS supplies location data. WF_PARMETER_LIST_T and PLITBLM support Workflow parameter passing and PL/SQL table handling. DUAL is used for scalar evaluation.

Usage Notes

WSH_IB_TXN_MATCH_PKG is an internal package and is not intended for direct invocation by end users or customizations. It is referenced by WSH_BULK_PROCESS_GRP, WSH_BULK_PROCESS_PVT, and itself, indicating it is called from within bulk processing and private processing logic in the shipping execution flow. The dependency on OE_WSH_BULK_GRP — the object surfaced by the user search "oe_wsh_bulk_grp" — confirms that this package participates in bulk inbound group processing, typically triggered through concurrent programs or internal shipping workflows rather than through a form. Developers troubleshooting inbound matching issues should trace execution through the bulk processing group packages rather than calling WSH_IB_TXN_MATCH_PKG directly.