HCM - JDE1 (MOSC)

MOSC Banner

Recruiting - Recruiting Real Time Burst Report ([nQSError: 27045] Nonexistent column)

in HCM - JDE1 (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center