Table of Contents
- Title and Copyright Information
- Preface
- What's New in This Guide for 12c (12.2.1.4.0)
- 1 Introduction to ADF Desktop Integration
-
2
Introduction to the ADF Desktop Integration Sample Application
- About the Summit Sample Application for ADF Desktop Integration
- Setting Up and Running the Summit Sample Application for ADF Desktop Integration
- Overview of the Fusion Web Application in the Summit Sample Application for ADF Desktop Integration
- Overview of the Integrated Excel Workbooks in the Summit Sample Application for ADF Desktop Integration
- 3 Setting Up Your Development Environment
-
4
Preparing Your Integrated Excel Workbook
- About Preparing Your Integrated Excel Workbooks
- Working with Page Definition Files for an Integrated Excel Workbook
- Adding an Integrated Excel Workbook to a Fusion Web Application
- Enabling ADF Desktop Integration in an Excel Workbook
- Enabling ADF Desktop Integration Manually
- Using an Integrated Excel Workbook with Older Versions of ADF Desktop Integration
-
5
Getting Started with the Development Tools
- About Development Tools
- Designer Ribbon Tab
- ADF Desktop Integration Designer Task Pane
- Using the Bindings Palette
- Using the Components Palette
- Using the Property Inspector
- Using the Binding ID Picker
- Using the Expression Builder
- Using the Web Page Picker
- Using the File System Folder Picker
- Using the Page Definition Picker
- Using the Collection Editors
- Using the Cell Context Menu
- Removing ADF Desktop Integration Components
- Exporting and Importing Excel Workbook Integration Metadata
-
6
Working with ADF Desktop Integration Form-Type Components
- About ADF Desktop Integration Form-Type Components
- Inserting an ADF Label Component
- Inserting an ADF Input Text Component
- Inserting an ADF Output Text Component
- Inserting an ADF Input Date Component
- Inserting an ADF Image Component
- Displaying Output from a Managed Bean in an ADF Component
- Displaying Concatenated or Calculated Data in Components
-
7
Working with ADF Desktop Integration Table-Type Components
- About ADF Desktop Integration Table-Type Components
- Page Definition Requirements for an ADF Table Component
- Inserting an ADF Table Component into an Excel Worksheet
- Downloading Data to an ADF Table Component
- Downloading Pending Insert and Pending Update Rows to an ADF Table Component
- Updating Existing Data in an ADF Table Component
- Inserting Data in an ADF Table Component
-
Uploading Changes from an ADF Table Component
- How to Configure an ADF Component to Upload Data from an ADF Table Component
- What Happens at Runtime: How the ADF Table Component Uploads Data
- What Happens at Runtime: How the ReadOnly EL Expression Is Evaluated During Upload
- What Happens at Runtime: How Row Errors Are Handled During Upload
- What You May Need to Know About Upload Options
- How to Create a Custom Upload Dialog
- What Happens at Runtime: Custom Upload Dialog
- Uploading Changes from an ADF Table Component Using an UploadAllOrNothing Action
- Deleting ADF Table Component Rows in the Fusion Web Application
- Batch Processing in an ADF Table Component
- Special Columns in the ADF Table Component
- Configuring ADF Table Component Key Column
- Adding a Dynamic Column to Your ADF Table Component
- Adding a ModelDrivenColumnComponent Subcomponent to Your ADF Table Component
-
Configuring an ADF Table Component to Resize Columns Based on Data at Runtime
- How to Configure an ADF Table Component to Resize Columns at Runtime
- How to Configure an Action Set to Resize Columns of an ADF Table Component at Runtime
- What Happens at Runtime: How the ADF Table Columns are Resized
- What You May Need to Know About Resizing Columns of an ADF Table Component at Runtime
- Grouping Columns Together in an ADF Table Component
- Configuring an ADF Table Component to be Read-only
- Creating an ADF Read-Only Table Component
- Limiting the Number of Rows Your Table-Type Component Downloads
- Tracking Changes in an ADF Table Component
- Evaluating EL Expressions for ReadOnly Properties
- Displaying Error Messages in an Error Message Column
-
8
Working with Lists of Values
- About List of Values in an Integrated Excel Workbook
- Creating a List of Values in an Excel Worksheet
- Creating a List of Values in an ADF Table Component Column
- Adding a Model-Driven List Picker to an ADF Table Component
-
Creating Dependent Lists of Values in an Integrated Excel Workbook
- How to Create Dependent Lists of Values in Excel Worksheets
- What Happens at Runtime: How an Excel Worksheet Renders a Dependent List of Values
- How to Create Dependent Lists of Values in ADF Table Component Columns
- What Happens at Runtime: ADF Table Component Column Renders a Dependent List of Values
-
9
Adding Interactivity to Your Integrated Excel Workbook
- About Adding Interactivity to an Integrated Excel Workbook
-
Using Action Sets
- How to Invoke a Method Action Binding in an Action Set
- How to Invoke Component Actions in an Action Set
- What You May Need to Know About an Action Set Invoking a Component Action
- How to Invoke an Action Set from a Worksheet Event
- How to Display a Progress Bar while an Action Set Executes
- What Happens at Runtime: How the Action Set Displays a Status Message
- What You May Need to Know About Progress Bars
- How to Allow End Users to Continue Working in Excel While an ActionSet Executes
- What Happens at Runtime: How End Users Continue Working While an ActionSet Executes
- What You May Need to Know About Canceling an Action
- How to Provide an Alert After the Invocation of an Action Set
- What Happens at Runtime: How the Action Set Provides an Alert
- How to Configure Error Handling for an Action Set
- How to Prompt the User for Confirmation in an Action Set
- What Happens at Runtime: How the Action Set Prompts the User for Confirmation
- Configuring the Runtime Ribbon Tab
-
Displaying Web Pages from a Fusion Web Application
- How to Display a Web Page in a Popup Dialog
- How to Display a Web Page Search Form in a Popup Dialog
- How to Display a Web Page in ADF Desktop Integration Runtime Task Pane
-
What You May Need to Know About Displaying Pages from a Fusion Web Application
- Sending Data Between an Integrated Excel Worksheet and a Fusion Web Application Page
- Sharing Data Control Frames Between Integrated Excel Worksheets and Fusion Web Application Pages
- Configuring a Fusion Web Application for ADF Desktop Integration Frame Sharing
- Localizing Fusion Web Application Pages
-
Using Row-Level Action Sets in a Table Column
- How to Enable Row-Level Action Set Model Management
- What Happens at Runtime: RowActionSetModelMgmtEnabled is Set to True
- How to Synchronize Changes from ADF Table Component Using RowUpSyncNoFail
- What Happens at Runtime: RowUpSyncNoFail Action is Invoked
- How to Add a Custom Popup Picker Dialog to an ADF Table Column
- Using EL Expression to Generate an Excel Formula
- Using Calculated Cells in an Integrated Excel Workbook
- Configuring Automatic Row Refresh in an ADF Table Component
- Using Macros in an Integrated Excel Workbook
-
10
Configuring the Appearance of Your Integrated Excel Workbook
- About Configuring the Appearance of an Integrated Excel Workbook
- Working with Styles
- Applying Styles Dynamically Using EL Expressions
- Using Labels in an Integrated Excel Workbook
- Branding Your Integrated Excel Workbook
- Displaying Tooltips in ADF Desktop Integration Components
- Using Worksheet Protection
- Using ADF Desktop Integration EL-based Properties with Custom Attribute Properties
- 11 Internationalizing Your Integrated Excel Workbook
- 12 Securing Your Integrated Excel Workbook
-
13
Adding Validation to Your Integrated Excel Workbook
- About Adding Validation to an Integrated Excel Workbook
- Using the Status Viewer to Report Error Messages to End Users
- Providing Data Entry Validation for an Integrated Excel Workbook
- Providing Server-Side Validation for an Integrated Excel Workbook
- Providing a Row-by-Row Status on an ADF Table Component
- Adding Detail to Error Messages in an Integrated Excel Workbook
- Handling Data Conflicts When Uploading Data from a Workbook
- 14 Testing Your Integrated Excel Workbook
-
15
Deploying Your Integrated Excel Workbook
- About Deploying Your Integrated Excel Workbook
- Making ADF Desktop Integration Available to End Users
- Publishing Your Integrated Excel Workbook
- Deploying a Published Workbook with Your Fusion Web Application
-
Passing Parameter Values from a Fusion Web Application Page to a Workbook
- How to Configure the Fusion Web Application's Page to Pass Parameters
- How to Configure Parameters Properties in the Integrated Excel Workbook
- How to Configure the Page Definition File for the Worksheet to Receive Parameters
- What Happens at Runtime: How Parameters Are Passed from a Fusion Web Application to the Integrated Excel Workbook
- Customizing Workbook Integration Metadata at Runtime
- Integrating ADF Workbook Composer into Your Fusion Web Application
- 16 Using an Integrated Excel Workbook Across Multiple Web Sessions
-
17
Administering ADF Desktop Integration
- Installing and Upgrading ADF Desktop Integration
- Running the Client Health Check Tool
- ADF Desktop Integration Logs
- Security in ADF Desktop Integration
- Verifying the Client Version of ADF Desktop Integration
- Verifying Integrated Excel Workbook Metadata
- Common ADF Desktop Integration Error Messages and Problems
-
A
ADF Desktop Integration Component Properties and Actions
- Frequently Used Properties in the ADF Desktop Integration
- ADF Input Text Component Properties
- ADF Output Text Component Properties
- ADF Label Component Properties
- ADF List of Values Component Properties
- ADF Image Component Properties
- ADF Input Date Component Properties
- ModelDrivenColumnComponent Subcomponent Properties
- TreeNodeList Subcomponent Properties
- ADF Table Component Properties and Actions
- ADF Read-only Table Component Properties and Actions
- Action Set Properties
- Workbook Actions and Properties
- Worksheet Actions and Properties
- ADF Desktop Integration Compatibility Properties
- B ADF Desktop Integration EL Expressions
-
C
Troubleshooting an Integrated Excel Workbook
- Verifying That Your Fusion Web Application Supports ADF Desktop Integration
- Generating ADF Desktop Integration Diagnostic Reports
- Troubleshooting Connection Problems to Fusion Web Applications
- Verifying End-User Authentication for Integrated Excel Workbooks
- Generating Log Files for an Integrated Excel Workbook
- D ADF Desktop Integration Settings in the Web Application Deployment Descriptor
- E Java Data Types Supported By ADF Desktop Integration
- F Using the ADF Desktop Integration Model API
- G End User Actions