We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
21
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!