BIP bursting email BCC parameter list

Yogen

Summary

BIP bursting email BCC parameter list

Content

We are using BIP for bursting and sending multiple files to multiple email addresses. All email addresses are used in parameter 8 (BCC) in bursting query. However in the report job history in BIP,  is not showing BCC parameter list so we doesn't have a way to verify what email list was used by the BIP report at the time of execution. We are using a dynamic list of email addresses and for business reasons we cannot put email address list in To or CC list of the email address.

How can we find what was the value of parameter 8 (i.e. BCC email list) at the time of report execution?

Many thanks in advance.

User910243567

One way i can think of is to generate an XML tag for the parameter8. Which you can refer after report is run.

eg: In your query

Select col1, col2, : parameter8 col3 from dual;

<col3>xyz@gmail.com </col3>