WMS2.0 批号解锁重发

背景简介

由于网络原因，批号解锁信息有时候未成功上传到SCM，会导致客户无法开 出库单。

涉及系统

SCM    英克WMS（2.0）

批号解锁锁定由WMS发起

SELECT A.*,A.rowid FROM WMS_TPL_LOT_LOCK A

 --如果报错，查看ERRMEMO字段具体报错信息，解决后，执行
UPDATE WMS_TPL_LOT_LOCK SET SENDTOTPLFLAG=NULL, MEMO = NULL

--视图
SELECT A.*,A.rowid FROM wms2tpl_lotlock_web_v A WHERE 1=1;

SCM

SELECT A.*,A.rowid FROM wms2tpl_lot_lock A ,Tpl_pub_goods_v B  WHERE A.GOODSID=B.GOODSID 
and A.lotno='202106ACD1'
AND B.mdmgoodscode='1110362202';


--历史
SELECT A.*,A.rowid FROM wms2tpl_lot_lock_his A ,Tpl_pub_goods_v B  WHERE A.GOODSID=B.GOODSID 
and A.lotno='202106ACD1'
AND B.mdmgoodscode='1110362202';

ESB 接口名称 : BeJMS_WMS_PO_05_锁定解锁生成

正常的能查到

ESB 发送

请求报文:

<?xml version='1.0' encoding='UTF-8' ?>
<soapenv:Body xmlns="" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:v1="http://www.ekingwin.com/basi/sb/log/v1">
    {"REQUEST": {"HEAD": {"BIZTRANSACTIONID": "WMS_Lock_BL80202212120325_1110362202_202106ACD1",
    "COUNT": "1","CONSUMER": "10018;","SRVLEVEL": "1","ACCOUNT": "420689","PASSWORD":
    "","PAGENUM": "","PAGESIZE": "","Module": ""},"LIST":[{"STOCKID": "80","ASNNO":
    "","LOCKNO": "BL80202212120325","GOODSID": "1110362202","GOODSBATCH": "202106ACD1"}]}}
</soapenv:Body>