ORA-00904 Error while trying to set the status to open after applying the 11.1.2.1.103 patch. (Doc ID 1452074.1)

Last updated on OCTOBER 08, 2015

Applies to:

Hyperion Financial Close Management - Version 11.1.2.1.000 to 11.1.2.1.000 [Release 11.1]
Information in this document applies to any platform.

Symptoms

When attempting to open a schedule after applying the 11.1.2.1.103 FCM patch, the schedule fails to open and the following error is thrown in the Financial Close log:

ERROR
-----------------------
[2012-04-18T16:44:00.977-05:00] [FinancialClose0] [ERROR] [] [oracle.apps.epm.fcc.model] [tid: 25] [userId: DGeorge] [ecid: 0000JR7QM0pD4i5pzO^AyW1FZnCQ00004D,0] [SRC_CLASS: oracle.apps.epm.fcc.model.applicationModule.AdminAMImpl] [APP: FINANCIALCLOSE#11.1.2.0] [SRC_METHOD: changeCurrentDeploymentStatus] JBO-27122: SQL error during statement preparation. Statement: SELECT CompositeTemplateEO.COMPOSITE_TEMPLATE_ID, CompositeTemplateEO.COMPOSITE_TYPE, CompositeTemplateEO.TEMPLATE_CONTENT, CompositeTemplateEO.TEMPLATE_NAME, CompositeTemplateEO.TEMPLATE_PATH, CompositeTemplateEO.COMPOSITE_SUB_TYPE FROM FCC_COMPOSITE_TEMPLATES CompositeTemplateEO WHERE ( ( (UPPER(CompositeTemplateEO.COMPOSITE_TYPE) = UPPER(?) ) ) AND (( ( (UPPER(CompositeTemplateEO.COMPOSITE_SUB_TYPE) IS NULL ) ) )) )[[
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT CompositeTemplateEO.COMPOSITE_TEMPLATE_ID, CompositeTemplateEO.COMPOSITE_TYPE, CompositeTemplateEO.TEMPLATE_CONTENT, CompositeTemplateEO.TEMPLATE_NAME, CompositeTemplateEO.TEMPLATE_PATH, CompositeTemplateEO.COMPOSITE_SUB_TYPE FROM FCC_COMPOSITE_TEMPLATES CompositeTemplateEO WHERE ( ( (UPPER(CompositeTemplateEO.COMPOSITE_TYPE) = UPPER(?) ) ) AND (( ( (UPPER(CompositeTemplateEO.COMPOSITE_SUB_TYPE) IS NULL ) ) )) )
at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3701)
at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:4737)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1370)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:921)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:6875)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1179)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1338)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1256)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1250)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:6809)
at oracle.apps.epm.fcc.model.applicationModule.bpel.CompositeGenerator.generateCompositeArtifacts(CompositeGenerator.java:129)
at oracle.apps.epm.fcc.model.applicationModule.DeploymentManager.changeCurrentDeploymentStatus(DeploymentManager.java:170)
at oracle.apps.epm.fcc.model.applicationModule.AdminAMImpl.changeCurrentDeploymentStatus(AdminAMImpl.java:484)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
............Error Truncated.........
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "COMPOSITETEMPLATEEO"."COMPOSITE_SUB_TYPE": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:924)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3806)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1667)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1246)
... 103 more
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: "COMPOSITETEMPLATEEO"."COMPOSITE_SUB_TYPE": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)

............Error Truncated.........

 

Changes

 The Financial Close Management (FCM) patch 11.1.2.1.103 patch was applied.

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