Execution Exception Data Load Service

The transfer of data pertaining to execution exception from the Sterling Warehouse Management System to VLP is accomplished by two services - one on the Sterling Warehouse Management System side, and the other on VLP side.

Sterling Warehouse Management System Data Upload Service

The Sterling Warehouse Management System provides an out-of-the-box YNW_ReasonDataExporter_91 service to upload data pertaining to execution exception into a shared folder, as shown in the following image.

VLP Event

VLP has provided an out-of-the-box VLP_REASON_LOAD event in order to import data pertaining to the execution exception data from the common file. This inbound asynchronous event is also referred to as Import Reason. This event is used to read the XML files uploaded to the common folder by the YNW_ ReasonDataExporter_91 service.

As part of the integration, the VLP_ REASON _LOAD event is associated to the SterlingWMS_VLPReasonCode transport on the VLP side. This transport is of the Sterling Local XML Reader transport type. The following figure shows the SterlingWMS_VLPReasonCode transport associated to the VLP_REASON_LOAD event.

The following figure shows the registration of the VLP_ REASON _LOAD event with the SterlingWMS_VLPReasonCode transport.

The following table represents attribute mapping for execution exception data between the Sterling Warehouse Management System and VLP.

Sterling Warehouse Management System Data
VLP Data
CheckDigit

Reasonid

ExceptionCode

Reasondesc