Unable To Migrate Import Formats From FDM To FDMEE

(Doc ID 2160814.1)

Last updated on JANUARY 18, 2018

Applies to:

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


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.


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