采購訂單沒有生成上傳訂單號
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';