My Oracle Support Banner

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 later
Hyperion 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:

[2019-01-04T11:11:49.224-05:00] [TaxManagement0] [ERROR] [] [oracle.apps.epm.taxop.model] [tid: 15] [userId: admin] [ecid: 00irJdfSM^C6YN15zvt1iW0001Ik0001XM,0:1] [APP: TAXOPERATIONS#11.1.2.0] [SRC_CLASS: oracle.apps.epm.fcm.common.model.applicationModule.CommonManagementAMImpl] [SRC_METHOD: getSavedViews] 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 = ? ) ) ) )[[
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


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