Hyperion Financial Management (HFM) Application Missing Sequences

(Doc ID 2155036.1)

Last updated on AUGUST 18, 2017

Applies to:

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

Symptoms

HFM application logs contain error "ORA-02289: sequence does not exist".


Missing sequences will cause application tasks to fail until sequences are recreated.

 

Changes

There are and have been several product defects covering several HFM versions where Sequences are found to be missing. Most common causes are a problem running the HFM copy utility, the Application Import Feature (introduced in 11.1.2.4.200). DBA attempting to manually copy HFM applications also usually results in missing sequences.

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