My Oracle Support Banner

Script to Create Dynamically the Recommended Concatenated Indexes GL_CODE_COMBINATIONS_CAT on GL_CODE_COMBINATIONS and GL_INTERFACE_CAT ON GL_INTERFACE (Doc ID 2719574.1)

Last updated on DECEMBER 10, 2024

Applies to:

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

Goal

According to this document: R12: Improving Performance of General Ledger and Journal Import (Doc ID 858725.1)
F.1) Indexes for GL_CODE_COMBINATIONS
F.2) Indexes for GL_INTERFACE
the GL_CODE_COMBINATIONS_CAT index must be defined on the GL_CODE_COMBINATIONS table in order to improve the overall performance of General Ledger module.
This index affects all processes and programs that use code combinations.

The document offers the steps needed to define the index dynamically, based on the setup and usage frequency of the segments on your instance.

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.