I was asking for that since BIP V10. Great you've created an idea, thanks Senthilrajan.

Oracle discontinued Direct Database Query, was a good feature...rip

Actually, Oracle provides a number of system variables in BI Publisher available to SQL during run-time. There is a variable XDO_USER_REPORT_LOCALE that fits the purpose and it works in online report run, but (oops...) it is not populated during scheduled report execution. Re-opened Oracle SR...

I believe it is possible by creating custom BI Publisher (BIP) report. If you have OTBI it includes BIP on a back end so you can get practically any data that you see on UI, actually even more than that.

Please read "FusionBIPAudit" document and find the set of Oracle BIP Audit seeded reports. I believe there are plenty of information that covers all your needs. On top of that, once you got in, you can create a variety of your own reports.

It is a nice to have feature, not critical. 1. In case when it is critical, you can put into 'TO:' a distribution (mailing) list including all recipients (thoroughly tested) OR, even better, 2. Use the Bursting. When scheduled, Bursting will create in the History a separate line for every delivery and you can check any…

I didn't want just to click "thumbs-down", looks like Scott misunderstood the idea. WITH clause is available for all flavors of BI Publisher Data Models SQL for ages, somewhere from 10.9 or so. It works fine in standalone (BIPEE) and (Fusion) Cloud. In case if you're using BIP running queries on non-Oracle database, I wish…

Michelle, You've mentioned ESS, is it really Enterprise (Workflow) Scheduler Service (that what ESS is) or you meant BI Publisher Scheduler (which is BIP Scheduler, not ESS)? Because bursting, actually, works in BIP Scheduler. How would the customer know the "Process ID" to "find the corresponding output file from their…