Example Analysis of WMS problem handling

This article mainly introduces the WMS problem processing example analysis, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor with you to understand.

The purchase order did not generate an upload order number

Pkg_inpurchase_task.p_rk_sc_rkd_zc

Iv_yzid-ZDA

Iv_djbh-KPD00014712

Transfer the sales order directly to the history table after passing it down.

Select * from INTERFACE_OUT_SALE_M t where djbh like'% XSGYMA00220297%'

Log table query results

ORA-01400: cannot insert NULL ("WMS_ZD". "OUT_SALE_BILLING_M". "RY_KPY")

Pkg_inf_new.p_task_xsdd

Ov_result-Y

Internal review hint single-row subquery returns multiple rows

Select t. From out_sale_barcode t where djbh='XSGYMA00220712'

Select * from out_sale_task_d t where djbh_fpd='2017120594831'

No return value

Delete djbh_fpd='2017120594831' from the out_sale_ barcode table

View username and password

Select t.rowid from zhiydoc t where dzycode='admin'

Proc_decode

Encodepass assigns a value to Kl in

Turn on the unqualified database transfer function

Select t.refine .rowid from SYS_DEFFUN T WHERE FUN_NAME LIKE'% unqualified%'

Change the value of can_use from 1 to 0

Modify the storage type and change the rktype to the desired type before receiving the goods.

Select t. Recording. Rowid from in_purchase_orders_m t where djbh in ('XSTYMA00029852','XSTYMA00029849','XSTYMA00029848',' XSTYMA00029847','XSTYMA00029845','XSTYMA00029841','XSTYMA00029840', 'XSTYMA00029839',' XSTYMA00029838','XSTYMA00029837', 'XSTYMA00029836')

The sale is empty and the error is written.

Select t. From IN_PURCHASE_ORDERS_m t where djbh='XSTYMA00030579'

Update IN_PURCHASE_ORDERS_m set sf_zx=' deletes' where djbh='XSTYMA00030579' and sf_zx=' No'

Update IN_PURCHASE_ORDERS_d set sf_zx=' deletes' where djbh='XSTYMA00030579' and sf_zx=' No'

If the database is slow, you can first see if there is a lock in the session, and then re-analyze the index.

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

After the sales invoice is downloaded to WMS, it will change to history without a task.

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. From inf_error_log t where code='XSGYMA00281145'

Select t. From interface_out_sale_m_hty t where djbh='XSGYMA00291738'

Check whether xf_xs is true, and if so, check whether the drawer's name exists in RY_YWY (using the employee's name is also useful for the employee's ID)

Join the execution to see whether the process proc_out_dowm_to_bill will be executed.

Select t.dart t.rowid from inf_xsck_bill t where djbh = 'XSGYMA00322995'

Select t.dart 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: cannot insert NULL ("WMS_ZD". "OUT_SALE_BILLING_M". "RY_KPY")

Select t.dart t.rowid from out_sale_task_d t where djbh = 'XSGYMA00322995'

Query the status of outgoing tasks

Select t. Recording. Rowid from out_sale_task_d t where spid = 'SPH00014714' and rwzt