In Spring 2019, a transportation and shipping organization (that chooses to remain anonymous) upgraded their Office 365 to a greater version through a security patch MSO (16.0.13929.20206) 32-bit. Immediately, they noticed Web ADI did not work on their version of Oracle (11i).
Data is a crucial part of any business. The transportation and shipping organization creates multiple files and needs to load 6000 lines of data securely into Oracle EBS every day. With no access to their original data sets or ability to load information at the pace the organization was operating, this became a big problem for the business.
As a result, they had to downgrade over 30 people’s Office suite to the older version to get Web ADI to work again. This is also the case for any user who wanted to upgrade to the latest version of Excel or Oracle (r12.2) – Web ADI could not work.
According to Oracle’s blog, Web ADI for 11i can only work with Excel 2010 and no newer version. The transportation and shipping organization was fully aware that this wasn’t a viable, long-term solution as Microsoft Office continues to upgrade their software packages.
Put simply, Web ADI heavily depends on Excel. So, any update to Excel, from 2016, can cause Web ADI to fail.
Does this mean businesses are left with the painful task of rolling back IT updates and downgrading individual workstations to catch up on their data loading? Sadly, yes. Organizations have to cope with potentially unsafe workstations, which requires more time and IT support management in the process.
In the case of the transportation and shipping organization, More4apps came in and provided a much sought and sustainable solution to the Windows update – through our EBS Toolbox General Ledger (GL) Wizard.