Fdm Import Problem: Data Access Error "Incorrect syntax near ')'."

(Doc ID 1331729.1)

Last updated on AUGUST 01, 2016

Applies to:

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

Symptoms

The following error is seen when running an ERPI data rule via FDM - the same rule works when being run in ERPI. There are lots and lots of rows under the error and at least two 'Required Field Missing' entries per row.
Begin FDM Runtime Error Log Entry [2011-06-17-14:05:23] **

-------------------------------------------------------------

ERROR:

Code............................................. -2147217900

Description...................................... Incorrect syntax near ')'.

Data file has been created in te Application inbox folder

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