'ComponentWriteDataToSheetErrorException: ADFDI-05581' AP Spreadsheet Import Errors After Entering Business Unit in AP Spreadsheet. (Doc ID 1623290.1)

Last updated on OCTOBER 02, 2016

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.1.5.0.0 and later
Oracle Fusion Payables - Version 11.1.1.5.1 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.7.0 version, Manage Invoices-Receive and Process Invoices

AP Spreadsheet Import Errors

Receive error below after entering business unit in AP spreadsheet.

ERROR
-----------------------

ADFDI-05581: Unable to write component data into worksheet: TAB2140269804
Exception from HRESULT: 0x800A03EC

ComponentWriteDataToSheetErrorException: ADFDI-05581: Unable to write component data into worksheet: TAB2140269804
Source: adfdi-excel-runtime
Stack:
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableDownloadHelper.FlushDataToSheet()
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableDownloadHelper.Download()
  at oracle.adf.client.windows.excel.runtime.uicomponent.RTTableComponent.DownloadTableData(DownloadType downloadType)
  at oracle.adf.client.windows.excel.runtime.uicomponent.RTDataEntryGrid.DownloadForInsert(RTActionCollection actionSet)
  at oracle.adf.client.windows.excel.runtime.uicomponent.RTDataEntryGrid.Invoke(RTComponentAction rtAction)
  at oracle.adf.client.windows.excel.runtime.uicomponent.RTComponentAction.Invoke()
  at oracle.adf.client.windows.excel.runtime.uicomponent.RTActionCollection.DoInvoke(RTColumnCollection parent)
Inner:
COMException: Exception from HRESULT: 0x800A03EC
Stack:
  at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
  at Microsoft.Office.Interop.Excel.Validation.Add(XlDVType Type, Object AlertStyle, Object Operator, Object Formula1, Object Formula2)
  at oracle.adf.client.windows.excel.om.api.ExcelRange.ConstrainListToNamedRange(String rangeName)
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableOptimizationsHelper.ConstrainLists()
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableDownloadHelper.FlushDataToSheet()

STEPS
-----------------------
1) N > Payables > Invoice Workbench
2) Click on Create Invoice in spreadsheet
3) Spreadsheet downloads
4) Enter credentials
5) Content is downloaded to spreadsheet
6) Enter Business Unit
7) tab to next field
8) Get error message (reference details in problem description)


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