Search Results wsh_wf_interface




Overview
Explore in AI Chat

Overview

WSH_WF_INTERFACE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema, classified under the ETRM repository as an OTHER-type API. It resides within the Oracle Shipping Execution (WSH) product family and functions as an integration bridge between Shipping Execution and Oracle Workflow-driven business processes. The package name reflects its core responsibility: interfacing Shipping execution data with Workflow — most visibly through the Shipping Confirmation Workflow (SCWF) used by Oracle Order Management and Logistics. Its procedures support the automated progression of delivery and trip lifecycle states, including marking deliveries in transit, closing trips, running shipment interfaces, and submitting Workflow notifications for shipping confirmation.

The package is validated and references the SYS.STANDARD package. It is referenced by no other packages, indicating it sits at the top of the dependency chain rather than being a shared utility. It exposes fourteen documented procedures and functions.

Key Procedures and Functions

The documented API surface is organised around two functional groups: Logistics/Shipping Execution control routines prefixed SCPOD_C_, and Workflow submission routines prefixed SCPOD_S/ITM_.

  • SCPOD_SHIPPING_STATUS — Returns or evaluates the current shipping status of a delivery or delivery detail, used to drive conditional workflow branching.
  • SCPOD_C_MARK_INTRANSIT — Marks a delivery or trip as in-transit, updating delivery legs accordingly as goods leave the warehouse.
  • SCPOD_C_CLOSE_TRIP — Closes a trip once all associated stops and deliveries are completed.
  • SCPOD_C_RUN_INTERFACE — Executes the shipping interface process that pushes shipment and delivery data to downstream consumers.
  • SCPOD_C_PRINT_DOCSET — Triggers printing of the shipping document set (packing slips, bills of lading) associated with a delivery.
  • SCPOD_SCWF_STATUS — Supplements the shipping status logic specifically for the Shipping Confirmation Workflow.
  • SCPOD_C_INTRANSIT_CK, SCPOD_C_INTERFACE_CK, SCPOD_C_CLOSE_TRIP_CK — Validation checks invoked ahead of the corresponding action routines, confirming prerequisites are met before the state transition proceeds.
  • ITM_AT_SHIP_CONFIRM and ITM_AT_DEL_CR — Workflow activity functions supporting ship-confirm and delivery-creation activities.
  • SCPOD_C_SUBMIT_ITM — Submits items to Workflow for downstream processing.
  • MANIFESTING_STATUS — Reports manifesting state for carrier compliance processing.
  • SELECTOR — A selection function that determines which workflow path or action applies for a given record.

Tables Accessed

The package reads and writes the principal Shipping Execution tables via APPS synonyms:

Usage Notes

WSH_WF_INTERFACE procedures are not normally called directly from end-user forms; they are invoked through Workflow activity definitions embedded in the Shipping Confirmation and Delivery workflows, and via concurrent programs managing trip closure and shipping interfaces. Custom code should treat these routines as internal workflow plumbing rather than a supported public API. Where extensions require shipping status transitions, Oracle recommends using the documented public Shipping Execution APIs instead of calling SCPOD_ prefixed routines directly, since their signatures are not guaranteed stable across releases. In 12.1.1 and 12.2.2 the package remains VALID and unchanged in ownership.