Understanding Optimal General Ledger Performance

Many functions in PeopleSoft General Ledger are run as background processes. If more than one process tries to use the same database table at the same time, contention can occur for the same row of data. This can cause rollbacks. Data retrieval can be slowed by queries on non-indexed data. This topic presents some strategies for avoiding system slowdowns.

These topics provide an overview of optimal PeopleSoft General Ledger performance and discuss how to:

• Use non-shared tables.

• Use indexes.

• Use partition IDs.

• Use Average Daily Balance (ADB) incremental calculations.

• Use business unit process groups.

• Run incremental processes.

• Optimize PS/nVision performance.