在EBS中定义的业务事件会进入WF_BPEL_Q队列,可以通过查询这个队列处理过的业务事件:
select * from apps.wf_bpel_qtab q where q.q_name='WF_BPEL_Q';
查询当前队列表中自定义的业务事件名称
select distinct q.user_data.EVENT_NAME from apps.wf_bpel_qtab q where q.q_name='WF_BPEL_Q' and q.user_data.EVENT_NAME like 'cux%'
输出结果如下所示:
cux.oracle.apps.om.parts.delivery cux.oracle.apps.inv.miscellaneous.transaction cux.oracle.apps.inv.item.maintain.all cux.oracle.apps.inv.item.maintain cux.oracle.apps.om.machine.delivery cux.oracle.apps.po.parts.transactions