WMS问题处理的示例分析

这篇文章主要介绍了WMS问题处理的示例分析，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。

采购订单没有生成上传订单号

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;

--删除配送单无法清空暂存区的数据

UPDATE PS_ZCD_HZ T SET T.SF_FH=是,t.sf_fhwc=是 where t.sf_fh= 否 AND SF_FHWC = 否

AND SF_TY = 否 and T.DJBH=ZCD00060245--.rq <= to_date(2019-07-11,YYYY-MM-DD)--托运单据条件SF_TY=是--处理锁死 select Distinctalter system kill session ||chr(39)||b.sid||,||b.serial#||chr(39)||;

As cmd,b.username,b.logon_time

from v$locked_object a,v$session b

where a.session_id=b.sid;

SELECT /+ RULE /

LPAD( , DECODE(L.XIDUSN, 0, 3, 0)) || L.ORACLE_USERNAME USER_NAME,

S.STATUS,

O.OWNER,

O.OBJECT_NAME,

O.OBJECT_TYPE,

S.SID,

S.SERIAL#,

S.MACHINE,

S.TERMINAL,

S.SQL_HASH_VALUE,

S.SECONDS_IN_WAIT,

(SELECT SQL_FULLTEXT

FROM V$SQL

WHERE HASH_VALUE = S.SQL_HASH_VALUE

AND ROWNUM = 1) SQL_TEXT

FROM V$LOCKED_OBJECT L, DBA_OBJECTS O, V$SESSION S

WHERE L.OBJECT_ID = O.OBJECT_ID

AND L.SESSION_ID = S.SID

ORDER BY S.SECONDS_IN_WAIT DESC, O.OBJECT_ID, XIDUSN DESC;          --杀进程           ALTER SYSTEM KILL SESSION 35,4293;                     -- Create table

create table JG_INFO

(

yez_id     VARCHAR2(30) not null,

ruckd_no   VARCHAR2(20) not null,

jiang_cd   VARCHAR2(30) not null,

caoz_staff VARCHAR2(30) not null,

oper_date  DATE default SYSDATE not null,

danw_id    VARCHAR2(30) not null,

shangc_flg VARCHAR2(2) default N not null,

jiang_type VARCHAR2(3) not null,

shangp_id  VARCHAR2(80) not null,

fenpd_no   VARCHAR2(20) default ,

tiaom_type VARCHAR2(2) not null,

bzlb       VARCHAR2(2),

phid       VARCHAR2(30),

status     VARCHAR2(6),

billno     VARCHAR2(20),

lineno     VARCHAR2(20),

jgscy      VARCHAR2(20),

hwid       VARCHAR2(20)

)

tablespace USERS

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 80K

next 16K

minextents 1

maxextents unlimited

);

-- Add comments to the table

comment on table JG_INFO

is 监管出库信息表;

-- Add comments to the columns

comment on column JG_INFO.yez_id

is 业主内码;

comment on column JG_INFO.ruckd_no

is 入出库单号;

comment on column JG_INFO.jiang_cd

is 监管码;

comment on column JG_INFO.caoz_staff

is 操作员;

comment on column JG_INFO.oper_date

is 操作日期;

comment on column JG_INFO.danw_id

is 单位内码;

comment on column JG_INFO.shangc_flg

is 是否上传;

comment on column JG_INFO.jiang_type

is 监管类型(业务类型 ；0购进入库， 1 销售退回 ，2 销售出库， 3 购进退出);

comment on column JG_INFO.shangp_id

is 商品内码;

comment on column JG_INFO.fenpd_no

is 分配单编号;

comment on column JG_INFO.tiaom_type

is 条码类型（1:监管码  2：防窜码）;

comment on column JG_INFO.bzlb

is 包装类别(0整件,1中包装，2小包装);

comment on column JG_INFO.billno

is ERP单据编号;

comment on column JG_INFO.lineno

is ERP细单行号;

comment on column JG_INFO.jgscy

is 监管码删除用;

comment on column JG_INFO.hwid

is 货位ID;

-- Create/Recreate indexes

create index IND_JG_INFO_DATE on JG_INFO (OPER_DATE)

tablespace USERS

pctfree 10

initrans 2

maxtrans 255

storage

(

initial 43M

next 1M

minextents 1

maxextents unlimited

);

create unique index PK_JG_INFO on JG_INFO (YEZ_ID, RUCKD_NO, SHANGP_ID, JIANG_CD)

tablespace USERS

pctfree 10

initrans 2

maxtrans 255

storage

(

initial 64K

next 1M

minextents 1

maxextents unlimited

);

感谢你能够认真阅读完这篇文章，希望小编分享的“WMS问题处理的示例分析”这篇文章对大家有帮助，同时也希望大家多多支持，关注行业资讯频道，更多相关知识等着你来学习!