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. 

  • On your desktop click the Start  button.

  • alt text

    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

    alt text

    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.

    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.

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

    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.

    alt text

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

    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.

    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

    <<  May 2017  >>
     Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3  4  5  6  7
      8  91011121314
    15161718192021
    2223242526
        

    Enquire For Training

    Fusion Training Packages

    Get Email Updates


    Powered by Google FeedBurner