Hi @Kamalakannan Natarajan,
Welcome to the Oracle Analytics Community!
Please take a look into the following posts which might be useful.
Can we burst multiple templates in BI Publisher? — Cloud Customer Connect
Multiple attachments through BIP Bursting — Cloud Customer Connect
Hope this help.
Thank you.
@Kamalakannan Natarajan , Welcome to the Oracle Analytics Community! Thanks for your question.
A. Enabling a Report for Bursting
Prerequisite: A report defined in BI Publisher. The report data must contain an element by which the report will be split and an element by which the report will be delivered. Enabling a report for bursting consists of the following steps: 1. Open the report in Edit mode. 2. Select Bursting under the report definition. 3. Select the Enable Bursting check box. 4. Select the Split By and Deliver By elements. The Split By element is the data element from the report file that you wish to split the report by. For example, to split a batch of invoices by each invoice, you may use an element called CUSTOMER_NAME. 5. The Deliver By element is the data element from the report file by which to determine the delivery method. In the invoice example, it is likely that each invoice will have delivery criteria determined by customer, therefore the Deliver By element may be CUSTOMER_ID. 6. Select the data source for the delivery XML. The delivery XML can be sourced from the same data source as the main data set, or it can be generated from a different data source. 7. Enter the SQL query to build the delivery XML.
Parameter Mapping:- Channel = Email Parameter 1=Email address Parameter 2=cc Parameter 3=From Parameter 4=Subject Parameter 5=Message Body Parameter 6= Attachment (true/false) Note that if your output format is pdf, you must set this parameter to "true" to attach the pdf to the email Parameter 7=Reply-To The template, template format, locale, output format, delivery channel, and customer e-mail address are all specified in elements from the delivery data source and will be returned by the query. The SQL to generate the delivery XML for this example is as follows:
Note:
select distinct CUSTOMER_ID "KEY", CST_TEMPLATE TEMPLATE, TMPL_TYPE TEMPLATE_FORMAT, CST_LOCALE LOCALE, CST_FORMAT OUTPUT_FORMAT, CST_DEL_CHAN DEL_CHANNEL, CST_EMAIL PARAMETER1, '<EMAIL_ADDRESS>' PARAMETER2, '<EMAIL_ADDRESS>'PARAMETER3, 'Your Invoices' PARAMETER4, 'Hi'||CUST_FIRST_NAME||chr(13)|| 'Please find attached your invoices.' PARAMETER5, 'true' PARAMETER6, ' donotreply@nowhere .com ' PARAMETER7 from customers;
B. Scheduling a Report to Be Burst If your report has been enabled for bursting, the Schedule Report page will include a Burst Report option under the Job Properties region. Schedule the reports or run immediately by specifying it in the Time region and submit the report.
Email would be delivered to all Email addresses mentioned in PARAMETER1 and PARAMETER2 columns of SQL query.
Hope it helps!
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
