Go to main content
1/29
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
What's New in This Guide for 12c (12.2.1.1)
New and Changed Features for 12c (12.2.1.1)
Other Significant Changes in this Document for 12c (12.2.1.1)
1
Introduction to ADF Desktop Integration
1.1
About ADF Desktop Integration
1.2
About ADF Desktop Integration with Microsoft Excel
1.2.1
Overview of Creating an Integrated Excel Workbook
1.2.2
Advantages of Integrating Excel with a Fusion Web Application
2
Introduction to the ADF Desktop Integration Sample Application
2.1
About the Summit Sample Application for ADF Desktop Integration
2.2
Setting Up and Running the Summit Sample Application for ADF Desktop Integration
2.2.1
How to Download the Application Resources
2.2.2
How to Run the Summit Sample Application for ADF Desktop Integration
2.3
Overview of the Fusion Web Application in the Summit Sample Application for ADF Desktop Integration
2.3.1
About the Fusion Web Application in the Summit Sample Application for ADF Desktop Integration
2.3.2
Downloading Integrated Excel Workbooks
2.4
Overview of the Integrated Excel Workbooks in the Summit Sample Application for ADF Desktop Integration
2.4.1
Log on to the Fusion Web Application from an Integrated Excel Workbook
2.4.2
Downloading Data Rows
2.4.3
Modify Customers and Warehouses Information in the Workbooks
2.4.4
Upload Modified Information to the Fusion Web Application
3
Setting Up Your Development Environment
3.1
About Setting Up Your Development Environment
3.2
Required Oracle ADF Modules and Third-Party Software
3.3
Installing ADF Desktop Integration
3.3.1
How to Install ADF Desktop Integration
3.4
Removing ADF Desktop Integration
3.5
Upgrading ADF Desktop Integration
4
Preparing Your Integrated Excel Workbook
4.1
About Preparing Your Integrated Excel Workbooks
4.2
Working with Page Definition Files for an Integrated Excel Workbook
4.2.1
How to Create ADF Desktop Integration Page Definition File
4.2.2
What Happens When You Create a Page Definition File
4.2.3
How to Reload a Page Definition File in an Excel Workbook
4.2.4
What You May Need to Know About Page Definition Files in an Integrated Excel Workbook
4.3
Adding an Integrated Excel Workbook to a Fusion Web Application
4.3.1
How to Add an Integrated Excel Workbook to a Fusion Web Application
4.3.2
How to Configure a New Integrated Excel Workbook
4.3.3
How to Add Additional Worksheets to an Integrated Excel Workbook
4.4
Enabling ADF Desktop Integration in an Excel Workbook
4.4.1
How to Enable ADF Desktop Integration in an Existing Workbook
4.4.2
How to Manually Configure a New Integrated Excel Workbook
4.5
Enabling ADF Desktop Integration Manually
4.5.1
How to Manually Add ADF Desktop Integration In Fusion Web Application
4.5.2
What Happens When You Add ADF Desktop Integration to Your JDeveloper Project
4.5.3
Adding ADF Library Web Application Support
4.6
Using an Integrated Excel Workbook with Older Versions of ADF Desktop Integration
5
Getting Started with the Development Tools
5.1
About Development Tools
5.1.1
ADF Desktop Integration Development Tools Use Cases and Examples
5.1.2
Additional Functionality for ADF Desktop Integration Development Tools
5.2
Designer Ribbon Tab
5.3
ADF Desktop Integration Designer Task Pane
5.4
Using the Bindings Palette
5.5
Using the Components Palette
5.6
Using the Property Inspector
5.7
Using the Binding ID Picker
5.8
Using the Expression Builder
5.9
Using the Web Page Picker
5.10
Using the File System Folder Picker
5.11
Using the Page Definition Picker
5.12
Using the Collection Editors
5.13
Using the Cell Context Menu
5.14
Removing ADF Desktop Integration Components
5.15
Exporting and Importing Excel Workbook Integration Metadata
5.15.1
How to Export Workbook Integration Metadata
5.15.2
How to Import Workbook Integration Metadata
5.15.3
What You May Need to Know About Exporting and Importing Excel Workbook Integration Metadata
6
Working with ADF Desktop Integration Form-Type Components
6.1
About ADF Desktop Integration Form-Type Components
6.1.1
ADF Desktop Integration Form-Type Components Use Cases and Examples
6.1.2
Additional Functionality for ADF Desktop Integration Form-Type Components
6.2
Inserting an ADF Label Component
6.3
Inserting an ADF Input Text Component
6.4
Inserting an ADF Output Text Component
6.5
Inserting an ADF Input Date Component
6.6
Inserting an ADF Image Component
6.7
Inserting an ADF Button Component
6.8
Displaying Output from a Managed Bean in an ADF Component
6.8.1
How to Display Output from a Managed Bean
6.8.2
What Happens at Runtime: How an ADF Component Displays Output from a Managed Bean
6.9
Displaying Concatenated or Calculated Data in Components
6.9.1
How to Configure a Component to Display Calculated Data
6.9.2
Using Form Components and Merged Cells
7
Working with ADF Desktop Integration Table-Type Components
7.1
About ADF Desktop Integration Table-Type Components
7.1.1
ADF Desktop Integration Table-Type Components Use Cases and Examples
7.1.2
Additional Functionality of Table-Type Components
7.2
Page Definition Requirements for an ADF Table Component
7.3
Inserting an ADF Table Component into an Excel Worksheet
7.3.1
How to Insert an ADF Table Component
7.3.2
How to Add a Column in an ADF Table Component
7.4
Downloading Data to an ADF Table Component
7.4.1
How to Download Data to an ADF Table Component
7.4.2
What Happens at Runtime: How an ADF Table Component Downloads Data
7.5
Downloading Pending Insert and Pending Update Rows to an ADF Table Component
7.5.1
What Happens at Runtime: Download Action is Invoked
7.5.2
Using STATUS_INITIALIZED Rows for Pending Inserts
7.5.3
What You May Need to Know About DownloadForInsert Action
7.6
Updating Existing Data in an ADF Table Component
7.6.1
How to Configure an ADF Table Component to Update Data
7.6.2
What Happens at Runtime: How the ADF Table Component Updates Data
7.7
Inserting Data in an ADF Table Component
7.7.1
How to Configure an ADF Table Component to Insert Data Using a View Object's Operations
7.8
Uploading Changes from an ADF Table Component
7.8.1
How to Configure an ADF Component to Upload Data from an ADF Table Component
7.8.2
What Happens at Runtime: How the ADF Table Component Uploads Data
7.8.3
What Happens at Runtime: How the ReadOnly EL Expression Is Evaluated During Upload
7.8.4
What Happens at Runtime: How Row Errors Are Handled During Upload
7.8.5
What You May Need to Know About Upload Options
7.8.6
How to Create a Custom Upload Dialog
7.8.7
What Happens at Runtime: Custom Upload Dialog
7.9
Uploading Changes from an ADF Table Component Using an UploadAllOrNothing Action
7.9.1
How to Configure an ADF Component to use UploadAllOrNothing Action
7.9.2
What Happens at Runtime: UploadAllOrNothing Action is Invoked
7.9.3
Limiting the Amount of Changed Data That Can Be Uploaded With UploadAllOrNothing Action
7.10
Deleting ADF Table Component Rows in the Fusion Web Application
7.10.1
How to Configure an ADF Table Component to Delete Rows in the Fusion Web Application
7.10.2
What Happens at Runtime: How the ADF Table Component Deletes Rows in a Fusion Web Application
7.11
Batch Processing in an ADF Table Component
7.11.1
How to Configure Batch Options for an ADF Table Component
7.11.2
Troubleshooting Errors While Uploading Data
7.12
Special Columns in the ADF Table Component
7.12.1
Row Flagging in an ADF Table Component
7.13
Configuring ADF Table Component Key Column
7.13.1
How to Configure the Key Column
7.13.2
How to Manually Add the Key Column At Design Time
7.14
Adding a Dynamic Column to Your ADF Table Component
7.14.1
How to Configure a Dynamic Column
7.14.2
What Happens at Runtime: How Data Is Downloaded or Uploaded In a Dynamic Column
7.14.3
How to Specify Header Labels for Dynamic Columns
7.14.4
How to Specify Styles for Dynamic Columns
7.15
Adding a ModelDrivenColumnComponent Subcomponent to Your ADF Table Component
7.16
Configuring an ADF Table Component to Resize Columns Based on Data at Runtime
7.16.1
How to Configure an ADF Table Component to Resize Columns at Runtime
7.16.2
How to Configure an Action Set to Resize Columns of an ADF Table Component at Runtime
7.16.3
What Happens at Runtime: How the ADF Table Columns are Resized
7.16.4
What You May Need to Know About Resizing Columns of an ADF Table Component at Runtime
7.17
Grouping Columns Together in an ADF Table Component
7.17.1
How to Group Columns in an ADF Table Component
7.17.2
How to Group Columns that Render in a Dynamic Column
7.17.3
What Happens at Runtime: How an ADF Table Component Groups Columns
7.18
Configuring an ADF Table Component to be Read-only
7.18.1
How to Configure an ADF Table Component to be Read-only
7.19
Creating an ADF Read-Only Table Component
7.19.1
How to Insert an ADF Read-only Table Component
7.20
Limiting the Number of Rows Your Table-Type Component Downloads
7.20.1
How to Limit the Number of Rows a Component Downloads
7.20.2
What Happens at Runtime: How the RowLimit Property Works
7.21
Tracking Changes in an ADF Table Component
7.22
Evaluating EL Expressions for ReadOnly Properties
7.22.1
What Happens at Runtime: Evaluating EL Expression While Downloading Data
7.22.2
What Happens at Runtime: Evaluating EL Expression While Uploading Data or Tracking Changes
7.22.3
What You May Need to Know About Evaluating EL Expression While Uploading Data or Tracking Changes
8
Working with Lists of Values
8.1
About List of Values in an Integrated Excel Workbook
8.1.1
Adding Lists of Values to Integrated Excel Workbooks Use Cases and Examples
8.1.2
Additional Functionality for Adding List of Values to an Integrated Excel Workbook
8.2
Creating a List of Values in an Excel Worksheet
8.3
Creating a List of Values in an ADF Table Component Column
8.3.1
How to Create a List of Values in an ADF Table Component Column
8.3.2
What Happens at Runtime: How the ADF Table Column Renders a List of Values
8.4
Adding a Model-Driven List Picker to an ADF Table Component
8.4.1
What You May Need to Know About Model-Driven List Pickers in ADF Table Components
8.5
Creating Dependent Lists of Values in an Integrated Excel Workbook
8.5.1
How to Create Dependent Lists of Values in Excel Worksheets
8.5.2
What Happens at Runtime: How an Excel Worksheet Renders a Dependent List of Values
8.5.3
How to Create Dependent Lists of Values in ADF Table Component Columns
8.5.4
What Happens at Runtime: ADF Table Component Column Renders a Dependent List of Values
9
Adding Interactivity to Your Integrated Excel Workbook
9.1
About Adding Interactivity to an Integrated Excel Workbook
9.1.1
Adding Interactivity to Integrated Excel Workbook Use Cases and Examples
9.1.2
Additional Functionality for Adding Interactivity to an Integrated Excel Workbook
9.2
Using Action Sets
9.2.1
How to Invoke a Method Action Binding in an Action Set
9.2.2
How to Invoke Component Actions in an Action Set
9.2.3
What You May Need to Know About an Action Set Invoking a Component Action
9.2.4
How to Invoke an Action Set from a Worksheet Event
9.2.5
How to Display a Progress Bar while an Action Set Executes
9.2.6
What Happens at Runtime: How the Action Set Displays a Status Message
9.2.7
What You May Need to Know About Progress Bars
9.2.8
How to Allow End Users to Continue Working in Excel While an ActionSet Executes
9.2.9
What Happens at Runtime: How End Users Continue Working While an ActionSet Executes
9.2.10
What You May Need to Know About Canceling an Action
9.2.11
How to Provide an Alert After the Invocation of an Action Set
9.2.12
What Happens at Runtime: How the Action Set Provides an Alert
9.2.13
How to Configure Error Handling for an Action Set
9.2.14
How to Prompt the User for Confirmation in an Action Set
9.2.15
What Happens at Runtime: How the Action Set Prompts the User for Confirmation
9.3
Configuring the Runtime Ribbon Tab
9.3.1
How to Define a Workbook Ribbon Command for the Runtime Ribbon Tab
9.3.2
How to Configure a Worksheet Ribbon Command for the Runtime Ribbon Tab
9.3.3
What Happens at Runtime: Ribbon Commands in the Ribbon Tab
9.4
Displaying Web Pages from a Fusion Web Application
9.4.1
How to Display a Web Page in a Popup Dialog
9.4.2
How to Display a Web Page Search Form in a Popup Dialog
9.4.3
How to Display a Web Page in ADF Desktop Integration Runtime Task Pane
9.4.4
What You May Need to Know About Displaying Pages from a Fusion Web Application
9.4.4.1
Sending Data Between an Integrated Excel Worksheet and a Fusion Web Application Page
9.4.4.2
Sharing Data Control Frames Between Integrated Excel Worksheets and Fusion Web Application Pages
9.4.4.3
Configuring a Fusion Web Application for ADF Desktop Integration Frame Sharing
9.5
Using Row-Level Action Sets in a Table Column
9.5.1
How to Enable Row-Level Action Set Model Management
9.5.2
What Happens at Runtime: RowActionSetModelMgmtEnabled is Set to True
9.5.3
How to Synchronize Changes from ADF Table Component Using RowUpSyncNoFail
9.5.4
What Happens at Runtime: RowUpSyncNoFail Action is Invoked
9.5.5
How to Add a Custom Popup Picker Dialog to an ADF Table Column
9.6
Using EL Expression to Generate an Excel Formula
9.6.1
How to Configure a Cell to Display a Hyperlink Using EL Expression
9.6.2
What Happens at Runtime: How a Cell Displays a Hyperlink using an EL Expression
9.7
Using Calculated Cells in an Integrated Excel Workbook
9.7.1
How to Calculate the Sum of a Table-Type Component Column
9.7.2
What Happens at Runtime: How Excel Calculates the Sum of a Table-Type Component Column
9.8
Using Macros in an Integrated Excel Workbook
10
Configuring the Appearance of Your Integrated Excel Workbook
10.1
About Configuring the Appearance of an Integrated Excel Workbook
10.1.1
Integrated Excel Workbook Configuration Use Cases and Examples
10.1.2
Additional Functionality for Configuring the Appearance of an Integrated Excel Workbook
10.2
Working with Styles
10.2.1
Predefined Styles in ADF Desktop Integration
10.2.2
Excel's Date Formats and Microsoft Windows' Regional and Language Options
10.2.3
How to Apply a Style to an Oracle ADF Component
10.2.4
What Happens at Runtime: How Style Is Applied to an ADF Component
10.3
Applying Styles Dynamically Using EL Expressions
10.3.1
What Happens at Runtime: How an EL Expression Is Evaluated
10.3.2
How to Write an EL Expression That Applies a Style at Runtime
10.3.3
What You May Need to Know About EL Expressions That Apply Styles
10.4
Using Labels in an Integrated Excel Workbook
10.4.1
Retrieving the Values of String Keys from a Resource Bundle
10.4.2
Retrieving the Values of Attribute Control Hints
10.4.3
How an Integrated Excel Workbook Evaluates a Label Property
10.5
Branding Your Integrated Excel Workbook
10.5.1
How to Brand an Integrated Excel Workbook
10.5.2
What Happens at Runtime: the BrandingItems Group of Properties
10.6
Displaying Tooltips in ADF Desktop Integration Components
10.6.1
How to Add a Tool Tip to an ADF Table Component
10.6.2
How to Add a Tool Tip to a Form-Type Component
10.6.2.1
What You May Need to Know About Tooltips for Form-Type Components
10.6.3
What You May Need to Know About Tooltips for Table Columns
10.7
Using Worksheet Protection
10.7.1
How to Enable Worksheet Protection
10.7.2
What Happens at Runtime: How the Locked Property Works
10.7.3
What You May Need to Know About Worksheet Protection
10.8
Using ADF Desktop Integration EL-based Properties with Custom Attribute Properties
10.8.1
How to Enable Custom Attribute Properties in Integrated Excel Workbook
10.8.2
What Happens at Runtime: CustomAttributePropertiesEnabled is Set to True
10.8.3
What You May Need to Know About the CustomAttributePropertiesEnabled Property
11
Internationalizing Your Integrated Excel Workbook
11.1
About Internationalizing Your Integrated Excel Workbook
11.1.1
Internationalizing Integrated Excel Workbook Use Cases and Examples
11.1.2
Additional Functionality for Internationalizing Integrated Excel Workbook
11.2
Using Resource Bundles in an Integrated Excel Workbook
11.2.1
How to Register a Resource Bundle in an Integrated Excel Workbook
11.2.2
How to Override Resources That Are Not Configurable
11.2.3
What Happens at Runtime: Override Resources That Are Not Configurable
11.2.4
What You May Need to Know About Resource Bundles
11.3
Localization in ADF Desktop Integration
11.3.1
Configuring Fusion Web Application to Override Server-Side Locale Settings
11.3.1.1
How to Create a User Preference Handler
11.3.1.2
How to Register the User Preference Handler
12
Securing Your Integrated Excel Workbook
12.1
About Security In Your Integrated Excel Workbook
12.1.1
Integrated Excel Workbook Security Use Cases and Examples
12.1.2
Additional Functionality for Integrated Excel Workbook in a Secure Fusion Web Application
12.2
Authenticating the Excel Workbook User
12.2.1
What Happens at Runtime: How the Login Method Is Invoked
12.2.2
What Happens at Runtime: How the Web Application Session is Terminated
12.3
Checking the Integrity of an Integrated Excel Workbook's Metadata
12.3.1
How to Reset the Workbook ID
12.3.2
What Happens When the Metadata Tamper-Check Is Performed
12.4
What You May Need to Know About Securing an Integrated Excel Workbook
12.5
Authorizing the Excel Workbook User
12.5.1
What You May Need to Know About ADF Desktop Integration-Disabled Worksheet
13
Adding Validation to Your Integrated Excel Workbook
13.1
About Adding Validation to an Integrated Excel Workbook
13.1.1
Integrated Excel Workbook Validation Use Cases and Examples
13.1.2
Additional Functionality for Adding Validation to an Integrated Excel Workbook
13.2
Using the Status Viewer to Report Error Messages to End Users
13.2.1
How to Manage the Automatic Display of the Status Viewer
13.3
Providing Data Entry Validation for an Integrated Excel Workbook
13.3.1
Providing Data Entry Validation Using ADF Desktop Integration
13.3.1.1
How to Enable or Disable ADF Desktop Integration Data Entry Validation
13.3.2
Providing Data Validation Using Excel
13.3.3
How to Upload Excel Cell Errors to the Fusion Web Application
13.4
Providing Server-Side Validation for an Integrated Excel Workbook
13.5
Providing a Row-by-Row Status on an ADF Table Component
13.6
Adding Detail to Error Messages in an Integrated Excel Workbook
13.7
Handling Data Conflicts When Uploading Data from a Workbook
13.7.1
How to Configure a Workbook to Handle Data Conflicts When Uploading Data
13.7.2
What Happens at Runtime: How Data Conflicts Are Handled
14
Testing Your Integrated Excel Workbook
14.1
About Testing Your Integrated Excel Workbook
14.1.1
Integrated Excel Workbook Testing Use Cases and Examples
14.1.2
Additional Functionality for Testing an Integrated Excel Workbook
14.2
Testing Your Fusion Web Application
14.3
Validating the Integrated Excel Workbook Configuration
14.3.1
How to Validate the Integrated Excel Workbook Configuration
14.3.2
What Happens When You Validate the Integrated Excel Workbook Configuration
14.3.3
How to Fix Validation Failures
14.3.4
How to Log the Integrated Excel Workbook Configuration Validation Failures at Runtime
14.4
Testing Your Integrated Excel Workbook
15
Deploying Your Integrated Excel Workbook
15.1
About Deploying Your Integrated Excel Workbook
15.1.1
Integrated Excel Workbook Deployment Use Cases and Examples
15.1.2
Additional Functionality for Deploying Your Integrated Excel Workbook
15.2
Making ADF Desktop Integration Available to End Users
15.3
Publishing Your Integrated Excel Workbook
15.3.1
How to Publish an Integrated Excel Workbook from Excel
15.3.2
How to Publish an Integrated Excel Workbook Using the Command Line Publish Tool
15.3.3
What Happens When You Publish an Integrated Excel Workbook
15.4
Deploying a Published Workbook with Your Fusion Web Application
15.4.1
What Happens When You Deploy an ADF Desktop Integration-Enabled Fusion Web Application from JDeveloper
15.4.1.1
Fusion Web Application is Deployed on Oracle WebLogic Server
15.4.2
What Happens at Runtime: End User Requests a Published Workbook
15.5
Passing Parameter Values from a Fusion Web Application Page to a Workbook
15.5.1
How to Configure the Fusion Web Application's Page to Pass Parameters
15.5.2
How to Configure Parameters Properties in the Integrated Excel Workbook
15.5.3
How to Configure the Page Definition File for the Worksheet to Receive Parameters
15.5.4
What Happens at Runtime: How Parameters Are Passed from a Fusion Web Application to the Integrated Excel Workbook
15.6
Customizing Workbook Integration Metadata at Runtime
15.6.1
How to Enable Workbook Customization at Runtime
15.6.2
What Happens at Runtime: Workbook Integration Metadata is Customized
15.6.3
What You May Need to Know About Customizing Workbook Integration Metadata
15.7
Integrating ADF Workbook Composer into Your Fusion Web Application
15.7.1
How to Integrate ADF Workbook Composer into Your Fusion Web Application
15.7.2
What Happens at Runtime: ADF Workbook Composer is Invoked
15.7.3
What You May Need to Know About ADF Workbook Composer
16
Using an Integrated Excel Workbook Across Multiple Web Sessions
16.1
About Using an Integrated Excel Workbook Across Multiple Web Sessions
16.1.1
Using an Integrated Excel Workbook Across Multiple Web Sessions Use Cases and Examples
16.1.2
Additional Functionality for Using an Integrated Excel Workbook Across Multiple Web Sessions
16.2
Restore Server Data Context Between Sessions
16.2.1
How to Configure an Integrated Excel Workbook to Restore Server Data Context
16.2.2
What Happens at Runtime: How the Integrated Excel Workbook Restores Server Data Context
16.3
Caching of Static Information in an Integrated Excel Workbook
16.4
Caching Lists of Values for Use Across Multiple Web Sessions
16.5
Using Explicit Worksheet Setup Action
16.5.1
How to Configure Explicit Worksheet Setup Action
16.5.2
What You May Need to Know About Explicit Worksheet Setup Action
17
Administering ADF Desktop Integration
17.1
Installing and Upgrading ADF Desktop Integration
17.1.1
Prerequisites for Installing ADF Desktop Integration Add-in
17.1.2
Configuring Microsoft Excel for Integrated Excel Workbooks That Use ADF Button Components
17.1.3
How to Install the ADF Desktop Integration Add-in From a Web Server
17.1.4
How to Upgrade the ADF Desktop Integration Add-in
17.1.5
How to Run ADF Desktop Integration Installer from Command Line
17.1.6
How to Manage the Display of the System Check to End Users
17.2
Running the Client Health Check Tool
17.3
Troubleshooting Connection Problems to Fusion Web Applications
17.4
ADF Desktop Integration Logs
17.5
Security in ADF Desktop Integration
17.5.1
End User Authentication
17.5.2
What You May Need to Know About Configuring Security in a Fusion Web Application
17.5.3
What You May Need to Know About Resource Grants for Web Pages
17.6
Verifying the Client Version of ADF Desktop Integration
17.6.1
How to Disable the Install Option on the Client-Server Version Check Dialog
17.7
Verifying Integrated Excel Workbook Metadata
17.7.1
How to Disable the Metadata Tamper-Check in the Fusion Web Application
17.8
Common ADF Desktop Integration Error Messages and Problems
A
ADF Desktop Integration Component Properties and Actions
A.1
Frequently Used Properties in the ADF Desktop Integration
A.2
ADF Input Text Component Properties
A.3
ADF Output Text Component Properties
A.4
ADF Label Component Properties
A.5
ADF List of Values Component Properties
A.6
ADF Image Component Properties
A.7
ADF Input Date Component Properties
A.8
ModelDrivenColumnComponent Subcomponent Properties
A.9
TreeNodeList Subcomponent Properties
A.10
ADF Button Component Properties
A.11
ADF Table Component Properties and Actions
A.11.1
ADF Table Component Properties
A.11.2
ADF Table Component Column Properties
A.11.3
ADF Table Component Actions
A.12
ADF Read-only Table Component Properties and Actions
A.13
Action Set Properties
A.13.1
Confirmation Action Properties
A.13.2
Dialog Action Properties
A.14
Workbook Actions and Properties
A.15
Worksheet Actions and Properties
A.16
ADF Desktop Integration Compatibility Properties
B
ADF Desktop Integration EL Expressions
B.1
Guidelines for Creating EL Expressions
B.2
EL Syntax for ADF Desktop Integration Components
B.3
Attribute Control Hints in ADF Desktop Integration
C
Troubleshooting an Integrated Excel Workbook
C.1
Verifying That Your Fusion Web Application Supports ADF Desktop Integration
C.2
Generating ADF Desktop Integration Diagnostic Reports
C.2.1
How to Generate the ADF Desktop Integration Diagnostic Report
C.2.2
What You May Need to Know About the ADF Desktop Integration Diagnostic Report
C.3
Troubleshooting Connection Problems to Fusion Web Applications
C.4
Verifying End-User Authentication for Integrated Excel Workbooks
C.5
Generating Log Files for an Integrated Excel Workbook
C.5.1
About Server-Side Logging
C.5.2
Using the Oracle Diagnostics Log Analyzer to Analyze ADF Desktop Integration Servlet Requests
C.5.3
About Client-Side Logging
C.5.3.1
What You May Need To Know About Always-On Logging
C.5.3.2
Enabling Transient Verbose Logging for One User Session
C.5.3.3
How to Configure Logging in the Oracle ADF Tab
C.5.3.4
About the ADF Desktop Integration Configuration File
C.5.3.5
How to Configure Logging Using User Environment Variables
C.5.3.6
What You May Need to Know About the adfdi-common Object
D
ADF Desktop Integration Settings in the Web Application Deployment Descriptor
D.1
Configuring the ADF Desktop Integration Servlet
D.2
Configuring the ADF Desktop Integration Excel Download Filter
D.3
Configuring the ADF Library Filter for ADF Desktop Integration
D.4
Examples in a Deployment Descriptor File
E
String Keys in the Overridable Resources
F
Java Data Types Supported By ADF Desktop Integration
F.1
Primitive Java Types
F.2
Object Java Types
G
Using the ADF Desktop Integration Model API
G.1
About the Temporary Row Object
G.2
About ADF Desktop Integration Model API
G.2.1
How to Add ADF Desktop Integration Model API Library to Your JDeveloper Project
G.3
ADF Desktop Integration Model API Classes and Methods
G.3.1
The oracle.adf.desktopintegration.model.ModelHelper Class
G.3.1.1
The getAdfdiTempChildRow Method
G.3.1.2
The getAdfdiTempRowForView Method
G.3.1.3
The getChildViewDef Method
H
End User Actions
H.1
Installing, Upgrading, and Removing ADF Desktop Integration
H.1.1
How to Install ADF Desktop Integration on Your System
H.1.2
How to Remove ADF Desktop Integration
H.1.3
How to Upgrade ADF Desktop Integration On a Local System
H.2
Removing Personal Information
H.3
Limitations of an Integrated Excel Workbook at Runtime
H.4
Using an Integrated Excel Workbook
H.4.1
How to Insert or Paste Rows in an ADF Table Component
H.4.2
How to Sort ADF Table Data in an Integrated Excel Workbook
H.4.3
How to Delete a Row in ADF Table of an Integrated Excel Workbook
H.5
Handling Time Zone Conversion
H.6
Providing Diagnostic and Logging Information to Technical Support
Scripting on this page enhances content navigation, but does not change the content in any way.