My Oracle Support Banner

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

Last updated on FEBRUARY 07, 2024

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
EXECUTABLE:GLLEZL - Journal Import
EXECUTABLE:GLAMAS - Run MassAllocations
EXECUTABLE:GLPPOS - Posting

Purpose

Description of the setup and procedures to improve R12 General Ledger Performance.

Scope

These changes can benefit also the performance of other modules that use GL data.

Some actions are to be performed by functional users, but others may require the assistance of a DBA or System Administrator.

Details

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
Purpose
Scope
Details
 A) Database Init.ora Parameters
 B) Concurrent Program Controls setup
 C) General Ledger Optimizer program
 C.1) To create and drop indexes for your chart of accounts segments:
 C.2) To update statistical information about your data:
 D) Useful hints
 E) Database Cost Based Optimizer (CBO)
 F) Indexes optimization
 F.1) Indexes for GL_CODE_COMBINATIONS
 F.2) Indexes for GL_INTERFACE
 F.3) Custom Indexes
 G) Multi-Table Journal Import
 Community Discussions
 Feedback
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.