Skip to end of metadata
Go to start of metadata

新客户在扫描出库后报:ORA-20021: 入队失败:-24010-ORA-24010: QUEUE BOSNDS3.AQ_OMS_STKOUT 不存在:

ORA-06512: 在 "SYS.DBMS_AQ", line 169 ORA-06512: 在 "BOSNDS3.SP_OMS_AQ_STKOUT_ENQUEUE", line 25;传入分销(入队


grant AQ_USER_ROLE to bosnds3;

grant AQ_ADMINISTRATOR_ROLE to bosnds3;

GRANT EXECUTE ON dbms_aq TO bosnds3;

GRANT EXECUTE ON dbms_aq TO bosnds3; / BEGIN DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('ENQUEUE_ANY', upper('bosnds3'), FALSE);

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



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

 

Labels
  • None
Write a comment…