Recruiting - Recruiting Real Time Burst Report ([nQSError: 27045] Nonexistent column)
Hello,
Using Oracle HCM Recruiting - Recruiting Real Time Subject Area, am trying to do a simple burst report.
I receive the below error message when validating the bursting SQL:
java.io.IOException: prepare query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 27045] Nonexistent column: "Job Requisition - Basic Information"."Job Requisition Number".
Bursting SQL Snippet:
SELECT
"Job Requisition - Basic Information"."Job Requisition Number" AS "KEY"
, 'XXXXX' AS TEMPLATE
, 'en-UK' AS LOCALE
, 'EXCEL' AS OUTPUT_FORMAT
, 'EMAIL' AS DEL_CHANNEL
, XXXXX' AS OUTPUT_NAME
, 'XXX@XXXXX.co.uk' AS PARAMETER1
, 'XXX@XXXXX.co.uk' AS PARAMETER3
, 'Please find report attached' AS PARAMETER5