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:Oracle Web Applications Desktop Integrator - Version 12.0.4 to 12.1.2 [Release 12 to 12.1]
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document