Core Workflow - EBS (MOSC)

MOSC Banner

Cannot purge Alert notifications from wf_notification_out

edited Apr 4, 2017 10:11AM in Core Workflow - EBS (MOSC) 4 commentsAnswered ✓

Hi

I want to purge all the old alerts in READY  and Processed state.

follow the steps in the document,but the record still exist,could you tell me how to purge them?
How to Remove Unwanted Messages from Mailer's Queue without Rebuilding the Queue? (https://mosemp.us.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=759747.1Doc ID 759747.1)


declare
q_version varchar2(200);
event sys.aq$_jms_text_message;
dequeue_options dbms_aq.dequeue_options_t;
message_properties dbms_aq.message_properties_t;
TYPE msgIDTAB is table of raw(16) index by binary_integer;
msg_id msgIDTAB;
dq_msg_id raw(16);

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