Article 6: How to Setup ADFDI in Oracle Fusion Cloud

ADFDI (Application Development Framework Desktop Integration) in Oracle Cloud Applications.

ADFDI is an Excel Based Tool. It is used to manage large volume of data from Oracle cloud applications by using an Excel Sheet. In Oracle Cloud, usually data is imported/uploaded through two excel tools.

1. FBDI

2. ADFDI

FBDI is more useful when the volume of data is in bulk, but when the data is not very large, then we can go for ADFDI.

ADFDI Excel relates to Oracle application, and we cannot enter invalid values in the ADFDI Excel Sheet. It will not allow to upload invalid values. Like normal excel sheet, we can insert, delete, copy, and paste the required values.

The person can also search for the values by double clicking on the cell. So, through selecting the online data, the chances of entering invalid values become reduced.

To use ADFDI feature in Excel, it’s required to Install ADF Desktop Integration Add-in for Excel.

This can be divided into 2 Steps.

1.     Download the ADF Desktop Integration Add-in for Excel from Oracle Applications.

2.     Prerequisites/Setup in Excel to Enable the Add-in.

Step 1: Download the ADF Desktop Integration Add-in for Excel from Oracle Applications.

Login into the Oracle Fusion Cloud Application.

Navigation:

Tools>>Download Desktop Integration Installer.

Download Desktop Integration Installer is not available for the User.

Scenario 1: Download Desktop Integration Installer is not available for the User.

Download Desktop Integrator Privilege (ATK_DOWNLOAD_DESKTOP_INTEGRATOR_PRIV) is missing for the User. This privilege is required to allow the Option for “Download Desktop Integration Installer “.

According to Oracle every user must be assigned at least one Abstract Role.

This privilege is associated with Employee Abstract Role.

Add Employee abstract role to the User.

Then Login with the Test User after adding the Employee abstract Role.

Select Tools

Save and close the form and check once again to whether user can see the Download Desktop Integration Installer under tools or not.

Now User can see the Download Desktop Integration Installer Icon.

Click on the Download Desktop Integration Installer Icon.

It will install the add-in in the system, and we can see it in our installed apps in settings.

Step 2: Excel Setups for the Activation of ADFDI add-in.

Open an Excel file and Navigate to " File " option in Excel.

(COM Add-in Means – Custom made or Downloaded or third-party Add-ins for adding extra features to the Existing Application).

Check in the Excel whether the Add-in is added or not.

Close the Excel Sheet and Open again, then click on the " File " option in Excel.

ADFDI Add-in is Successfully Added in Excel.

Thanks, and Regards

Sankarjith P M