Tuesday Dec 29, 2015

GL Posting Performance After Database Upgrade to 12.1.0.1 or 12.1.0.2? Patch Available!

Posting journal entries in General Ledger is the last step of the accounting cycle, transferring these entries in a final state to update GL balances and locking them for further updates. This is the main GL process that will afterwards support Reporting on the balances, Translation, Consolidation and other business specific processes. As Posting is very common activity in GL, it is very important that the concurrent requests run with reasonable performance.

Posting bad performance was reported after Database Upgrade to 12.1.0.1 or 12.1.0.2. A higher parse time than 11g may be seen in 12c for a complex query with a multi-table join with SQL plan directives enabled.

Database Patch 20807398 is now available to fix this for you!

Did you upgrade the Database to the mentioned versions recently?

Proactively review this document today, before the users get to report performance issues:

GLPPOS: After Database Upgrade to 12.1.0.1 or 12.1.0.2 Posting Has Poor Performance Due to SQL Plan Directives (Doc ID 2068068.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
« June 2016
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
10
11
12
16
17
18
19
20
22
24
25
26
29
30  
       
Today