Tuesday Nov 25, 2014

Testing Your EBS Environment After Database Upgrades

If you're thinking about upgrading your EBS database then you'll have questions about what impact that may have on your EBS environment.  Customers often ask, "What should I test after I upgrade my EBS database?"

Take a look at what EBS Development recommends when doing your database upgrade, with guidance as to what testing you should consider: Testing Your EBS Environment After Database Upgrades.

Thursday Sep 04, 2014

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)


Tuesday Jul 01, 2014

Posting Performance Issues Reported After 11.2.0.4 Database Upgrade

Posting is the main General Ledger process that updates the account balances for detail and summary accounts. As the program is submitted multiple times almost every day and the volume of data processed by this concurrent request is sometimes huge, getting a good performance for each run is crucial for having up-to-date balances available for reporting purposes at any moment. 

After upgrading RDBMS to 11.2.0.4, Posting performance issues were reported due to a new optimizer feature introduced for Database. Posting uses a bad execution plan and might get severe performance issues or simply hang at glpubr.concurrency procedure: 

Posting Logfile

Did you upgrade to RDBMS 11.2.0.4 recently? Do you plan to upgrade?

Ensure proper application usage for your users through a proactive patching plan!

This recently updated document provides all the needed details to help avoid a known issue: 

GLPPOS Poor Performance after DB Upgrade to 11.2.0.4.0: Program Stuck on Glpubr.Concurrency (Doc ID 1602141.1)

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
« May 2015
SunMonTueWedThuFriSat
     
1
2
3
4
5
7
9
10
11
16
17
18
22
23
24
25
27
29
30
31
      
Today