My Oracle Support Banner

Hyperion Financial Management (HFM) Application Missing Sequences (Doc ID 2155036.1)

Last updated on JANUARY 26, 2023

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.