ADFDI-05566 Error When Creating Receipts Using Spreadsheet

(Doc ID 1643699.1)

Last updated on JUNE 27, 2017

Applies to:

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

Symptoms

Navigation: Receivables > Receivables Balances > Receipts > Create Receipts in Spreadsheet

After relogging to open the Spreadsheet, the error displayed is as follows:

"ADFI-05566 Unable to retrieve values for the last binding "OrgIdlist", or for one or more of its dependent lists"

Details of the error:

The remote server returned an error: (500) Internal Server Error.

~~~~~~~~~~
WebException: The remote server returned an error: (500) Internal Server Error.
Source: System
Stack:
  at System.Net.HttpWebRequest.GetResponse()
  at oracle.adf.client.windows.common.internet.http.ManagedHttpResponse..ctor(HttpWebRequest request)
  at oracle.adf.client.windows.common.internet.http.ManagedHttpRequest.GetResponse()
  at oracle.adf.client.windows.datamanager.servletrequest.SyncRequest.BeginResponse()
  at oracle.adf.client.windows.datamanager.servletrequest.GetBCListDataRequest.ReadResponse()
  at oracle.adf.client.windows.datamanager.servletrequest.GetBCListDataRequest.InternalCallSyncServlet()
  at oracle.adf.client.windows.datamanager.servletrequest.SyncServletRequest.CallSyncServlet(Boolean retry)
  at oracle.adf.client.windows.datamanager.ADFBindingContext.SendSyncServletRequest(SyncServletRequest request)
  at oracle.adf.client.windows.datamanager.ADFBindingContext.GetBCListData(BindingContainerListData bcListData)
  at oracle.adf.client.windows.datamanager.BindingContainerListData.get_ListListData()
  at oracle.adf.client.windows.datamanager.BindingContainerListData.GetListItems(CtrlListBinding list, List`1 dlovIndices)
  at oracle.adf.client.windows.datamanager.CtrlListBinding.GetListItems(List`1 dlovPositions)
  at oracle.adf.client.windows.excel.runtime.cache.LovCacheItem.CreateOrUpdateLOVNamedRange(ExcelNamedRange namedRange, String rangeName, List`1 dependsOnPositions)
  at oracle.adf.client.windows.excel.runtime.cache.LovCacheItem.PopulateLovCache(ExcelNamedRange namedRange)

 

After you get past this error and you are using IE10 you may encounter:

Object reference not set to an instance of an object.

~~~~~~~~~~
NullReferenceException: Object reference not set to an instance of an object.
Source: adfdi-excel-addin-runtime
Stack:
 at oracle.adf.client.windows.excel.client.AdfdiRibbon.UpdateRuntimeTab(RibbonState state)
 at oracle.adf.client.windows.excel.client.AdfdiRibbon.HandleWorkbookActivate(Object sender, WorkbookEventArgs e)
 at oracle.adf.client.windows.excel.common.workbook.WorkbookEventManager.<>c__DisplayClass2.<RaiseAppLevelEvent>b__1()
 at oracle.adf.client.windows.common.SafeEventHandler.Invoke(Action action)



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