FBDI Templates Hang Excel When Using Smart View Add-in With Oracle ADF Add-in or ADFDI Gives 'External component has thrown an exception.' (Doc ID 2252521.1)

Last updated on MAY 16, 2017

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Assets - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

If using File Based Data Import (FBDI) Templates:

ACTUAL BEHAVIOR
---------------
FBDI Templates completely hang and freeze Excel after installing SmartView add-ins.

 

If using Fusion Desktop Integrator (ADFDI) sheets:

When attempting to Add Assets via spreadsheet, the spreadsheet opens to connect and once the login information is entered, the following error occurs.

ERROR
-----------------------
External component has thrown an exception.

Clicking on Details shows:

SEHException: External component has thrown an exception.
Source: mscorlib
Stack:
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.Range.set_Formula(Object value)
at oracle.adf.client.windows.excel.om.api.ExcelRange.set_CellFormula(String value)
at oracle.adf.client.windows.excel.om.api.ExcelRange.SetCellRangeReference(String formula)
at oracle.adf.client.windows.excel.common.compdef.cache.BaseTableDefCache.SetColumnOriginAddress(Int32 iCol, String originAddress)...

 

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