External Tier Expense Report Submission Error: Java.sql.SQLRecoverableException: Closed Connection (Doc ID 1586094.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Applications Framework - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

 Navigating to a responsibility, one receives the following error:

oracle.apps.fnd.framework.OAException: oracle.jbo.NameClashException: JBO-25001: Name temp of object type View Object already exists
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1247)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)


The fnd log shows "java.sql.SQLRecoverableException: Closed Connection" error.

In the oa core error:

13/09/16 15:37:21 java.sql.SQLRecoverableException: IO Error: Size Data Unit (SDU) mismatch
13/09/16 15:37:21 at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1025)
13/09/16 15:37:21 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
13/09/16 15:37:21 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
13/09/16 15:37:21 at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
13/09/16 15:37:21 at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
13/09/16 15:37:21 at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
13/09/16 15:37:21 at oracle.apps.icx.por.rcv.server.RcvUtil.validateDateWithLaterJOBReleaseDate(RcvUtil.java:1120)
13/09/16 15:37:21 at oracle.apps.icx.por.rcv.server.ReceiveItemsTxnVOHelper.validateDate(ReceiveItemsTxnVOHelper.java:905)
13/09/16 15:37:21 at oracle.apps.icx.por.rcv.server.ReceiveItemsTxnVORowImpl.setReceiptDate(ReceiveItemsTxnVORowImpl.java:167)
13/09/16 15:37:21 at oracle.apps.icx.por.rcv.server.ReceiveItemsTxnVOImpl.updateReceiptItems(ReceiveItemsTxnVOImpl.java:128)
13/09/16 15:37:21 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
13/09/16 15:37:21 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
13/09/16 15:37:21 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
13/09/16 15:37:21 at java.lang.reflect.Method.invoke(Method.java:597)

 

Cause

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