User Logins And Session Timeout. Massive Archive Entries in GL_BIS_SEGVAL_INT.
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Applications Technology Stack - Version 126.96.36.199 to 10.1.2.55 [Release 9 to 10.1]
Oracle Financials Intelligence - Version 11.5.8 to 12.1.2 [Release 11.5 to 12.1]
Oracle E-Business Intelligence - Version 11.5.8 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
E-Business Intelligence - Version: 11.5.8 to 12.0.4 RUP 5 or lower
In e-Business Suite 11i, or since upgrading e-Business Suite from 11.5.x to 12.0.4 RUP 5 or lower, 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.
Database version 10.2.0.3.
Discoverer version through 10.1.2.54 & 11g
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.
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