HFM Error "Cannot drop the table 'HSV_ACTIVITY_USERS', because it does not exist ..." When Creating a New Application (Doc ID 1964971.1)

Last updated on JANUARY 20, 2017

Applies to:

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

Symptoms

Creation of a new hyperion Financial Management (HFM) application fails and the following error message is logged in hfm.odl.log:

Cannot drop the table 'HSV_ACTIVITY_USERS', because it does not exist or you do not have permission.] [paramString: ] Table does not exist.

Windows Event Log this error is logged:

CREATE TABLE permission denied in database 'HFM'

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