Unable To Load Data From FDMEE To ARM
Last updated on JULY 17, 2017
Applies to:Hyperion Financial Data Quality Management, Enterprise Edition - Version 18.104.22.168.100 and later
Information in this document applies to any platform.
When Executing the Data load from FDMEE to ARM , getting below error.
Message ODI-1217: Session EXPORTTOARM (129501) fails with return code 903.
ODI-1226: Step CopyRateTypes fails after 1 attempt(s).
ODI-1240: Flow CopyRateTypes fails while performing a Loading operation. This flow loads target table ARM_CURRENCY_RATES.
ODI-1228: Task SrcSet0 (Loading) fails on the target GENERIC_SQL connection ARM_DATA_SERVER.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name
1) FCM and ARM are in the same schema.
2) And query from FDM to read RCM object:
Select count(*) from arm_dataload; although FDM has rights, this will fail with a table or view does not exist.
Select count(*) from fcm.arm_dataload; this will work because the object is prefixed with the schema.
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