The Remote Server Returned An Error: (500) Internal Server Error While Worksheet Upload (Doc ID 1934977.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.8.0.0 version, Manage Compensation

When attempting to upload spreadsheet, the following error occurs.

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.MultiSyncModelRequest.ReadResponse()
  at oracle.adf.client.windows.datamanager.servletrequest.BindingContainerRequest.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.MultiSyncModel(BindingContainer bc, Boolean abortOnFail)
  at oracle.adf.client.windows.datamanager.BindingContainer.EndMultiSync()
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableOperationHelper.ReadMultiSyncRows(List`1 batchRows, Boolean abortOnFail)
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableOperationHelper.ProcessRows(Boolean abortOnFail)
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableOperationHelper.Run(RTColumn rtColumnFlaggedOrChanged, Int32 cRowsFlaggedOrChanged, Boolean abortOnFail)
  at oracle.adf.client.windows.excel.runtime.uicomponent.table.DEGUploadHelper.Upload(Boolean haveOptions, Boolean abortOnFail, Boolean downloadAfterUpload)
  at oracle.adf.client.windows.excel.runtime.uicomponent.RTDataEntryGrid.Upload(RTComponentAction rtAction, Boolean haveOptions, Boolean abortOnFail, Boolean downloadAfterUpload)
  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)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Click on Sign in under Sign In using my Company's Sign-in
2. Go to Compensation
3. Then Act as Proxy Manager
4. Click on Annual Compensation Plan
5. Click on Export
6. Click on Open.
7. Click on Yes.
8. Click on Sign in under Sign In using my Company's Sign-in
9. Then progress popup window appears.
10. Excel worksheet will open
11. Update the column
12. Then click on Upload
13. Click on Yes.
14. Click on Sign in under Sign In using my Company's Sign-in
15. Click on OK

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upload the worksheet data

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