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 laterInformation 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 |