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