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.

2. In the Start Menu, select Control Panel .

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

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

5. Click the Change  button.1

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

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

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

9. Close the Add or Remove Programs window.

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

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

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

3. The JDeveloper IDE should now be displayed.

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

The ADF Desktop Integration installer is started.

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

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

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

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

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

4. In the Office window, click Excel Options .

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

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

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

8. Back in Excel, close  the application.

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

Add comment