Connection leaks from fnd_security_pkg.fnd_encrypted_pwd (Doc ID 550403.1)

Last updated on AUGUST 23, 2017

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Oracle E-Business Suite Technology Stack - Version 12.2 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.
This problem can occur on any platform.
***Checked for relevance on 24-Jan-2014***

Symptoms

There are lots of idle database connections coming from APPLSYSPUB user.

select s.sql_hash_value, t.sql_text, s.last_call_et
from v$session s , v$sqltext t
where s.username = 'APPLSYSPUB'
and s.sql_hash_value= t.hash_value
and t.sql_text like  '%fnd_security_pkg.fnd_encrypted_pwd%';


These connection leaks are NOT reported in ""AOL/J Database connection pool status" page.

Last SQL executed shows :

    BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5,:6,:7,:8); END;

or

    BEGIN fnd_security_pkg.fnd_encrypted_pwd(:1,:2,:3,:4,:5); END;

 

Changes

For R11i problem started after 11i.ATG_PF.H.RUP6 <Patch 5903765> .
For R12 problem started after Oracle E-Business Suite 12.0.2 Release Update Pack (RUP2) <Patch 5484000>

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