GLPPOS: After Database Upgrade to or Posting Has Poor Performance Due to SQL Plan Directives

(Doc ID 2068068.1)

Last updated on MAY 23, 2017

Applies to:

Oracle General Ledger - Version to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
Executable:GLPPOS - Posting


Using Oracle General Ledger (GL), posting has performance issues.
Postings which completed in a reasonable time are taking much longer to complete after the database upgrade.

The issue can be reproduced at will with the following steps:
1. Upgrade database to 12.1.0.N release.
2. Run GL Posting Process.


 Database upgraded from earlier version to or


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms