Thursday, December 5, 2013

WebADI Finally Works with 64bit Office Now

As mentioned in Steven Chan Blog, after years of waiting (just a couple of year actually), Oracle finally releases Patch 16399718: SUPPORT WEB ADI WITH MICROSOFT OFFICE 2010 64-BIT VERSION.  I'd tested this patch under my R12.1.3 environment, and as promised, it works!

However, it's after 2 hours of debugging and swearing.

The problem is that when any WebADI template is downloaded and opened, the embedded browser inside Excel shows the error:
java.lang.NoSuchMethodError: oracle.apps.bne.utilities.oa.BneDFFStructure.setValType(Ljava/lang/String;)V

After reverse engineering a couple of the Java classes, and searching related patches in Metalink, I found out the class BneDFFStructure is too old that I need to apply patch 14209751 to update the version of this class from
BneDFFStructure.java 120.1.12010000.2 2009/08/03 16:23:37
to
BneDFFStructure.java 120.1.12010000.4 2012/11/30 19:32:09

After the patching (along with 17322095 for Windows 8 fix), I am able to start the WebADI template under Windows 8 and Excel 2013 64-bit. Oh my god, finally my users can do their job and will not bother me to upload stuff for them again!



No comments :