Oracle R12.1.3 XML Publisher XLS Template

Djon

Summary

Oracle R12.1.3 XML Publisher XLS Template

Content

Hi,

 

We have patched Oracle R12.1.3 to allow XML Publisher XLS Template.

And followed BI Publisher: How to create Multisheet in Single Excel file using Excel Template (Doc ID 1352000.1)

The template works and can generate multiple sheet in run time.

Now the user want to add a "static/fixed sheet", a kind of summary.

Like:

Summary Sheet > Supplier Site 1 Sheet > Supplier Site 2 Sheet > Supplier Site 3 Sheet > Supplier Site 4 Sheet > ... > Supplier Site N Sheet >

 

Is it possible?

is there any documentation that explain this?

Djon

We already have that in the template.

Now I want it to generate add 1 fixed sheet.

The goal is to have 1 fixed sheed and N dynamic sheet.

Brajesh Shukla-95078

You mean to say you want each supplier site data in different tab?

If this is your requirement then you can achieve this by below step

1. Specify XDO_SHEET_? group name. By specifying group on this excel will generate those many tabs. e.g. in your case you want separate tab for each supplier site.

2. Specify XDO_SHEET_NAME_?. By specifying this name will generate for each tab. in the above example tab name will be name of the supplier site.

Regards,

Brajesh

Djon

Thank you Brajesh, I will try your suggestion.

Before I read your reply I had added the sheet name in column C,  it works in BIPublisher Excel Plugin.

However, when I uploaded the template into eBS, the summary sheet also repeated N times, probabbly the server component is not certified with that feature.

I didn't pay attention on the scope, so I will rebuild the template using you suggestion.

Brajesh Shukla-95078

The goal is to have 1 fixed sheed and N dynamic sheet. : What is the issue? we can create one fix sheet and then in new tab we can create sheet for which we can define XDO_SHEET_?  and XDO_SHEET_NAME_? property

only thing is while defining the name space provide the scope of the field as below

Djon

I managed to create a proof of concept RTF template, and when previewed in Word BIPublisher Plugin as "Excel", the output is splitted into multiple sheets.

However, when I upload the template into the server, the output is combined into one, the same behaviour as in the Word Plugin when "Excel2000" preview is used.

The document mentioned the output must be in XLSX format, how I configure this?

Djon

I found EBS (BI Publisher) R12 : How To Get Excel Output In Multiple Worksheets From A RTF Template (Doc ID 2004454.1), according to which R12.1.3 is compatble.

The challenge is, how to make it dynamic, because the number of sheets is not predetermined.

Djon

I modified the scope, unfortunately it doesn`t change the situation. The Summary sheet is renamed and repeated N times, no rows displayed, which is logic because it uses different group.

Brajesh Shukla-95078

Could you please upload your excel and sample XML please...will try in both Desktop plugins as well as EBS...to find out if its version issue between instances if this is the case we need to raise SR with oracle support to get correct version. But before that we want to sure its version issue

Djon

I read some replies from Oracle staffs about the same issue on this forum, it seems the feature is not available on 12.1.3. I need to sanitize the data before I could upload the sample and template, so it will take some time.

user13173266

Images are not visible.