Login
Register

Home

Trainings

Fusion

R12

Blogs

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

http://www.oracle.com/technetwork/developer-tools/adf/overview/index-085534.html

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.

alt text

  1. In the Start Menu, select Control Panel .

alt text

 

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

alt text

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

alt text

  1. Click the Change  button.1

alt text

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

alt text

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

alt text

 

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

alt text

  1. Close the Add or Remove Programs window.

alt text

  1. Close the Control Panel window. 

    alt text

    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 11.1.1.4.0 .

alt text

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

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

alt text

  1. The JDeveloper IDE should now be displayed.

alt text

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

alt text

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.

alt text

  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.

alt text

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

alt text

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.

alt text

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

alt text

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

alt text

  1. In the Office window, click Excel Options .

alt text

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

alt text

  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.

alt text

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

alt text

  1. Back in Excel, close  the application.

alt text

  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 will load data into AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE tables.

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

........

More articles from this author

Overall Rating (0)

0 out of 5 stars
  • No comments found

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2017  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
   1  2  3  4  5  6
  7  8  910111213
14151617181920
21222324252627
28293031   

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner