WEBADI Does Not Complete Upload Process, When the Number of Rows is Large (Doc ID 1125184.1)

Last updated on MAY 24, 2023

Applies to:

Symptoms

WebADI is used to download and upload data between Oracle Application tables and a viewer like Excel.
Webadi intergrators and templates determines from which Oracle Application table to download the data and then upload to product tables from Excel.A template normally consists three parts: Context, Header, and Lines.

Data Rows are downloaded and uploaded in XML stream format. The XML stream size depends on the number of lines being downloaded/uploaded, and the number of columns/attributes in each line.One integrator could have detail lines which have N number of columns.The XML stream for upload is built with in excel using VBA code. The VBA code manipulates the XML stream in a String Variable.

String size is limited by the RAM up to 2,147,483,647 bytes. A String needs 10 bytes + 2 bytes by char.
It implies the maximum XML stream can be 1,073,741,824 bytes

As an example:
JOURNALS_120 integrator 40K+ rows makes the WebADI upload to hang.

Changes

Cause

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