JBO-27122 Error When Attemtping to Validate Financial Close Management (FCM) (Doc ID 1513794.1)

Last updated on APRIL 09, 2017

Applies to:

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

Symptoms

When attempting to validate FCM, the following error occurs against SQL Server environments:

ERROR
-----------------------
SEVERE: AbstractWebServiceBindingComponent.dispatchRequest Unable to dispatch request to http://<http_Server>
:19000/FCC-DataModel-context-root/SOAAMService due to exceptionjavax.xml.ws.soap.SOAPFaultException: JBO-27122: SQL error during statement preparation.Statement:
SELECT TaskEO.TASK_ID AS TASK_ID,
TaskEO.TASK_NAME AS TASK_NAME,
TaskEO.AGGREGATION_PARENT AS AGGREGATION_PARENT,
TaskEO.STATUS_ID AS STATUS_ID
FROM FCC_TASKS TaskEO
WHERE TaskEO.DELETED is null
START WITH TASK_ID = ?
CONNECT BY PRIOR AGGREGATION_PARENT = TASK_ID: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'START'.

 

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