Hyperion Financial Management (HFM) Application Missing Sequences

(Doc ID 2155036.1)

Last updated on AUGUST 18, 2017

Applies to:

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


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

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



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 DBA attempting to manually copy HFM applications also usually results in missing sequences.


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