How to output to excel from UBE?

[Andrew2009]

Here's my requirements. I have records in F44H501 and there are different types of individuals in there like brokers and agents. I want to put brokers on one sheet of excel and agents on another sheet. On each sheet, I want to group by an individual and list their commissions and sales and totals below it.

I want the output to be in excel from my UBE. So in my Report Definition I'll select Excel as output. How do I place the report variables in the UBE to get what I need to do above please? I've never output to excel before. Do you have a tutorial how to do this?


Thanks
JDE 9.1

 

[johndanter]

Ask this in the BI section.
Someone there may know the answer.

https://docs.oracle.com/cd/E28280_01/bi.1111/e22254/create_excel_tmpl.htm#BIPRD3377