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

Last updated on JULY 27, 2017

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

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms