How to download ADFdi in Oracle Fusion Cloud| Install ADFdi to Excel
Here we will see how to download ADFdi in Oracle Fusion Cloud. With the newer versions of Oracle cloud the ADFDi add-in for Excel to upload data into oracle fusion applications requires some roles to be configured.
Be aware that the ADFdi desktop helps in fetching the interface records directly from the fusion database and can be corrected and required actions can be taken right from the desktop,
How to download oracle ADF 11g desktop integration add-in for excel
To download the oracle ADFdi integrator required roles has to be present with the application user who is logged in.
If the required roles are already there you should be able to see a menu in Navigator > Tools named ‘Desktop Integrator’. This menu can be used to download the adf integrator for oracle cloud applications.
If the role is not added to the user the menu ‘Desktop Integrator’ would not be available under the tools menu. For that you will need to add Download Desktop Integrator privilege and perform the below steps

How to Add Download Desktop Integrator privilege to Employee Role:
Total Time: 20 minutes
-
Login to security console
Goto Navigator> Toos> Security Console . In Security Console, Click on Roles
-
Search for role ORA_PER_EMPLOYEE_ABSTRACT
Search the role which is the code of abstract employee role
-
Click on ORA_PER_EMPLOYEE_ABSTRACT
Clicking will add the abstract role
-
Click on drop down menu,Select ‘Copy Role’
Copy this role to and will need to give a new custom name
-
Select ‘Copy top role and inherited roles’
-
Enter Role Name and Role Code
Give your desired Role code and name
-
Click ‘Add Function Security Policy’ (Window Pops_Up)
Function security allows you to add the privileges
-
Search for ‘Download Desktop Integrator’
Download desktop integrator privilege is the role you need to add
-
Click on ‘Download Desktop Integrator’
This will Select the previlige to the role
-
Select ‘Add Privilege to Role’ (Confirmation Window Pops-Up)
This will add the previlige to the role
-
Click ‘Cancel’ to get out of the Add Function Security Policy window
-
Search for ‘Download Desktop Integrator’ to ensure it was added
Make sure the role is added
-
Click ‘Next’
Click ‘Next’ button
-
Click ‘Add User’ (Window Pops-Up)
-
Search for user name
-
Click on User(s)
-
Click ‘Add User to Role’
-
Click ‘OK’
-
Click ‘Cancel’ to get out of Add User Window
-
Click ‘Next’
-
Verify Privilege and User was added
-
Then Click ‘Submit and Close’
-
Click ‘OK’
-
Click ‘Administration’
-
Click on ‘Role Copy Status’
-
Status will change from Processing to Complete (keep refreshing)
Once complete it should be visible under Tools menu
FAQ:
Why is Desktop integrator not visible under tools menu?
The user may not have privileges to use the adfdi integrator
Why is the ADF Di menu is not available even after adding employee abstract Role?
The role update needs some time to get updated . You can try running the Scheduled process ‘Send Pending LDAP requests’
References : Oracle ADF integrator
You May Like
Oracle Fusion Technical - A Complete Technical Guide

Oracle Cloud ERP Technical - Integration, Conversion(FBDI, ADFdi, SOAP/REST), Reports(BI/OTBI), Workflows, Security, OIC