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 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]Oracle E-Business Suite Technology Stack - Version 11.5.10.2 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.
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
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |