Billing and Revenue Management (MOSC)

MOSC Banner

How to clear dm_aq ?

edited Jul 27, 2019 5:09AM in Billing and Revenue Management (MOSC) 1 commentAnswered

Hi,

We have dm_aq configured in BRM to push notification from BRM to Siebel via AIA.

We have batch script written in brm with below SQL which check the count of records in Aq_SYNC table .

SQL:

select count(*) from AQ_SYNC where state<>2 and state<>3 order by enq_time desc;

If the count is greater than 0 it doesn't allow further process to be called written in the script.

so please do help me know how should i clear this queue in brm ? so that further process should be called.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center