User Logins and Session Timeout, Unable to Log in or Performance Issues Reported Along with Massive Entries in GL_BIS_SEGVAL_INT
(Doc ID 733672.1)
Last updated on NOVEMBER 28, 2022
Applies to:
Oracle Financials Intelligence - Version 11.5.8 and laterOracle E-Business Intelligence - Version 11.5.8 and later
Oracle E-Business Suite Technology Stack - Version 9.2.0.8 to 10.1.2.55 [Release 9 to 10.1]
Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.
E-Business Intelligence - Version: 11.5.8 to 12.0.4 RUP 5 or lower
Symptoms
In e-Business Suite 11i, or since upgrading e-Business Suite from 11.5.x to R12, users' sessions have been timing out and archive logs filling up when being written to from the GL_BIS_SEGVAL_INT temporary table. As a result, the instance has ground to a halt.
Additional issues reported: unable to login or performance issues.
STEPS TO REPRODUCE (sample, as the symptoms may vary from one instance to another):
- As EBS user, attempt to login to Oracle Applications
- Observe this is not possible as the page takes a large amount of time to show up
- System Administrator - observe that table GL.GL_BIS_SEGVAL_INT generates a lot of archive redo
Changes
Events which can trigger this issue have included but are not restricted to:
E-Business Suite upgrade from 11.5.x to 12.x.
Database upgrade from 9i to 10g or later.
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 |
| Changes |
| Cause |
| Solution |
| References |