Hi All,

I've designed a BIP report using excel template as layout. I wrote XML bursting query to send the output to an email address. Observed that when I use excel template as layout, bursting query is not generating any output file. I can just see the XML tags in XML diagnostics being generated with data. But no excel output is generated. Please let me know if we can we XML bursting for an excel template layout in fusion? Also, let me know what is the equivalent table in fusion to find template details such as language, timezone, delivery channel.

Below is the XML bursting query added in the data model:

SELECT '1' KEY,
'XXCUST_NUM_REP' TEMPLATE,
'en-US' LOCALE,
'excel' TEMPLATE_FORMAT,
'excel' OUTPUT_FORMAT,
'true' SAVE_OUTPUT,
'America' TIMEZONE,
'XXCUST_NUM_REP-'||:P_REQ_NO,
'EMAIL' DEL_CHANNEL,
:P_EMAIL_ADDRESS PARAMETER1,
NULL PARAMETER2,
(SELECT Description
FROM fusion.ask_deployed_domains ad,
fnd_lookup_values flv
WHERE ad.deployed_domain_name='FADomain'
AND lookup_type = 'XXCUST_SENDER_EMAIL_BURSTING_LKP'
AND external_virtual_host = meaning
) PARAMETER3,
'XXCUST_NUM_REP-'||:P_REQ_BU PARAMETER4,
NULL PARAMETER5,
'false' PARAMETER6,
NULL PARAMETER7,
NULL PARAMETER8
FROM dual

Your input is highly appreciated.

Thanks,

Jay