Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
BI Publisher report with cashing multi-million records query and staggered upload to FTP — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI Publisher report with cashing multi-million records query and staggered upload to FTP

Received Response
26
Views
2
Comments
edited Feb 3, 2021 5:11PM in Reporting and Analytics for ERP 2 comments

Summary

BIP Maximum Rows for CSV output limit is 2 million. need elegant solution to query database only once for bigger record count and then have staggered upload of records to destination folder

Content

Is it possible for BI Publisher to run SQL query for data set larger than 2m records, cache results, and then produce multiple CSV outputs with 2m records each until whole data set is processed?

 

there is documented feature in Fusion Applications Release 13 and later that allows to directly generate a CSV output from an SQL query without the intermediate step of generating XML data, but it is limited to 2 million records.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!