Unable To Migrate Import Formats From FDM 11.1.2.2 To FDMEE 11.1.2.4

(Doc ID 2160814.1)

Last updated on JANUARY 18, 2018

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

While running migration getting the below Error message in ODI,

ODI-1226: Step Extract Import Format Details fails after 1 attempt(s).
ODI-1232: Procedure Extract Import Format Details execution fails.
ODI-1228: Task Extract Import Format Details (Procedure) fails on the target GENERIC_SQL connection FDMEE_DATA_SERVER.
Caused By: java.sql.BatchUpdateException: ORA-12704: character set mismatch

When executing the procedure alone directly on sql also giving the same Error.

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