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 OCTOBER 15, 2023
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.
Reviewed for Relevance 28 Oct 18.
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
-------------- ------------ ---------------------- ------------------ ------------------
<SESSION1> SYSADMIN 24-MAR-11 07:05 <ID1>
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
-------------- ------------ ---------------------- ------------------ ------------------
<SESSION1> SYSADMIN 24-MAR-11 08:18 <ID2>
<SESSION2> SYSADMIN 24-MAR-11 07:05 <ID1>
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
-------------- ------------ ---------------------- ------------------ ------------------
<SESSION3> SYSADMIN 24-MAR-11 08:29 <ID3>
<SESSION1> SYSADMIN 24-MAR-11 08:18 <ID2>
<SESSION2> SYSADMIN 24-MAR-11 07:05 24-MAR-11 08:29 <ID1>
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
-------------- ------------ ---------------------- ------------------ ------------------
<SESSION4> SYSADMIN 24-MAR-11 08:35 <ID3>
<SESSION1> SYSADMIN 24-MAR-11 08:18 <ID2>
<SESSION2> SYSADMIN 24-MAR-11 07:05 24-MAR-11 08:29 <ID1>
<SESSION3> SYSADMIN 24-MAR-11 08:29 24-MAR-11 08:35 <ID3>
Session Number User Name Start Active Time End Active Time ORACLE Process
-------------- ------------ ---------------------- ------------------ ------------------
<SESSION1> SYSADMIN 24-MAR-11 07:05 <ID1>
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
-------------- ------------ ---------------------- ------------------ ------------------
<SESSION1> SYSADMIN 24-MAR-11 08:18 <ID2>
<SESSION2> SYSADMIN 24-MAR-11 07:05 <ID1>
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
-------------- ------------ ---------------------- ------------------ ------------------
<SESSION3> SYSADMIN 24-MAR-11 08:29 <ID3>
<SESSION1> SYSADMIN 24-MAR-11 08:18 <ID2>
<SESSION2> SYSADMIN 24-MAR-11 07:05 24-MAR-11 08:29 <ID1>
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
-------------- ------------ ---------------------- ------------------ ------------------
<SESSION4> SYSADMIN 24-MAR-11 08:35 <ID3>
<SESSION1> SYSADMIN 24-MAR-11 08:18 <ID2>
<SESSION2> SYSADMIN 24-MAR-11 07:05 24-MAR-11 08:29 <ID1>
<SESSION3> SYSADMIN 24-MAR-11 08:29 24-MAR-11 08:35 <ID3>
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |