My Oracle Support Banner

FND_ENV_CONTEXT Table Growing Large (Doc ID 375630.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Concurrent Processing - Version 11.5.8 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
 
Applications Install 11.5.8 to 11.5.10


Symptoms

FND_ENV_CONTEXT table is very large , over 1.6 million rows.
Purge Concurrent Request and/or Manager Data concurrent program runs every morning, but does not seem to purge from this table. The purge concurrent request is submitted with parameters "ALL", Age "5".

The environment has very old FND and CP source code (FND F and no recent Concurrent Processing Rollup Patch applied)

Current version of afppur.lpc is 115.22

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
Cause
Solution
References

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