Projects Create Accounting Performance Issues With 188.8.131.52 Database Version
By SherryG-Oracle on Sep 04, 2014
The PRC: Create Accounting program is run for various process categories within Oracle Projects. This program is run to create accounting entries in Oracle Subledger Accounting for accounting events created by the generate accounting events processes.
After upgrading the RDBMS version to 184.108.40.206, PRC: Create Accounting performance issues were reported due to incorrect partition statistics at the index level for the following tables:
Have you recently upgraded your database to version 220.127.116.11? Do you plan to upgrade to 18.104.22.168 in the future?
The document below provides all of the needed details to help avoid this known issue:
Performance issues on SLA tables for 22.214.171.124 Database (Doc ID:1465689.1)