My Oracle Support Banner

GL_JE_LINES: How to Manage Growth for GL_JE_LINES Data? (Doc ID 2393974.1)

Last updated on JULY 29, 2021

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
GL_JE_LINES

Goal

What is the recommendation to manage the growth of the journal liens table gl_je_lines?

There are millions of records in the GL_JE_LINES table, further on a monthly basis the data is growing by millions more records in this table.  

Minor performance issues are being experienced and considering the table growth increased performance and maintenance issues may be encountered in the future.

Solution

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
Goal
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.