TimeCardHome.jsp and TimeCardLogout.jsp generates leak connections in 12.1.3

Leaks are being generated by timecard, the AOL-J JDBC Pool Status shows many leaked connections like:

oracle.apps.fnd.security.LeakedConnectionException 3, 0x73ebd7, 2011-04-18+06:57:47.199+0100, Thread[AJPRequestHandler-ApplicationServerThread-5,5,RequestThreadGroup]
at oracle.apps.fnd.security.CallStack.getInstance(CallStack.java:109)
at oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:981)
at oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:964)
at oracle.apps.fnd.common.Pool.costBasedSelection(Pool.java:1885)
at oracle.apps.fnd.common.Pool.selectObject(Pool.java:1686)
at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:950)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:583)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:297)
at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1719)
at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2305)
at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2242)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2100)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1910)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1754)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1767)
at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1453)
at _TimecardLogout._jspService(_TimecardLogout.java:214)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:610)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:359)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)


Verified Application leaked connections System administration->Diagnostic-> AOL J/ database connection Pool-> Leaked connections and found more than 400 connections are leaking.

Cause is The lock on the timecard still persists when the user clicks on Home from the create timecard page directly without submitting the timecard.

Solution:


Applications R12.1
To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for 12382630:R12.HXT.B DB CONNECTION LEAKS ON TIMECARDHOME.JSP.
No password is require to download this patch.

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:
html/TimecardHome.jsp 120.0.12010000.4
html/TimecardLogout.jsp 120.1.12010000.2


You can use the commands like the following:
SQL> select f.filename,f.subdir,ver.version, ver.*, f.*
from ad_file_versions ver, apps.ad_files f
where f.file_id = ver.file_id
and f.filename like 'TimecardHome%'
SQL> select f.filename,f.subdir,ver.version, ver.*, f.*
from ad_file_versions ver, apps.ad_files f
where f.file_id = ver.file_id
and f.filename like 'TimecardLogout%'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.

http://allappsdba.blogspot.in/