You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get Consolidated output using Bursting data model

Received Response
149
Views
3
Comments

Summary:

Hi Team,


I'm creating a custom email notification for overdue learning in the learning module. For that, I have built a SQL query with bursting. When I schedule the report employee is receiving multiple emails for different courses.

My concern is to get the list of courses in a single email not to trigger multiple emails based on the no of courses employees have.

Below is the query used for this:

SELECT DISTINCT

PAPF.PERSON_NUMBER as "KEY",

'notification' TEMPLATE,

'en-US' LOCALE,

'HTML' OUTPUT_FORMAT,

'EMAIL' DEL_CHANNEL,

'Overdue Learnings' OUTPUT_NAME,

'dileep.dasari@kovaion.com'PARAMETER1,

''PARAMETER2,

'Quess Corp'||' '||'eumz-test.fa.sender@workflow.mail.ap1.cloud.oracle.com'PARAMETER3,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!