Connection leaks from fnd_security_pkg.fnd_encrypted_pwd
(Doc ID 550403.1)
Last updated on FEBRUARY 27, 2018
Applies to:Oracle Application Object Library - Version 126.96.36.199 to 12.1.3 [Release 11.5 to 12.1]
Oracle E-Business Suite Technology Stack - Version 188.8.131.52 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.
***Checked for relevance on 24-Jan-2014***
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!