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)


Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected

Twitter

Search

Archives
« April 2015
SunMonTueWedThuFriSat
   
4
5
6
11
12
15
18
19
20
21
22
23
24
25
26
27
28
29
30
  
       
Today