OFSA to OFSAA Migration Script Migrate Hierarchy Fails With ORA-01031: insufficient privileges and ORA-02289: sequence does not exist Errors (Doc ID 1562042.1)

Last updated on JULY 11, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 6.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Oracle Financial Services Asset Liability Management - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.3
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When attempting to upgrade from OFSA 4.5.39 to OFSAA 6.0, when running the fsi_util.migrate_hierarchy procedure, the following error occurs:

ERROR
ORA-01031: insufficient privileges and ORA-02289: sequence does not exist

The issue can be reproduced at will with the following steps:

1. Make sure the sequence named"FSI_HIER_NODES_SEQ" is already exists in OFSAA 6.0 database.
2. Execute below statement:
 exec fsi_util.migrate_hierarchy(dblink);

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