Object Migration Fails With 'Error While Migrating Members'

(Doc ID 1578938.1)

Last updated on DECEMBER 30, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 6.x
Object Migration


In Oracle Financial Services Analytical Applications (OFSAA) 7.3, Object Migration fails when you run it to move dimension members from a source environment into a target environment.  The following error appears in the Object Migration View Log messages:

Begining to Migrate All Members for Dimension:5
Error While Migrating Members - Rolled Back All Member Migration
"Dimension Migration Error - com.ofs.reveleus.migration.util.MigrationException: ORA-00957: duplicate column name
Migration Process Stopped, As Fatal Error Ocurred While Migrating Object..[id:5,name:TP_COA_ID,type:12,folder:]
Migration Failed Because of Fatal Error

The error prevents the dimension members from being migrated from the source environment into the target environment.

Steps to Reproduce:

  1. Log into OFSAA Infrastructure
  2. Go to Administration > Utilities > Object Migration
  3. Run an Object Migration rule to transfer dimension members
  4. Review the View Log messages

The error appears in the View Log messages.


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