Logging Out Of E-Business Suite Has Unusual Wait Time (30-120 seconds) For All Users
(Doc ID 2078703.1)
Last updated on FEBRUARY 23, 2023
Applies to:
Oracle E-Business Suite Technology Stack - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]Information in this document applies to any platform.
LOCKING ON FND_LOGINS WHEN LOGGING IN AND OUT WITH MULTIPLE USERS
Symptoms
- When Profile Sign-On:Audit Level is turn is set to RESPONSIBILITY at the Site Level it causes performance issues at the time of logging out when multiple users are logged in.
- Users have to wait anywhere from 35- 120+ seconds for forms to close. This is the case even when users make use of the 'logout' link.
- When the profile is not set then forms sessions close normally within a few seconds.
- Patch 20304518:R12.FND.C - LOCKING ON FND_LOGINS WHEN LOGGING IN AND OUT WITH MULTIPLE USERS may have already been applied.
SQL_ID 32czjgd3hu7zf
-------------------------------------
SELECT C_LOG.ROWID FROM FND_LOGINS C_LOG WHERE C_LOG.SPID = :B1 AND
END_TIME IS NULL FOR UPDATE SKIP LOCKED
Plan hash value: 2599260651
Changes
Sign-On:Audit Level is set to RESPONSIBILITY at the Site Level
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! |