Core Workflow - EBS (MOSC)

MOSC Banner

How reliable data from AQ$wf_notification_out is?

Good day to you all.

I ran datewise count on wf_notifications table and aq$wf_notification_out view, for the last 30 days.

I see that the view returns only for a handful of days, whereas wf_notifications table has data for each day.

Q1: Isn't any record that has to be sent out will find listed in the view?

If yes, then how come we see only a handful?

Q2: Which table captures that email has been sent out of oracle? If it is aq$wf_notifications_out then why so many records are missing?

Thanking you in advance

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