Hyperion Financial Management (HFM) (MOSC)

MOSC Banner

Error while running HFM SequenceFix.sql utility

edited Mar 29, 2017 12:59PM in Hyperion Financial Management (HFM) (MOSC) 2 commentsAnswered

I am using HFM 11.1.2.4.202 . I use import application utility/option in Consolidation administration to synchronize applications between production and test environment.Post importing I get application errors for which oracle has confirmed that I need to run the SequenceFix.sql utility to fix the sequence issue.

But when I run the utility in sqlplus using the HFM Schema login I get below error

strApp := UPPER(strAPP);

        *

ERROR at line 24:

ORA-06550: line 24, column 8: 

PLS-00103: Encountered the symbol "=" when expecting one of the following: 

constant exception <an identifier> 

<a double-quoted delimited-identifier> table long double ref 

char time timestamp interval date binary national character 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center