Editing Business Object Data Using Excel Plugin Functionality Returns Remote Server Errors (Doc ID 2549065.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

Attempt to use the VBCS -> Business Objects -> Data manager -> Edit Data in Excel functionality fails.

Initial setup and connection works fine when the steps in the following document are followed:
https://docs.oracle.com/en/cloud/paas/integration-cloud/visual-excel/get-started-oracle-visual-builder-add-excel.html
This will show existing BOs based on Catalog API. Any further actions on the BOs on Excel side fail with below error: 

The operation failed due to a problem with the server accepting the request from the add-in. Contact the system administrator. (VBAFE-00106)
A request to the REST endpoint failed, response: The header Accept with value application/vnd.oracle.adf.description+json, application/vnd.oracle.adf.version+json;q=0,9, application/vnd.oracle.adf.resourcecollection+json;q=0,8, application/json;q=0,7, */*;q=0,6 is not valid.
The remote server returned an error: (400) Bad Request.

Exception stack
BadRequestException: The operation failed due to a problem with the server accepting the request from the add-in. Contact the system administrator. (VBAFE-00106)
Source: vbcs-ramp
Stack:
  at oracle.adf.client.windows.ramp.RestResponse.ReadResponse(HttpWebRequest webRequest)
  at oracle.adf.client.windows.ramp.RestRequest.GetResponse()
  at oracle.adf.client.windows.ramp.RestEndpoint.GetResponse(RestRequest request)
  at oracle.adf.client.windows.ramp.mdparser.ParserProvider.CreateResourceDef(RampClient rampClient, RestEndpoint endpoint, Uri resourceDefUri)
  at oracle.adf.client.windows.ramp.RestEndpoint.CreateResourceDef(RampClient rampClient, Uri resourceDescribeUri)
  at oracle.adf.client.windows.ramp.RampClient.InterpretEndpoint()
  at oracle.adf.client.windows.excel.rest.runtime.config.LayoutSetupHelper.GetServiceEndpoint()
  at oracle.adf.client.windows.excel.rest.runtime.config.LayoutSetupHelper.CreateLayout()
  at oracle.adf.client.windows.excel.rest.runtime.component.Workbook.ToggleDesigner()
  at oracle.adf.client.windows.excel.rest.runtime.Controller.ToggleDesigner()
  at oracle.adf.client.windows.excel.rest.client.VbcsRibbon.b__6_0()
  at oracle.adf.client.windows.excel.om.api.SafeExcelEventHandler.InternalInvoke(Action action)
  at oracle.adf.client.windows.excel.om.api.SafeExcelEventHandler.Invoke(Action action)
Inner:
RampBadRequestException: A request to the REST endpoint failed, response: The header Accept with value application/vnd.oracle.adf.description+json, application/vnd.oracle.adf.version+json;q=0,9, application/vnd.oracle.adf.resourcecollection+json;q=0,8, application/json;q=0,7, */*;q=0,6 is not valid.
Stack:

Inner:
WebException: The remote server returned an error: (400) Bad Request.
Source: System
Stack:
  at System.Net.HttpWebRequest.GetResponse()
  at oracle.adf.client.windows.ramp.RestResponse.ReadResponse(HttpWebRequest webRequest)


Product versions
Visual Builder Version: 19.1.3
Build Number: 502ce52b31c0250439408bed8cfe1913e4a88391 (2019-03-07 22:11:46)
Runtime Version: 19.1.3.4
JET runtime version: v6.1.0

Microsoft Excel 2013 and Excel 365

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.