Error When Opening Journal Spreadsheet: ADFdi-07528 ArgumentNullException In Excel 2010 And 2007 (Doc ID 1378793.1)

Last updated on FEBRUARY 24, 2016

Applies to:

Oracle Fusion General Ledger Cloud Service - Version N/A and later
Oracle Fusion General Ledger - Version 1.0-Beta and later
Information in this document applies to any platform.

Symptoms

When attempting to use the Journals Spreadsheet, and open the Excel file, it opens with shaded areas but
does not populate the field prompts or LOVs.
Then after clicking on Enable Editing at the top of the spreadsheet the following error occurs.

ERROR
-----------------------
ADFDI-07528: An unexpected exception has occurred. The UI Controller cannot initialize. The runtime session will now abort.
The Details show:
Value cannot be null.
Parameter name: worksheet

ArgumentNullException: Value cannot be null
...
Source: adfdi-excel-common


STEPS
-----------------------
The issue can be reproduced with the following steps using Microsoft Excel 2010:
1. Obtain ADFdi software from: OracleFADesktop.exe obtained from Fusion Apps:
Navigator > Tools > Download Desktop Integration Installer
2. Install ADFdi
3. Go into the GL application and click on Create Journals via Spreadsheet

Changes

PC where the problem happens has the following specifications:
Windows 7 Professional 32 bit
Microsoft Excel 2010
Internet Explorer 9

This also may occur in Microsoft Excel 2007.

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