Unable To Load Data From FDMEE To ARM (Doc ID 2099284.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

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

Note :

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.

 

 

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