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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

How to get Consolidated output using Bursting data model

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!