Last updated on AUGUST 23, 2017
Applies to:Oracle Application Object Library - Version 18.104.22.168 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***
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>
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