ARM Error "ORA-00942: Table or view does not exist" When Importing from FDMEE (Doc ID 1966038.1)

Last updated on FEBRUARY 09, 2016

Applies to:

Hyperion Financial Close Management - Version 11.1.2.2.000 to 11.1.2.4.101 [Release 11.1]
Information in this document applies to any platform.

Symptoms

Account Reconciliation Manager (ARM) import from Financial Data Quality Management Enterprise Edition (FDMEE) is failing. ODI log shows the following error in the Export To Arm step:

ODI: 1228 Task Set ERPI Export Flag To true (procedure) Fails on the target GENERIC_SQL connection FDMEE_DATA_SERVER
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: Table or view does not exist

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