HFM Error: "An error occurred creating the session for application: Search of records was unsuccessful: ORA-01031: insufficient privileges" when Provisioning for Import Application (Doc ID 2226646.1)

Last updated on AUGUST 08, 2017

Applies to:

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

Symptoms

On : 11.1.2.4.202 version, Product Usage

When attempting to Import Application between DEV and UAT,
the following error occurs.

ERROR
-----------------------
"[2016-12-09T10:34:10.610+11:00] [FM] [ERROR] [EPMHFM-66031] [oracle.FM.HSXBRC.oracle.epm.fm.brc.ImportProcessor] [tid: 10] [ecid: 005GmreVXvwAPPxaw9icMG00025d00004Q,0:1:4] [SRC_CLASS: oracle.epm.fm.brc.ImportProcessor] [SRC_METHOD: importApplication] An error occurred creating the session for application: Search of records was unsuccessful: ORA-01031: insufficient privileges[[
ORA-06512: at "HYP_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 "HYP_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