WH Notifications disabled

➜ Back to Library
Description
This may be done by the users on purpose, or by the system because of a problem with a bad email address.
It is recommended to verify all the email addresses Users that have DISABLED notification preference using :

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select wlr.name, wlr.display_name, wlr.description, wlr.status,
wlr.orig_system, wlr.email_address, wlr.notification_preference
from 
wf_local_roles wlr, fnd_user fu
where 1=1
and fu.user_name=wlr.name
and notification_preference = 'DISABLED'
and user_flag = 'Y'
Parameter Name SQL text Validation
User Name 
fu.user_name=:user_name
 LOV
Download
 
Related Blitz Reports
FND User Roles FND W3H_User_Roles FND Roles FND W3H_Role_Functions FND W3H_Role_Users GCS Consolidation Entries Writeback FND W3H_Role_Objects OKL Termination Quotes FND Role Hierarchy
Blitz Report™

Blitz Report™ provides multiple benefits: