My Oracle Support Banner

Connection leaks from fnd_security_pkg.fnd_encrypted_pwd (Doc ID 550403.1)

Last updated on MAY 07, 2023

Applies to:

Oracle Application Object Library - Version to 12.1.3 [Release 11.5 to 12.1]
Oracle E-Business Suite Technology Stack - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
This problem can occur on any platform.


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;


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



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>


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.