这篇文章主要介绍了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 Distinct 'alter 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问题处理的示例分析”这篇文章对大家有帮助，同时也希望大家多多支持创新互联，关注创新互联行业资讯频道，更多相关知识等着你来学习!
重庆分公司
重庆分公司
