Syntax error for Bursting to WCC

Rrpai-Oracle

I get syntax error when bursting to WCC from Fusion Apps → BIP

In Data Model → Validate goes fine

In sql developer the sql snippet doesnt show any error .

Not able to understand what exactly is the syntax error.

Please comment

—

[nQSError: 27002] Near <->: Syntax error [nQSError: 26012] .
oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo.XDOException: java.sql.SQLException: java.io.IOException: prepare query failed[nQSError: 43113] Message

—

SELECT DISTINCT
"Created By" AS "KEY", -- Split Key from data model SQL
'PDF' output_format, -- Output type
'WCC' del_channel, -- To send to content server
'FA_UCM_PROVISIONED' parameter1, -- Content Server name
'Attachments' parameter2, -- Security group
'TestAuthor' parameter3, -- Author of the file to be shown in content server
'' parameter4, -- Account (Optional)
'Test_Burst' parameter5, -- Title
"Created By" || '.pdf' parameter6, -- Output File name
'Test' parameter7, -- comments
"Created By" parameter8, -- Content ID (Optional)
'false' parameter9, -- Custom metadata (Optional)
'/Users/FAAdmin' parameter10 -- Folder path to deliver files
FROM
"Service - CRM Service Requests Real Time"."Service Request"

—

FA version
11.13.24.04.0_00.0.00

Oracle Analytics Publisher
12.2.6.1.10

—

Rrpai-Oracle

I resolved this . The issue was it doesnt accept comments in the query.

ie eg

— comment