几个WMS的问题处理

最新推荐文章于 2024-12-24 10:09:51 发布

转载最新推荐文章于 2024-12-24 10:09:51 发布 · 287 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://blog.51cto.com/bks2015/2047879

文章标签：

#数据库

采购订单没有生成上传订单号
pkg_inpurchase_task.p_rk_sc_rkd_zc

iv_yzid ----- ZDA

iv_djbh ---- KPD00014712

销售订单下传下去后直接转历史表

select * from INTERFACE_OUT_SALE_M t where djbh like '%XSGYMA00220297%'
日志表查询结果
ORA-01400: 无法将 NULL 插入 ("WMS_ZD"."OUT_SALE_BILLING_M"."RY_KPY")
pkg_inf_new.p_task_xsdd

ov_result ------Y

内复核提示单行子查询返回多行

select t.*,t.rowid from out_sale_barcode t where djbh='XSGYMA00220712'

select * from out_sale_task_d t where djbh_fpd='2017120594831'
无返回值
将out_sale_barcode表中djbh_fpd='2017120594831' 删除

查看用户名密码
select t.*,t.rowid from zhiydoc t where dzycode='admin'

proc_decode

中 encodepass 赋予 Kl值

开启不合格移库功能
select t.*,t.rowid from SYS_DEFFUN T WHERE FUN_NAME LIKE '%不合格%'

将can_use 的值1改为0

修改入库类型，收货前将rktype 修改成所需类型
select t.*,t.rowid from in_purchase_orders_m t where djbh in ('XSTYMA00029852','XSTYMA00029849','XSTYMA00029848', 'XSTYMA00029847','XSTYMA00029845','XSTYMA00029841','XSTYMA00029840', 'XSTYMA00029839', 'XSTYMA00029838','XSTYMA00029837', 'XSTYMA00029836')

销退空退写错
select t.*,t.rowid from IN_PURCHASE_ORDERS_m t where djbh='XSTYMA00030579';

update IN_PURCHASE_ORDERS_m set sf_zx='删' where djbh='XSTYMA00030579' and sf_zx='否';
update IN_PURCHASE_ORDERS_d set sf_zx='删' where djbh='XSTYMA00030579' and sf_zx='否';

数据库慢了可以先看会话里是否有锁然后重新分析索引
analyze table out_sale_billing_m compute statistics;
analyze table out_sale_billing_d compute statistics;
analyze table out_sale_billing_m_hty compute statistics;
analyze table out_sale_billing_d_hty compute statistics;
analyze table out_sale_task_d compute statistics;
analyze table out_sale_task_m compute statistics;
analyze table out_sale_task_d_hty compute statistics;
analyze table out_sale_task_m_hty compute statistics;

销售开票单下传WMS后无任务就转历史
select t.,t.rowid from out_sale_billing_m t where djbh='XSGYMA00281145'
select t.,t.rowid from out_sale_task_d_hty t where djbh='XSGYMA00281145'
select t.,t.rowid from interface_out_sale_m_hty t where djbh='XSGYMA00281145'
select t.,t.rowid from out_sale_task_d t where djbh='XSGYMA00281145'
select t.*,t.rowid from inf_error_log t where code='XSGYMA00281145'

select t.*,t.rowid from interface_out_sale_m_hty t where djbh='XSGYMA00291738'
看xf_xs　为否，如果是否则查询RY_YWY中开票员名字是否有　（用职员名字也有用职员ＩＤ）
加入执行看过程proc_out_dowm_to_bill是否要执行

select t.,t.rowid from inf_xsck_bill t where djbh ='XSGYMA00322995';
select t.,t.rowid from inf_xsck_bill_old t where djbh ='XSGYMA00322995';
select t.,t.rowid from inf_error_log t where code='XSGYMA00322995'
\ORA-01400: 无法将 NULL 插入 ("WMS_ZD"."OUT_SALE_BILLING_M"."RY_KPY")
select t.,t.rowid from out_sale_task_d t where djbh ='XSGYMA00322995'
查询出库任务状态
select t.*,t.rowid from out_sale_task_d t where spid ='SPH00014714' and rwzt<6;

中药库内复核确认存盘时提示　ORA-02290: 违反检查约束条件(wms_zd.ckc_sl_ckyfp_kc_spzkc)
ORA-06512:在 wms_zd.pkg_outsale_pick ,line 11347

--查看商品任务状态
select rwzt,t. from out_sale_task_d t where djbh = 'XSGYMA00348786';
--查看此商品总预占数量
select from out_sale_task_d where rwzt < '6' and spid = 'SPH00020269';
--查看商品库存出库状态将此两表的SL_CKYFP中数量1改为2
select t.,rowid from stock_lot_storagespaces t where spid = 'SPH00020269';
select t.,rowid from stock t where spid = 'SPH00020269';

转载于:https://blog.51cto.com/bks2015/2047879