R12:Web ADI Performance and Out of Memory issues seen when uploading large amounts of data
(Doc ID 2506299.1)
Last updated on MAY 03, 2019
Applies to:Oracle Web Applications Desktop Integrator - Version 12.2.4 and later
Information in this document applies to any platform.
When using BNE Profile BNE: Enable OOXML Standard being set to Yes, Web ADI Performance for Create Document and Upload functionality improves as the performance does not depend on the Client PC desktop capacity, when being set. The performance for the Web ADI Upload and Create Document functionality is better when using the Middle Tier server capacity.
With this being said, if there are issues seen with the Web ADI Uploads related to Performance or Create Document taking time to build the Integrator, then you will need to look into Fine Tuning the Middle Tier's resources. If the Middle Tier is not sized correctly to handle the added functionality of the BNE Profile BNE: Enable OOXML Standard being set to Yes you can experience overall Web Server/Middle Tier Performance degradation when Server is under load.
This is mainly seen when uploading large amounts of Data in the Web ADI Integrator containing many Rows and even Columns and can occur during times of month end.
Setting Profile BNE: Enable OOXML Standard = Yes
If the profile option, BNE: Enable OOXML Standard, would be set No, testing the same amount of rows and data would not be able to upload, the desktop Excel will probably hang. Then, the cause of the problem is not that BNE: Enable OOXML Standard is set to Yes. The cause would be related to the Middle Tiers needing to be fine tuned.
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