Inquiry Regarding Dynamic User Inclusion in Report Emails via Bursting

Summary:

Hi Oracle Experts,

We have received a request from our users to include the username of the individual executing a report in the email body after the "Thanks" section within the bursting logic. This inclusion should occur dynamically whenever a report is executed, whether through a scheduling job or an ESS job.

Could you please confirm if this is feasible? We attempted to implement it using the following SQL, but it did not yield the desired results.

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT
q1.c_q2_delivery_id AS "KEY",
'MT PackingSlip Report' AS TEMPLATE,