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

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

Find more posts tagged with

Accepted answers

All comments

Kevin M-Oracle

Do you have two iterations of G_ORG?

Do you get an error?

FYI: Please do not upload the XML data.

Thx,

Kevin

Suresh Ramanujam

On the XDO_METADATA tab I did

Version
ARU-dbdrv
Extractor Version
Template Code
Template Type	TYPE_EXCEL_TEMPLATE
Preprocess XSLT File
Last Modified Date
Last Modified By	ABCD

Data Constraints:
XDO_MARKUP_?	false
XDO_SHEET_?	<?.//G_SUPPLIER_INDEX?>
XDO_SHEET_NAME_?	<?.//SUPPLIER_INDEX?>

Since I was using the supplier name as the Main Index I did this in the DM

end as Supplier_Name,
CASE
WHEN hp.party_name = 'ZZZZZ' THEN 'ZZZZ'
WHEN SUBSTR(hp.party_name,1,1) BETWEEN '0' AND 'E' THEN 'Suppliers 0-E'WHEN SUBSTR(hp.party_name,1,1) BETWEEN 'F' AND 'L' THEN 'Suppliers F-L'WHEN SUBSTR(hp.party_name,1,1) BETWEEN 'M' AND 'S' THEN 'Suppliers M-S'ELSE 'Suppliers T-Z'
END
SUPPLIER_INDEX

Kevin M-Oracle

What was the result?

Kevin