Tax Operations Not Working
(Doc ID 2496014.1)
Last updated on FEBRUARY 01, 2023
Applies to:
Oracle Hyperion Tax Provision - Version 11.1.2.4.000 and laterHyperion Financial Close Management - Version 11.1.2.4.000 and later
Information in this document applies to any platform.
Symptoms
When trying to open Governance- Tax Operations (or FCM), the following error is thrown on one of the views:
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ViewEO.APP_ID, ViewEO.CREATED_BY, ViewEO.CREATION_DATE, ViewEO.IS_SHARED, ViewEO.LAST_UPDATE_DATE, ViewEO.LAST_UPDATE_LOGIN, ViewEO.LAST_UPDATED_BY, ViewEO.OBJECT_VERSION_NUMBER, ViewEO.VIEW_DESCRIPTION, ViewEO.VIEW_ID, ViewEO.VIEW_NAME, ViewEO.VIEW_TYPE, ViewEO.VALUE_XML, ViewEO.IS_DEFAULT FROM FCM_VIEWS ViewEO WHERE ( ( (ViewEO.APP_ID = ? ) AND (UPPER(ViewEO.VIEW_TYPE) = UPPER(?) ) ) AND ( ( (ViewEO.IS_SHARED = ? ) ) OR ( (ViewEO.CREATED_BY = ? ) AND (ViewEO.IS_SHARED = ? ) ) ) )
at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3735)
at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:4730)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1612)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:1024)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7779)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1282)
..........
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
Changes
A recent upgrade / PSU application
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 |