Difference between AQ$TableName and Queue TableName
YJ7Sep 1 2010 — edited Oct 28 2010Our BPEL process is listening to Business event from Oracle ebiz. Noticed the following
BE raised -> Message available in wf_deferred (queue table name) -> Message available in wf_bpel_qtab (queue table name) -> BPEL instance invoked.
After the above process ,noticed that the record state in wf_bpel_qtab is 0 and there is no value in dequeue time. On the other hand, in AQ$WF_BPEL_QTAB view, for the same message the state is Processed and dequeue time is populated.
1. Why there is difference in data AQ$TableName and queue TableName
2. Is there any process, to make sure that the data in both AQ$TableName and queue TableName are in sync
3. When the data will be deleted from queue TableName ? Currently, the retention value of the Queue is 0.
Thanks.