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.
-
On your desktop click the Start button.
-
In the Start Menu, select Control Panel .
-
In the Control Panel window, double-click the Add or Remove Programs option.
-
Once the list of installed programs is populated, scroll down to the Microsoft Office Standard 2007 (or 2010) entry and select it.
-
Click the Change button.1
-
Select the Add or Remove Features radio button and click Continue.
-
Expand the Microsoft Office | Microsoft Office Excel nodes. Select .NET Programmability Support. Click Continue.
-
Wait for the Configuration to proceed, and when finished, close the window.
-
Close the Add or Remove Programs window.
-
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.
-
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 .
-
If prompted for a User Role, choose Default Role.
-
The JDeveloper IDE should now be displayed.
-
From the Tools menu choose Install ADF Desktop Integration.
The ADF Desktop Integration installer is started.
-
Various verification checks are carried out, and if all is in order, installation can begin. Click the Install button to proceed.
-
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.
-
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.
-
On your desktop, click the Start button.
-
In the Start menu, select All Programs > Microsoft Office > Microsoft Office Excel 2007 (or 2010).
-
Once Microsoft Excel is started, click the Office button.
-
In the Office window, click Excel Options .
-
In the Excel Options window, click the Trust Center tab, then click the Trust Center Settings button.
-
In the Trust Center window, click the Macro Settings tab, then check the Trust access to the VBA project object model checkbox. Click OK.
-
Back in the Excel Options window, click OK .
-
Back in Excel, close the application.
-
Make sure that ADF Desktop Integration Add-In for Excel is enabled
Part 3: Creating Invoices using Spreadsheet in Payables.
There are 2 Spreadsheets
-
Creating Invoices
-
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.