10/14/2019 An Introduction To ADF Desktop Integration - A Worked Example
LOGIN REGISTER
HOME TRAININGS FUSION BLOG EBS BLOG
AUTHORS
CONTACT US
Oracle Gold Partners, our very popular training
packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.
SEARCH COURSES
Search products
AN INTRODUCTION TO ADF SEARCH
TRAININGS
DESKTOP INTEGRATION - A
WORKED EXAMPLE
Online Search pro
https://www.apps2fusion.com/oracle-fusion-online-training/fusion-middleware-development/11-adf/1337-an-introduction-to-adf-desktop-integration-a-… 1/10
10/14/2019 An Introduction To ADF Desktop Integration - A Worked Example
Details
Category: Application Development Framework
Published: 22 March 2016
FULLY
VERIFIABLE
TESTIMONIALS
Vote 5 Rate
Like 0 f Share Tweet
Share
Part 1: Installing ADF desktop integration
Download ADF desktop integration from
FUSION HCM
http://www.oracle.com/technetwork/developer- IMPLEMENTATION
tools/adf/overview/index-085534.html Training was great. The
Part 2: Configuring the Environment to Support Desktop Integration duration of the c
Before starting to work with desktop integration you need to configure the appropriate. I have been
various software pieces to support ADF desktop integration. This part guides setup using knowledge t
you through the steps to do this.
Read Full
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 Sande
programmability support enabled.
https://www.linkedin.com
1. On your desktop click the Start button.
All Testimonial
2. In the Start Menu, select Control Panel .
APPS2FUSION -
EVENT LIST
3. In the Control Panel window, double-click the Add or Remove
Programs option.
<< Oct 2019 >>
Mon Tue Wed Thu Fri Sat S
1 2 3 4 5
4. Once the list of installed programs is populated, scroll down to
the Microsoft Office Standard 2007 (or 2010) entry and select it. 7 8 9 10 11 12
14 15 16 17 18 19
21 22 23 24 25 26
5. Click the Change button.1
28 29 30 31
https://www.apps2fusion.com/oracle-fusion-online-training/fusion-middleware-development/11-adf/1337-an-introduction-to-adf-desktop-integration-a-… 2/10
10/14/2019 An Introduction To ADF Desktop Integration - A Worked Example
6. Select the Add or Remove Features radio button and
click Continue. Search ...
Search
7. Expand the Microsoft Office | Microsoft Office Excel nodes.
Select .NET Programmability Support. Click Continue.
ENQUIRE FOR
TRAINING
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.
https://www.apps2fusion.com/oracle-fusion-online-training/fusion-middleware-development/11-adf/1337-an-introduction-to-adf-desktop-integration-a-… 3/10
10/14/2019 An Introduction To ADF Desktop Integration - A Worked Example
6. Installing the ADF Desktop Integration add-in starts. Notice that
depending on software already installed, you might be prompted to Email *
install other mandatory prerequisites, and in some cases to reboot
your computer.
First Name *
7. Once Microsoft Office customization has been successfully Last Name *
installed, click Close to exit.
Country *
Step 3: Configure Excel to Run an Integrated Excel Workbook
Mobile *
You need to configure Microsoft Excel settings to make it accessible
from ADF Desktop Integration.
Training of your
interest *
1. On your desktop, click the Start button.
Enter your inquiry *
2. In the Start menu, select All Programs > Microsoft Office >
Microsoft Office Excel 2007 (or 2010).
* required information
For security purposes, please
3. Once Microsoft Excel is started, click the Office button. numbers you see below.
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.
https://www.apps2fusion.com/oracle-fusion-online-training/fusion-middleware-development/11-adf/1337-an-introduction-to-adf-desktop-integration-a-… 4/10
10/14/2019 An Introduction To ADF Desktop Integration - A Worked Example
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 ARTICLES
Apps2Fusion
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 Articles
and Password
GET EMAIL
UPDATES
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 **
Enter your email addre
We can enter one Invoice or we can enter multiple invoices. Once the
Subscribe
invoice/invoices are entered then we can save and submit the Invoice Import
process.
Powered by Google
Save will load data into AP_INVOICES_INTERFACE and
FeedBurner
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.
https://www.apps2fusion.com/oracle-fusion-online-training/fusion-middleware-development/11-adf/1337-an-introduction-to-adf-desktop-integration-a-… 5/10
10/14/2019 An Introduction To ADF Desktop Integration - A Worked Example
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
Next
ABOUT THE AUTHOR
ASHISH HARBHAJANKA
https://www.apps2fusion.com/oracle-fusion-online-training/fusion-middleware-development/11-adf/1337-an-introduction-to-adf-desktop-integration-a-… 6/10
10/14/2019 An Introduction To ADF Desktop Integration - A Worked Example
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
Performing Mathematical Calculations on an Extract Rule
Attribute
Smart Classi cation of Extract Record Instance Using
Identi er Attribute In Oracle Fusion HCM Cloud
Application
Creating a Performance Tile Report in Oracle ERP Cloud
Application
Verifying Workforce Structures Position Row In Oracle
HCM Cloud Application
Creating a Waterfall Graph In Oracle ERP Cloud
Application
https://www.apps2fusion.com/oracle-fusion-online-training/fusion-middleware-development/11-adf/1337-an-introduction-to-adf-desktop-integration-a-… 7/10
10/14/2019 An Introduction To ADF Desktop Integration - A Worked Example
Storing Non-Unique Values In a Custom Lookup In
Oracle HCM Cloud Application - A Worked Example
Developing Low-Code/No-Code Reports in Oracle ERP
Cloud Application
Generating Password Protected PDF Reports from
Simple Click on Springboard Icon
An Overview of Assignment Data Integrity Report In
Oracle HCM Cloud Application
Embedding Multiple Charts and Data Table in a BIP
Report
An Overview of User Experience Related Changes
Introduced in Release 13 Update 18B
An Introduction to HCM Event Diagnostics in Oracle HCM
Cloud
A How-to Article about using Legend View In an OTBI
Analysis
An Introduction of Person Setup Validations Diagnostic
Test In Oracle HCM Cloud Application
An Overview of "My CV" Report - A Delivered Self Service
Report in Oracle HCM Cloud
Creating Absence Management Usage Report In Oracle
HCM Cloud Application
Person Validations Diagnostic Test In Oracle HCM Cloud
Application
An Overview of User Password Changes Audit Report
Using Image and Static Text in OTBI Analysis
Creating a New Employee using the Newsfeed Layout in
Oracle HCM Cloud Release 13 (Update 18B)
A AA
LATEST POPULAR OUR COMPANY
ARTICLES ARTICLES
Follow us on twitter
Data Subscribe to
Join us on Facebook
Wrangling in New Oracle
OAC Apps Articles Self Paced Courses
https://www.apps2fusion.com/oracle-fusion-online-training/fusion-middleware-development/11-adf/1337-an-introduction-to-adf-desktop-integration-a-… 8/10
10/14/2019 An Introduction To ADF Desktop Integration - A Worked Example
Branching & on this Custom home
Merging Website by About Apps2Fusion
Strategies Email
Corporate Trainings
(SCM Part - 3) Basic
Oracle Concepts - Finance Transformation Experts
Enterprise List of useful
Data Oracle Apps
Management Articles
Cloud Service XML
(EDMCS) Publisher
Training and Data
Automation Template -
Maturity SQL Query to
Stages - POV develop BI
Continuing Publisher
Trends for Reports
DevOps Forum - For
Oracle Apps
Customization
and
QUICK Extensions
MENU OA
Framework
Follow us on
Tutorials
twitter
Training
Join us on
Facebook
Self Paced
Courses ABOUT
APPS2FUSION
Custom
home
Apps2Fusion
About are
Apps2Fusion passionate
Corporate about Fusion
Trainings Cloud E-
Learning and
Finance
classroom
Transformation
trainings.
Experts
Training is
our core
business and
we have
been doing
this for many
many years.
https://www.apps2fusion.com/oracle-fusion-online-training/fusion-middleware-development/11-adf/1337-an-introduction-to-adf-desktop-integration-a-… 9/10
10/14/2019 An Introduction To ADF Desktop Integration - A Worked Example
We work
hard to
advise
trainees with
right career
paths. We
have
published
various ve
star rated
Oracle Press
Books each
was best
sellers in its
category. We
have helped
many and
could help
you as well.
Copyright © 2019. Oracle Fusion Training & Fusion ELearning. Designed by Shape5.com Joomla
Templates
https://www.apps2fusion.com/oracle-fusion-online-training/fusion-middleware-development/11-adf/1337-an-introduction-to-adf-desktop-integration-a… 10/10
