Some Queries Are Causing Performance Issues in ISG

(Doc ID 2396223.1)

Last updated on MAY 08, 2018

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Performance

ACTUAL BEHAVIOR
---------------
Below queries are found to cause high load during ISG testing on UAT:
---

Query# 1 = select user_id from fnd_user where upper(user_name) = :1

Query# 2 = select function_id from fnd_form_functions where upper(function_name) = :1

Query# 3

BEGIN

    fnd_global.bless_next_init('FND_PERMIT_0006');
    FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 ,
    security_group_id=>:4 , server_id=>:5);

END;


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. AWR output shows iSG queries taking time to finish

Changes

 

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