Auditing of DMW Login/Logout is not occurring
(Doc ID 2595391.1)
Last updated on OCTOBER 06, 2019
Applies to:Oracle Health Sciences Data Management Workbench - Version 188.8.131.52 to 2.9.0 [Release 2.4 to 2.9.0]
Information in this document applies to any platform.
Require login/logout auditing of DMW sessions. It is possible to get EBS configured to audit LSH logins, however the DMW sessions are not being audited. The steps used to turn on EBS auditing in LSH are:
1. Log onto LSH as sysadmin.
2. Click the System Administrator responsibility link.
A new column of links appears.
3. In the new column of links, scroll to "Profile".
In this section, click on "System".
If you receive a message asking if you want to install an applet, do so.
The System Profile Values window appears.
4. Search for "Sign-On:Audit Level" Profile.
5. Click on Find button.
6. Set Profile Option Name Sign-On:Audit Level to 'Yes'.
7. Save changes.
After setting the above steps, the query below gives the correct details for the user who has logged into LSH UI, but not DMW.
from applsys.fnd_user u
where u.user_id = l.user_id
and user_name = <put Your User Name>
order by start_time desc;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document