Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('DEQUEUE_ANY', upper('bosnds3'), FALSE); END;



执行之前的锁定库存版的上传订单会执行不到这个单据所以需要去执行重新生成调拨的任务

修改存储过程

 

SELECT id
BULK COLLECT
INTO v_tab_orders
FROM (SELECT id
FROM v_otb_onlineorderout a
WHERE a.istodrp = 10
or( a.modifieddate<to_date(sysdate-1/144) and a.istodrp=0)
order by a.id desc)
WHERE rownum <= 5000;


修改视图V_OTB_ONLINEORDEROUT

添加字段

a.modifieddate



之后重新调拨存储过程执行成功。