Posting Program GLPPOS runs slowly in GLPUBR after RDBMS upgrade to 220.127.116.11
(Doc ID 2212628.1)
Last updated on AUGUST 21, 2020
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 18.104.22.168, Journal Posting (GLPPOS) runs slowly in module glpubr.
Note GLPPOS After DB Upgrade to 22.214.171.124.0 or 126.96.36.199 or 188.8.131.52 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.
The Program: GL Optimizer program has been run with Yes/Yes as parameters and the Gather Schema Stats program for GL and APPS schema at 30%, and the issue remains.
If there is data in the gl_bc_packets table, ensure that the program Budgetary Control Optimizer program has also been run.
Upgraded the database to 184.108.40.206.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document