R12 : WEBADI - Performance Issue when Uploading Journal through WEBADI due to Multiple Calls to the GL_SECURITY_PKG.INIT Package (Doc ID 1514899.1)

Last updated on FEBRUARY 11, 2016

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.

Symptoms

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.

Cause

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