Additional Use Case and Business NeedThis feature is needed in order for us to audit any execution of BIP reports, not only via the scheduler.

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.

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.

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.

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…

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…

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.