How to download ADFdi in Oracle Fusion Cloud| Install ADFdi Plugin for 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

Downloading oracle ADF 11g desktop integration add-in for excel in Cloud Applications requires an employee role to be added , Once complete it should be visible under Tools menu
adfdi-desktop-integrator

How to Add Download Desktop Integrator privilege to Employee Role:

Total Time: 20 minutes

  1. Login to security console

    Goto Navigator> Toos> Security Console . In Security Console, Click on Roles

  2. Search for role ORA_PER_EMPLOYEE_ABSTRACT

    Search the role which is the code of abstract employee role

  3. Click on ORA_PER_EMPLOYEE_ABSTRACT

    Clicking will add the abstract role

  4. Click on drop down menu,Select โ€˜Copy Roleโ€™

    Copy this role to and will need to give a new custom name

  5. Select โ€˜Copy top role and inherited rolesโ€™

  6. Enter Role Name and Role Code

    Give your desired Role code and name

  7. Click โ€˜Add Function Security Policyโ€™ (Window Pops_Up)

    Function security allows you to add the privileges

  8. Search for โ€˜Download Desktop Integratorโ€™

    Download desktop integrator privilege is the role you need to add

  9. Click on โ€˜Download Desktop Integratorโ€™

    This will Select the previlige to the role

  10. Select โ€˜Add Privilege to Roleโ€™ (Confirmation Window Pops-Up)

    This will add the previlige to the role

  11. Click โ€˜Cancelโ€™ to get out of the Add Function Security Policy window

  12. Search for โ€˜Download Desktop Integratorโ€™ to ensure it was added

    Make sure the role is added

  13. Click โ€˜Nextโ€™

    Click โ€˜Nextโ€™ button

  14. Click โ€˜Add Userโ€™ (Window Pops-Up)

  15. Search for user name

  16. Click on User(s)

  17. Click โ€˜Add User to Roleโ€™

  18. Click โ€˜OKโ€™

  19. Click โ€˜Cancelโ€™ to get out of Add User Window

  20. Click โ€˜Nextโ€™

  21. Verify Privilege and User was added

  22. Then Click โ€˜Submit and Closeโ€™

  23. Click โ€˜OKโ€™

  24. Click โ€˜Administrationโ€™

  25. Click on โ€˜Role Copy Statusโ€™

  26. Status will change from Processing to Complete (keep refreshing)

    Once complete it should be visible under Tools menu

Installing ADFDi plugin to Excel

To install Oracle ADF Desktop Integrator for Oracle Fusion, follow these steps:

  1. Download the ADF Desktop Integrator software from the Oracle Technology Network website.
  2. Install Microsoft Excel on the computer where you want to use ADF Desktop Integrator. Make sure that Microsoft Excel is fully updated and that all necessary add-ins are installed.
  3. Install Oracle Smart View for Office, which is a prerequisite for ADF Desktop Integrator. You can download Smart View from the Oracle Technology Network website.
  4. Install ADF Desktop Integrator by running the setup program that you downloaded in step 1. Follow the instructions in the setup wizard to complete the installation.
  5. After the installation is complete, launch Microsoft Excel and check to make sure that the ADF Desktop Integrator add-in is installed and enabled. To do this, click the โ€œFileโ€ menu, then click โ€œOptions,โ€ and then click โ€œAdd-ins.โ€ In the Manage box, select โ€œExcel Add-insโ€ and click โ€œGo.โ€ In the Add-ins box, look for the โ€œADF Desktop Integratorโ€ add-in and make sure that it is checked.
  6. Finally, configure ADF Desktop Integrator to connect to your Oracle Fusion instance. To do this, launch Microsoft Excel and click the โ€œADF Desktop Integratorโ€ tab. Click the โ€œConnectโ€ button and enter the connection details for your Oracle Fusion instance.

Thatโ€™s it! You should now be able to use ADF Desktop Integrator to import and export data between Oracle Fusion and Microsoft Excel.

Steps

Once downloaded the ADFDI can be installed by executing the downloaded file.

image 7 download ADFdi in oracle Fusion Cloud 1

If you do not see the adf di menu in Excel tool bar

go to menu File > Options

image 4 download ADFdi in oracle Fusion Cloud 2

Then in the pop up window select Add-ins >

See if the Oracle ADF 11g desktop integration tool is Disabled. You will need to enable it

Click on Com- Add ins in mange section and hit Go

image 5 download ADFdi in oracle Fusion Cloud 3

You will need to check the checkbox and hit ok

image 6 download ADFdi in oracle Fusion Cloud 4

Once working you will see a menu in excel as below

image 8 download ADFdi in oracle Fusion Cloud 5

Enable Logging to fusion from ADFDI

You will need to enable Logging from the Excel menu to maintain logs.

image 9 download ADFdi in oracle Fusion Cloud 6

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

wpsadmin
We will be happy to hear your thoughts

Leave a reply

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO
Cloud Technologies Blog
Logo
Compare items
  • Total (0)
Compare
0
Shopping cart