| Question - Look up Workflow Notification Preferences via SQL [message #238071] |
Wed, 16 May 2007 10:10  |
sbattisti
Messages: 39
Registered: June 2005
|
Member |
|
|
Hi folks,
I'm trying to figure out a way to look up workflow notification preferences via SQL, but I can't quite seem to figure out where the information is stored. Can anyone assist?
Specifically, in Oracle e-Business Suite, if you are logged into employee or manager self-service, there is a Preferences link in the top right. That takes you to a page that has various options, such as your language, regional settings, etc.
One of these options is called "Email Style" under the "Notifications" heading. The values you can select include:
<none>
Disabled
Do not send me mail
HTML mail
HTML with Attachments
HTML summary mail
Plain text mail
Plain text mail with HTML Attachments
Plain text summary mail
I'm trying to write a report that will provide a list of active Oracle users, their employee numbers, and which of these preferences they have selected.
I'm fairly certain it has to do with fnd_profile_options and fnd_profile_option_values, but I can't seem to find the right ones. Any ideas?
Steve
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
