Connection Closed Error When Opening A Schedule, Or Updating A Task. (Doc ID 2194577.1)

Last updated on AUGUST 26, 2024

Applies to:

Symptoms

Users are unable to open a schedule, create a schedule from a template, or manipulate the status of a task in FCM

The following error is seen in the FCM UI

 The following error is seen in the FinancialClose.log:

[2016-10-17T12:35:03.305+05:30] [FinancialClose1] [ERROR] [] [oracle.apps.epm.fcc.ui] [tid: 38] [userId: fcmadmin] [ecid: 00ibQ1^PFiuFw00Fzzw0w00001B40001mL,0:1] [APP: FINANCIALCLOSE#11.1.2.0] [URI: /fcc/faces/oracle/apps/epm/fcc/ui/page/FCCDashboard.jspx] [SRC_CLASS: oracle.apps.epm.fcc.ui.bean.ErrorPopupBean] [SRC_METHOD: invokeErrorMessagebox] JBO-27122: SQL error during statement preparation. Statement: SELECT DeploymentsEO.DEPLOYMENT_ID AS SOURCE_ID, DeploymentsEO.DEPLOYMENT_NAME AS SOURCE_NAME, DeploymentsEO.OWNER_ID, DeploymentsEO.START_DATE, DeploymentsEO.END_DATE FROM FCC_DEPLOYMENTS DeploymentsEO[[
WHERE DeploymentsEO.DEPLOYMENT_ID = ? AND 'DEPLOYMENT' = ?
UNION ALL
SELECT TemplatesEO.TEMPLATE_ID AS SOURCE_ID, TemplatesEO.TEMPLATE_NAME AS SOURCE_NAME, TemplatesEO.OWNER_ID, NULL AS START_DATE, NULL AS END_DATE FROM FCC_TEMPLATES TemplatesEO
WHERE TemplatesEO.TEMPLATE_ID = ? AND 'TEMPLATE' = ? oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DeploymentsEO.DEPLOYMENT_ID AS SOURCE_ID, DeploymentsEO.DEPLOYMENT_NAME AS SOURCE_NAME, DeploymentsEO.OWNER_ID, DeploymentsEO.START_DATE, DeploymentsEO.END_DATE FROM FCC_DEPLOYMENTS DeploymentsEO
WHERE DeploymentsEO.DEPLOYMENT_ID = ? AND 'DEPLOYMENT' = ?
UNION ALL
SELECT TemplatesEO.TEMPLATE_ID AS SOURCE_ID, TemplatesEO.TEMPLATE_NAME AS SOURCE_NAME, TemplatesEO.OWNER_ID, NULL AS START_DATE, NULL AS END_DATE FROM FCC_TEMPLATES TemplatesEO
WHERE TemplatesEO.TEMPLATE_ID = ? AND 'TEMPLATE' = ?
at oracle.jbo.server.DBTransactionImpl.createPreparedStatement(DBTransactionImpl.java:3759)
at oracle.jbo.server.DBTransactionImpl2.createPreparedStatement(DBTransactionImpl2.java:512)
....................................................
at oracle.jbo.server.DBTransactionImpl.createPreparedStatement(DBTransactionImpl.java:3728)
... 74 more
## Detail 0 ##
java.sql.SQLException: Connection has already been closed.
at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:62)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:100)
at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:545)
at oracle.jbo.server.DBTransactionImpl.createPreparedStatement(DBTransactionImpl.java:3728)
at oracle.jbo.server.DBTransactionImpl2.createPreparedStatement(DBTransactionImpl2.java:512)
at oracle.jbo.server.DBTransactionImpl.createReUsePreparedStatement(DBTransactionImpl.java:5014)

Changes

 Modifications to the FinancialClose Data source in the Weblogic Console.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.