Posting Program GLPPOS runs slowly in GLPUBR after RDBMS upgrade to 22.214.171.124
Last updated on MARCH 08, 2017
Applies to:Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
After the database has been upgraded to database version 126.96.36.199, Journal Posting (GLPPOS) runs slowly in module glpubr.
Note GLPPOS After DB Upgrade to 188.8.131.52.0 or 184.108.40.206 or 220.127.116.11 Posting Program Has Poor Performance Stuck in Glpubr Module (Doc ID 1602141.1) was followed and appropriate patches applied and workaround attempted and this has not changed the behavior.
Have run the Program: GL Optimizer program with Yes/Yes as parameters and the Gather Schema Stats program for GL and APPS schema at 30%, and the issue remains.
Upgraded the database to 18.104.22.168.
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