HFM Import Application Feature Fails with Error "ORA-06512" and "ORA-01031: insufficient privileges" (Doc ID 2233201.1)

Last updated on FEBRUARY 21, 2017

Applies to:

Hyperion Financial Management - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

Attempting to use the 'Import Application' feature to copy a Financial Management application from a previous major release (non-11.1.2.4) environment into a 11.1.2.4 release environment.  The following errors are captured in the BRC logs located in the Financial Management Application Server (i.e. EPM_ORACLE_INSTANCE\diagnostics\logs\hfm).


 ERRORS
 -----------------------
 ORA-06512: at "HFM.HFMUTIL_PKG", line 843
 ORA-06512: at line 1
 .. oracle.epm.fm.dal.exception.DALException: Search of records was unsuccessful: ORA-01031: insufficient privileges
 ORA-06512: at "HFM.HFMUTIL_PKG", line 843
 ORA-06512: at line 1
 . at oracle.epm.fm.dal.dao.BRCEntityDAOImpl.executeImportApp(BRCEntityDAOImpl.java:301)
 at oracle.epm.fm.dal.manager.BRCDataBaseManagerImpl.executeImportApp(BRCDataBaseManagerImpl.java:80)
 at oracle.epm.fm.brc.ImportProcessor.importApplication(ImportProcessor.java:38)
 at oracle.epm.fm.brc.BRCManager.importApplication(BRCManager.java:245)
 at oracle.epm.fm.brc.BRCServer.importApplication(BRCServer.java:313)
 at oracle.epm.fm.brc.BRCServer.main(BRCServer.java:161)
 Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
 ORA-06512: at "HFM.HFMUTIL_PKG", line 843
 ORA-06512: at line 1

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