Where (table name) are users' notification preferences stored?

[jonw1]

I'm trying to figure out why we're not delivering one notification type to a particular user.   we're now running a custom service portal, and not able to access notification preferences when impersonating the user.   I'm trying to ascertain whether the user "un-subscribed" from this notification.

Thanks,

Jon

[sachin_namjoshi]

Notification preferences are stored in cmn_notif_messages table.

Regards,

Sachin

[Allen Andreas]

Hi,

You can check the tables: cmn_notif_message and sys_notif_subscription

Please mark reply as Helpful/Correct, if applicable. Thanks!

[apjohn2]

Finally, after literally more than a reasonable amount of time searching, I found you, my sweet, sweet sys_notif_subscription.

Thank you!

[jonw1]

Thank you Alan and Sachin.   Your responses should be helpful.   Note that the correct table name is cmn_notif_message    (singular).