ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 订单行状态错误(wf_engine.handleerror)

订单行状态错误(wf_engine.handleerror)

原创 Linux操作系统 作者:jiulong80 时间:2012-06-28 13:23:30 0 删除 编辑

销售订单行booked后,挑库到待发库,突然决定不再发货,对订单行作backordered,但是订单行的状态没有变为cancle,仍然是picked,导致整个订单无法关闭!

具体操作步骤:
  
  1)om/order organizer /new sale order i create an sale order ,entry order line ordered item:C.BT.250-100G-2.8.J 02 qty: is 11
  2) om/ship transaction/pick release reserved 11.and transer to satged subinventory 'DFK'.
   
    3) later,i do not want to ship it to custmer, in ship transaction form, i do backordered,delivery is clos
  ed,but order line status is
  picked, in ship transaction form, query it ,line pick status is staged, reserved is not released.

solution:

  Dwon the script. from Metalink
  
   Declare
     l_line_id  number := &order_line_id;
   l_user_id  number;
   l_resp_id  number;
   l_resp_appl_id number;
   l_wf_exists varchar2(1) := 'Y';

Begin
  update oe_order_lines_all
       set ordered_quantity  = 0,
           cancelled_quantity = nvl(cancelled_quantity, 0) + ordered_quantity ,
           cancelled_flag   = 'Y',
       

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7771602/viewspace-734046/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: test
请登录后发表评论 登录
全部评论

注册时间:2012-06-28

  • 博文量
    2
  • 访问量
    4132

最新文章