Optimizing Budget Processor Performance

Before running budget processor, there are database properties that Oracle recommends that your database administrator modify and indexes that you should create to improve budget processor performance. The database changes and indexes depend on the source transactions that you feed into budget processor.

This section discusses how to:

  • Optimize performance for all source transactions.

  • Optimize performance for PeopleSoft Cost Management transactions.

  • Optimize performance for PeopleSoft Purchasing.

  • Optimize performance for PeopleSoft Vouchers.

  • Optimize performance for PeopleSoft General Ledger transactions.

See also PeopleTools: PeopleSoft Application Designer, "Building SQL Tables and Views," Administering Data, Creating Indexes