Troubleshoot ADFdi

Occasionally the Application Developer Framework Desktop Integration (ADFdi) Excel add-in may require troubleshooting. In most cases, the parameters that were initially configured must be verified or re-enabled.

Step Action Illustration

1

 Open a Journal Entry spreadsheet in Excel.

 

2

 Verify the Create Journal tab appears in the Excel ribbon.
 

3

 If the Create Journal tab is available, click File, then click Options. The Excel Options window appears. Proceed to Step 5.
 

If the Create Journal tab is unavailable, click File, then click Options, and click Add-ins. The Add-ins window appears.

 

In the Manage field, select COM Add-ins and click Go. The COM Add-ins pop-up appears.

 

4

 Enable the Oracle ADF 11g Desktop Integration Add-In for Excel check box and click OK. The COM Add-ins pop-up closes.
 

5

 Click Trust Center, then click Trust Center Settings. The Trust Center window opens.

6

 Click ActiveX Settings. Click the Enable all controls without restrictions and without prompting radio button. Enable the Safe mode check box.
 
Click Macro Settings. The Macro Settings window appears.

7

 Click the Disable all macros except digitally signed macros radio button. Enable the Trust access to the VBA project object model check box.
 
Click OK.

 

Verify ADFdi is Enabled

If Oracle ADF 11g Desktop Integration Add-in for Excel does not move to the Active Application Add-ins, it may have been disabled. Follow the steps below to verify ADFdi is disabled.

 

Step Action Illustration

1

 In Excel, click the File tab.
 
Select Options at the left.
 
The Excel Options window displays.

2

 On the left of the Excel Options window, click Add-Ins.
 
At the bottom of the window, in the Manage field, select Disabled Items from the drop down menu and click Go.
 
 The Disabled Items pop-up appears.

3

 Select Oracle ADF 11g Desktop Integration Add-In for Excel then click Enable.
 
*Note: The following image is representative, the Add-in name and appearance may vary.

4

 Verify ADFdi is active by clicking File, then click Options, and click Add-ins.
Oracle ADF 11g Desktop Integration Add-in for Excel appears in the Add-ins window.

Updated 8/14/2018 JM