ADF Desktop Integration (ADFDI) in Oracle Cloud Applications

 

AFBDI

💻 Table of Content


Introduction

ADFDI is an excel based tool which is used to manage a large volume of data from cloud applications by using an Excel Spreadsheet. In Oracle Cloud generally, data is uploaded through two excel tools i.e. FBDI and ADFDI. FBDI is more useful when the volume of data is very large but when the volume of data is not very large then ADFDI will be the best option as it is directly connected to the application.

As ADFDI Excel sheet is connected with the application it will not allow us to upload the invalid values. Just like any other excel we can copy and paste the values. The user can also search the values just by double-clicking the cell. This online selection and validation tool make ADFDI as a better tool than FBDI. ADFDI file can also be used for deleting the lines which are stuck in the interface.

For using the ADFDI excel spreadsheet user have to download and install the tool on his system. The download process is generally divided into 2 parts i.e. Download and install the tool and Excel Setup. The installation and excel setup process is quite simple and there is no need for any technical knowledge. The user can install it with basic computer knowledge also.

Following is the process for ADFDI download:

Process of Installation:

Part I: Installation of application

Step 1: Log in to Oracle Cloud Application

Step 2: Go to Navigator → Tools → Select “Download Desktop Integration Installer”

Step 3: Save and Install the downloaded file

Part II: Excel Setups

Step 1: Open any Excel File and Navigate to the “File” option

file

Step 2: Select the Excel “Options”

Step 3: Go to “Trust Centre Settings”






Step 4: Navigate to “ActiveX Setting” and confirm whether the right option is selected


Step 5: Go to “Macro Settings” and verify that it looks like below



Step 6: Check for Add-Ins by following the navigation

Go to Excel options → Add-Ins → Select “COM Add-ins” from drop down list and click on “Go”



  • Step 7: Verify whether “Oracle ADF 11g Desktop Integration Add-in for Excel” is enabled or not. If it’s not enabled, then enable it




Comments

Popular posts from this blog

Supplier Explained

Purchase Order vs. Purchase Agreement