ADFDI Errors When Trying To Open Create Absence Record Spreadsheet

(Doc ID 2171294.1)

Last updated on JANUARY 30, 2017

Applies to:

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


On : version, HCM Data Loader

ADFDI errors when trying to open Create Absence Record spreadsheet

When opening the “Create Absence Record” spreadsheet, the following error occurs after login in Excel: ADFDI-05530: unable to initialize worksheet Sheet1. Clicking on details shows the following:
The remote server returned an error: (500) Internal Server Error
  at request)
  at retry)
  at request)
  at bc, String contentType)
  at isFirstLoad)
  at initializeUI)

Clicking on OK, a blank spreadsheet is opened. Click on the Spreadsheet loader ribbon, and click Login. We now get ADFDI-05566: unable to retrieve values for the list binding PVAL003, or for one or more of its dependent lists.

Clicking on OK, the spreadsheet loads, but the batch name is blank.
Employer has an LOV, but absence type and reason don’t have an LOV.


ADFDI-05530: unable to initialize worksheet Sheet1

The issue can be reproduced at will with the following steps:
1. Opening the “Create Absence Record” spreadsheet


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