Oracle Reports (MOSC)

MOSC Banner

Unable to pass multiple email addresses to Bursting definition

edited Jan 7, 2025 5:09PM in Oracle Reports (MOSC) 2 commentsAnswered

Hi All,

I've created a bursting definition for a Sales Order report and output is to be delivered to individual salespersons. I have the salespersons name and email addresses in my main query and using the same in parameters section of Bursting definition. Please see below example.

SELECT
PARTY_NAME KEY,
'Detail' TEMPLATE,
'en-US' LOCALE,
'EXCEL' OUTPUT_FORMAT,
'EMAIL' DEL_CHANNEL,
'SO DETAIL REPORT' OUTPUT_NAME,
EMAIL_ADDRESS parameter1

FROM (
SELECT DISTINCT HZPAS.PARTY_NAME, jrp.EMAIL_ADDRESS
FROM
DOO_HEADERS_ALL DOHA

……………..

)

However, it shows an error that it's not a Selected expression.

Any inputs on this is greatly appreciated.

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