R12 : WEBADI - Performance Issue when Uploading Journal through WEBADI due to Multiple Calls to the GL_SECURITY_PKG.INIT Package
Last updated on SEPTEMBER 21, 2017
Applies to:Oracle General Ledger - Version 12.1.1 and later
Oracle Web Applications Desktop Integrator - Version 12.1.1 and later
Information in this document applies to any platform.
There are performance issues when uploading journals through WEBADI, or performance issues when selecting the responsibility from the list of values.
There are multiple re-occurrence of these following statements in FND log (enabled at USER level)
PLSQL.FND.SECURITY.INIT.FND_INITIALIZATION_PKG 2 Entering Fnd_Product_Initialization.ExecInitFunction 1345674455 1000302 10/03/2012 14:10:49
PLSQL.FND.SECURITY.INIT.FND_INITIALIZATION_PKG 2 The current Apps and Context condition is(SQLGL,'APPL'_'RESP'_'USER') 1345674455 1000302 10/03/2012 14:10:49
PLSQL.FND.SECURITY.INIT.FND_INITIALIZATION_PKG 1 Start fetching init_function for product SQLGL 1345674455 1000302 10/03/2012 14:10:49
PLSQL.FND.SECURITY.INIT.FND_INITIALIZATION_PKG 1 Calling initialization routine: GL_SECURITY_PKG.INIT 1345674455 1000302 10/03/2012 14:10:49
fnd.profiles.Profiles 2 getProfileOptionValue: name=ORG_ID; levelID=10003; levelValue=55344; levelValueApplID=101 13456744551000302 10/03/2012 14:11:04
This is causing a performance issue while uploading journals. These calls were made several times when uploading lines to gl_interface table.
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