R12: END_DATE Is Not Populating Correctly in "Signon Audit Users" Report Output in case of ICX: Session Timeout (Doc ID 1463817.1)

Last updated on AUGUST 10, 2015

Applies to:

Oracle Application Object Library - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

END_DATE is not populating correctly in "Signon Audit Users" concurrent program output in case of ICX: Session Timeout.

Steps to Reproduce:

1.) Logged in with SYSADMIN user and then run the concurrent program "Signon Audit Users" for "SYSADMIN". Able to see new session at 7:05. Output is as below.
 
 
 Session Number  User Name             Start Active Time        End Active Time     ORACLE Process
 --------------       ------------             ----------------------    ------------------    ------------------
          45381       SYSADMIN              24-MAR-11 07:05                                      44
 
2.) Wait for Session Timeout. After Session Time out, login from session timeout login option. Able to see new session at 8:18. It didn't put the end date on above session in step 1.
 
 Session Number  User Name             Start Active Time        End Active Time     ORACLE Process
 --------------       ------------             ----------------------    ------------------    ------------------
  
       45389       SYSADMIN              24-MAR-11 08:18                                      96
          45381       SYSADMIN              24-MAR-11 07:05                                      44
 
3.) Logout normal and login again. Able to see that end date for very first session in step 1.
 
Session Number  User Name             Start Active Time        End Active Time     ORACLE Process
 --------------       ------------             ----------------------    ------------------    ------------------
  
        45394      SYSADMIN              24-MAR-11 08:29                                       37
          45389      SYSADMIN              24-MAR-11 08:18                                       96
          45381      SYSADMIN              24-MAR-11 07:05        24-MAR-11 08:29      44
 
4.) Logout normal and login again. Able to see that end date for step 3.
 
Session Number  User Name             Start Active Time        End Active Time     ORACLE Process
 --------------       ------------             ----------------------    ------------------    ------------------
  
        45397      SYSADMIN              24-MAR-11 08:35                                       37
          45389      SYSADMIN              24-MAR-11 08:18                                       96
          45381      SYSADMIN              24-MAR-11 07:05        24-MAR-11 08:29      44
          45394      SYSADMIN              24-MAR-11 08:29        24-MAR-11 08:35      37
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms