When Attempting to Load Multiload Template Receive Error "Incorrect syntax near the keyword 'AND'. SELECT * From tPOVPeriod WHERE AND (PeriodKey >= <<date>>)ORDER BY PeriodKey" (Doc ID 597462.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Financial Data Quality Management - Version: 8.0.5.0.00 to 11.1.1.1.00 - Release: 8.0 to 11.1

Generic Windows

Symptoms

I am attempting to load a multiload file into FDM and am receiving the error message, "Incorrect syntax near the keyword 'AND'.
SELECT * From tPOVPeriod WHERE AND (PeriodKey >= <<date>>)ORDER BY PeriodKey".  The multiload then fails and does not check in successfully.

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