My Oracle Support Banner

User Logins And Session Timeout. Massive Archive Entries in GL_BIS_SEGVAL_INT. (Doc ID 733672.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Applications Technology Stack - Version to [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
Discoverer version through & 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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.