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 FEBRUARY 22, 2021

Applies to:

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

Goal

 You want improve the performance to create the  GL_CODE_COMBINATIONS_CAT on GL_CODE_COMBINATIONS according to below section/note and also GL_INTERFACE_CAT ON GL_INTERFACE.

F.1) Indexes for GL_CODE_COMBINATIONS

F.2) Indexes for GL_INTERFACE

 

R12: Improving Performance of General Ledger and Journal Import (Doc ID 858725.1)

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
 F.1) Indexes for GL_CODE_COMBINATIONS
 F.2) Indexes for GL_INTERFACE
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.