Installing ADFDI (for Excel Spreadsheet uploads to Oracle)


 

BEFORE YOU BEGIN:  

 

Environment Link and Credentials: 

Link to UChicago's Oracle Environment: https://login-eusf-saasfaprod1.fa.ocs.oraclecloud.com/ 

 

Oracle Cloud Steps: 

  1. Log in by selecting Company Single Sign-on.
  2. Select the Navigator (top left) icon and Tools > Download Desktop Integration Installer.  

 

Note: for more information on installing ADFDI, see here: Oracle ADF Desktop Integration 

      3. Save and Install the downloaded file 

 

Microsoft Excel Steps 

  1. Open any Excel file and Navigate to the File option in the upper left corner. 

 

  1. Select Options at the bottom of the left side.
  1. Select Trust Center.

 

  1. Navigate to ActiveX Setting and confirm whether the right option is selected. 

 

 

Verification 

After installing ADFDI, follow these steps to test if ADFDI is working properly.  

  1. Log in to Oracle.  
  1. Go to Navigator > General Accounting > Journals  
  1. From the Taskbar on the right, click on Create Journal in Spreadsheet link.  
  1. Click Open File for the Journal Entry download.  
  1. Click Enable Editing and Click Yes to connect to Oracle.  
  1. Select Company Single Sign-on.

 

The Spreadsheet should look like the following when it opens: