Contact Us

Fusion Middleware
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

Part 1: Installing ADF desktop integration

Download ADF desktop integration from


Part 2: Configuring the Environment to Support Desktop Integration Before starting to work with desktop integration you need to configure the various software pieces to support ADF desktop integration. This part guides you through the steps to do this.

Step 1: Enable Microsoft .Net Programmability Support

Before you can install the Oracle ADF Desktop Integration add-in, Microsoft Office Excel 2007 or 2010 must have Microsoft .NET programmability support enabled. 

  1. On your desktop click the Start  button.


  1. In the Start Menu, select Control Panel .



  1. In the Control Panel window, double-click the Add or Remove Programs  option.


  1. Once the list of installed programs is populated, scroll down to the Microsoft Office Standard 2007  (or 2010) entry and select it.


  1. Click the Change  button.1


  1. Select the Add or Remove Features  radio button and click Continue.


  1. Expand the Microsoft Office | Microsoft Office Excel  nodes. Select .NET Programmability Support. Click  Continue.



  1. Wait for the Configuration to proceed, and when finished, close the window.


  1. Close the Add or Remove Programs window.


  1. Close the Control Panel window. 


    You've successfully added .NET programmability support to Excel.

Step 2: Install the Oracle ADF 11g Desktop Integration Add-in for Excel

When you run the ADF Desktop Integration setup tool, it verifies whether the required pieces of software are installed on the system where you want to install the framework.

  1. Start JDeveloper by selecting Start > Programs > Oracle Fusion Middleware > JDeveloper Studio .


If the Migrate User Settings dialog box opens, click NO .

  1. If prompted for a User Role, choose Default Role.


  1. The JDeveloper IDE should now be displayed.


  1. From the Tools  menu choose Install ADF Desktop Integration.


The ADF Desktop Integration installer is started.

  1. Various verification checks are carried out, and if all is in order, installation can begin. Click the Install  button to proceed.


  1. Installing the ADF Desktop Integration add-in starts. Notice that depending on software already installed, you might be prompted to install other mandatory prerequisites, and in some cases to reboot your computer.


  1. Once Microsoft Office customization has been successfully installed, click Close  to exit.


Step 3: Configure Excel to Run an Integrated Excel Workbook

You need to configure Microsoft Excel settings to make it accessible from ADF Desktop Integration. 

  1. On your desktop, click the Start  button.


  1. In the Start menu, select All Programs > Microsoft Office > Microsoft Office Excel 2007  (or 2010).


  1. Once Microsoft Excel is started, click the Office  button.

alt text

  1. In the Office window, click Excel Options .


  1. In the Excel Options window, click the Trust Center  tab, then click the Trust Center Settings button.


  1. In the Trust Center window, click the Macro Settings  tab, then check the Trust access to the VBA project object model checkbox. Click  OK.


  1. Back in the Excel Options window, click OK .


  1. Back in Excel, close  the application.


  1. Make sure that ADF Desktop Integration Add-In for Excel is enabled



Part 3: Creating Invoices using Spreadsheet in Payables.

            There are 2 Spreadsheets

  1. Creating Invoices

  2. Correct Import Errors


Once the Create Invoice Spreadsheet is opened, There will be a message which will allow you to connect to remote servlet which requires a User id and Password




Once Userid and password is validated then the Spreadsheet will allow you to create Invoices.  The required fields are Marked with * and at least one required is marked as **


We can enter one Invoice or we can enter multiple invoices. Once the invoice/invoices are entered then we can save and submit the Invoice Import process.


Save and Submit Invoice Import will allow you to run the import process from the Excel.

Once the Import Invoice process is completed, The invoice should appear under Manage Invoices UI.

Part 3: Correcting Spreadsheet Invoices in Payables.

If the Import process finds some errors related to the spreadsheet invoice like Duplicate Invoice Number. Then the process loads the data into AP_INTERFACE_REJECTIONS table which needs to be corrected and reloaded through Import process.


In order to Correct these invoices we user another Spreadsheet called “Correct Import Errors”.  Once the invoice is corrected then we get a confirmation that the invoice is updated.

We can kick off Invoice Import process and this will eventually creates the invoice if there are no further rejections


Corrected Invoice is loaded into Manage Invoices UI.



Ashish Harbhajanka

About the Author

Ashish Harbhajanka


Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK


Overall Rating (0)

0 out of 5 stars
  • No comments found

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Dec 2017  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner