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

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Applications Technology Stack - Version 9.2.0.8 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


Symptoms

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

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.

Cause

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