nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

BIP Report in Oracle fusion not generating output when XML bursting is used in excel template

JayD

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

Find more posts tagged with

BI Publisher

BI Publisher Data Models

Report Layouts

Report Output

BI Publisher Report Templates

Accepted answers

All comments

Kevin M-Oracle

Use xls instead of EXCEL.

Rgds,

Kevin

JayD

Hi Kevin,

I just tried by passing value as 'xls' instead of 'excel' in TEMPLATE_FORMAT and OUTPUT_FORMAT fields. Its not working.

Regds,

Jay D

JayD

I would also like to know that first of all does XML bursting really work in excel template? Has anyone tried it?

Kevin M-Oracle

Yes it works. Did you write the Excel layout for the bursting subset of data?

What error does it give?

Rgds,

Kevin

JayD

Hi Kevin,

Thanks for your reply. I did not write the excel layout for subset of data. Can you please give me more details on writing subset of data for the XML bursting query which I've mentioned in this thread.

Thanks,

Jay D

JayD

Kevin,

I checked for the error in diagnostics and it shows as below.

[071324_163127951][][STATEMENT] [ReportProcessor]DataException rendering document:Invalid format requested: xls for [INSTANCE_JOB_ID=12793]

Although report completes in success but output file is not generated whereas only xml data is generated.

This is happening when I run the report from ESS Job. When I run the report from catalog, I'm able to get the output that is from when we click on view report button.

Kevin M-Oracle

Just to be clear, if you schedule the job as a bursting job using the Publisher scheduler it works.

If not, then the issue is likely the bursting subset of data.

The data is broken down into chunks defined by the split-by element.

If the template has a group that is not part of the split-by subset it will fail to generate output.

Rgds,

Kevin

DheerajKTribhane-Oracle

Hi Kevin,

I am also facing similar issue in seeded ESS Job calling BIP Report.

When i added a bursting query to a BIP Data model ,the ESS job is completing successfully and i can see the xml tags with values however the actual output is empty. There are groups in template but the question how can i add that in split-by subset. I mean i can add only one value from any one group. Is there any suggestion. This is for "Import Payables Invoices Report".

Thanks,

Dheeraj

Kevin M-Oracle

Hi Dheeraj,

Test the XML output for one against you layout, remove any for-loops pointing to groups that are not included in the split-by subset.

Rgds,

Kevin