My Oracle Support Banner

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 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.

select user_name
, start_time
from applsys.fnd_user u
,applsys.fnd_logins l
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.