X

Review EBS product's new releases & features, troubleshooting tips & tricks, best practices, upcoming webcasts

Projects Create Accounting Performance Issues With 11.2.0.3 Database Version

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 11.2.0.3, PRC: Create Accounting performance issues were reported due to incorrect partition statistics at the index level for the following tables:

  • XLA_TRANSACTION_ENTITIES
  • XLA_EVENTS
  • XLA_AE_HEADERS
  • XLA_AE_LINES
  • XLA_DISTRIBUTION_LINKS

Have you recently upgraded your database to version 11.2.0.3?  Do you plan to upgrade to 11.2.0.3 in the future?

The document below provides all of the needed details to help avoid this known issue:

Performance issues on SLA tables for 11.2.0.3 Database (Doc ID:1465689.1)


Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.