Could please let me know I have only one group how to split into multiple sheets in oracle EBSR12

User_BG3UK

We are developed new xml report in EBS R12(12.2.9) with xls template ,issue with report is after reaching 65k records xls template not supporting and we did the setup in data template for more than 65k records but still issue not fixed. 
Could you please any one help on report when data is getting more than 65k need to populate another tab / any other solution .

Thanks ,

Dhanunjaya Reddy

Capture.PNG

log.txt

Sumanth V -Oracle

@User_BG3UK - If you are using BIP 12.2.1.4 and above, please try the solution mentioned in below documentation:

XSL Splitting the Data by Count of Rows not Splitting Data Into Multiple Excel Sheets (Doc ID 2451648.1)

Mallikarjuna Kuppauru-Oracle

Hi @User_BG3UK

As per your log file i saw out of memory Error. Please check below MOS doc to fix the same.

XML Publisher Report Bursting Program Fails With java.lang.OutOfMemoryError (Doc ID 2991473.1)

Regards,

Arjun

Mallikarjuna Kuppauru-Oracle

Hi @User_BG3UK

Any update on this Thread? If you think any of us answered your quesiton ,please mark it as Answered.

Regards,

Arjun

User_BG3UK

Hi Mallikarjuna Kuppauru,

Not work out

Thanks,

Dhanunjaya Reddy

Kevin M-Oracle

EBS Excel layouts cannot split by row number, the templates have to be split by group.

A new tab for every iteration.

Kevin

User_BG3UK

Hi Kevin

Could please let me know I have only one group how to split into multiple sheets in oracle EBSR12 after reaching records count 65k.

If you share with example its more helpful

Thanks

Dhanunjaya Reddy

Kevin M-Oracle

You cannot split by count in EBS.

You have to split by a group, for example: for-each G_1.

Kevin

User_BG3UK

Hi Kevin,

I just split one group query into two groups please find attached example and could you please let me know how to group in xls template

Thanks,

Dhanunjaya Reddy

Capture1.PNG

Kevin M-Oracle

See: Splitting Data from Reports into Multiple Sheets

https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-F926959D-B7A5-41DE-8388-2951666A38EE.htm#GUID-30710EE5-ED97-4489-8E48-642BCACD1837

Kevin

User_BG3UK

Hi Kevin,

I created 2 groups in query after that created xls template as per creating template excel link but not working please find attached xls template

Thanks,

Dhanunjaya Reddy

Test1.xls