GLPPOS: After Database Upgrade to 184.108.40.206 or 220.127.116.11 Posting Has Poor Performance Due to SQL Plan Directives
Last updated on MAY 23, 2017
Applies to:Oracle General Ledger - Version 18.104.22.168 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 22.214.171.124 or 126.96.36.199
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