MRI - VBCS Excel Upload/Download - Any Hard Limit To Define The 'n No Of Rows (Doc ID 2556372.1)

Last updated on SEPTEMBER 19, 2023

Applies to:

Goal

In VBCS for file uploading we are using oj-file-picker and for downloading business object data to excel file we are using oj-ext-export-data component.

We would like to understand if there are any challenges on the data volumes.

1. By using oj-file-picker, we will be uploading csv/excel file which will read the data and internally loads this data to business objects. We need to understand if there is any limit on this that only 'n' of rows should be uploaded (or) any recommendation from Oracle to understand on performance side. For example if user uploaded csv/excel file which has 100K records. Will it have any performance issues.

2. By using oj-ext-export-data, we will be downloading business object data to excel/csv file. e need to understand if there is any limit on this that only 'n' of rows should be downloaded (or) any recommendation from Oracle to understand on performance side. For example if our business objects hold almost all 100k records then the download functionality will work as expected.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.