The following topics introduce the new and changed features of ADF Desktop Integration and other significant changes that are described in this guide, and provides pointers to additional information. This document is the new edition of the formerly titled Desktop Integration Developer's Guide for Oracle Application Development Framework.
For changes made to Oracle JDeveloper and Oracle Application Development Framework (Oracle ADF) for this release, see the What's New page on the Oracle Technology Network at
Oracle ADF Desktop Integration 12c (12.1.2) includes the following new and changed development features for this document.
All procedures and graphics have been updated to use Windows 7 as the primary Windows Operating System.
All demo examples and graphics have been updated to use Summit Sample Application for ADF Desktop Integration.
Some Administrator-related content has been moved to Administering Oracle ADF Applications.
System requirements and installation instructions have been updated. See Section 3.4, "Installing ADF Desktop Integration."
Add integrated Excel workbook to a project in JDeveloper. See Section 4.2, "Adding an Integrated Excel Workbook to a Fusion Web Application."
Create and configure ADF Desktop Integration Page Definition file. See Section 4.3, "Working with Page Definition Files for an Integrated Excel Workbook."
Double-click to edit a component. See Section 5.6, "Using the Property Inspector."
Export and import Excel workbook integration metadata. See Section 5.15, "Exporting and Importing Excel Workbook Integration Metadata."
Insert components in merged cells. See Section 6.1, "About ADF Desktop Integration Form-Type Components."
UploadAllOrNothing, which allows rows to get committed if none of the changed (or new) rows fail. See Section 7.9, "Configuring an ADF Table Component to Upload Changes Using UploadAllOrNothing Action."
New feature, Explicit Worksheet Setup Action, which allows user to customize the data (or the binding container) before the client retrieves the binding container metadata. See Section 7.22, "Using Explicit Worksheet Setup Action."
ComponentAction. Section 8.2.2, "How to Invoke Component Actions in an Action Set."
Visual status progress bars. See Section 8.2.5, "How to Display a Status Message While an Action Set Executes" and Section 8.2.7, "What You May Need to Know About Progress Bars."
Worksheet authorization through ADF Desktop Integration page definition. See Section 11.5, "Authorizing the Excel Workbook User."
Track and detect time zone change. See Section H.7, "Handling Time Zone Conversion."
For 12c (12.1.2), this document has been updated in several ways, to include corrections and clarifications. In addition, the following significant changes or additions have occurred in these sections:
Chapters now include a "Use Cases and Examples" section.
All Introduction sections in chapters have been renamed to "About ..."
Updated Section 3.6.1, "How to Migrate an Integrated Excel Workbook to the Current Version of ADF Desktop Integration" to include migration information while using workbooks integrated with older, or newer versions, of ADF Desktop Integration.
Updated Section 3.7, "Using an Integrated Excel Workbook with Older Versions of ADF Desktop Integration" to describe compatibility of a workbook created, or updated, by a newer version of ADF Desktop Integration on a system running an older version of ADF Desktop Integration.
Added a section to describe how to remove a component from integrated Excel workbook. See Section 5.14, "Removing ADF Desktop Integration Components."
Revised various sections in Chapter 7, "Working with ADF Desktop Integration Table-Type Components" to:
include information that a table component should not be inserted in a merged cell, and wide tables (a table with many columns) gives slow performance. See Section 7.3, "Inserting ADF Table Component into Excel Worksheet."
add a custom method action that creates one or more
status_initialized rows in the iterator. See Section 7.5, "Configuring a Worksheet to Download Data as Pending Insert Rows in an ADF Table component."
include information that the
DownloadFlaggedRows action does not apply to inserted rows. See Section 7.11.2, "Row Flagging in an ADF Table Component."
include information that the first column of the ADF Read-only Table contains important data used by the table component, and it must not be removed. See Section 7.17, "Creating an ADF Read-Only Table Component."
Added a section to describe how EL expressions for ReadOnly properties are evaluated while downloading and uploading data. See Section 7.21, "Evaluating EL Expression for ReadOnly Properties."
Revised various sections in Section 8, "Adding Interactivity to Your Integrated Excel Workbook" to:
document default values of the
Prompt properties, if they are empty. See Section 8.2.12, "What Happens at Runtime: How the Action Set Provides a Confirmation."
add a note about toolbar ribbon controls that they are shared among all open integrated workbooks. See Section 8.3.2, "How to Configure a Worksheet Command for the Runtime Ribbon Tab."
include information about web pages displayed with the
Dialog action that they are rendered using a .NET Web Browser control, which leverages the local Internet Explorer installation. See Section 8.4.3, "What You May Need to Know About Displaying Pages from a Fusion Web Application."
add a note that evaluated EL expressions in Excel formula should not have no more than 255 characters. See Section 8.9, "Using EL Expression to Generate an Excel Formula."
Updated Section 10.2.1, "How to Register a Resource Bundle in an Integrated Excel Workbook" to add information about file extensions that they should not be included while registering a resource bundle class.
Revised following sections for clarity:
Updated Section 14.2, "Making ADF Desktop Integration Available to End Users" to update the path of
Updated Section 14.4, "Deploying a Published Workbook with Your Fusion Web Application" to describe runtime behavior after a workbook is published.
Updated Section C.4, "Common ADF Desktop Integration Error Messages and Problems" to add more error messages.
Revised Section H.1, "Installing, Upgrading, and Removing the Runtime Edition of ADF Desktop Integration" to include the fully qualified path limit of the directory where set up files of the runtime edition of ADF Desktop Integration are extracted.
Added a section to describe how to upgrade the runtime edition of ADF Desktop Integration on a local system. See Section H.1.3, "How to Upgrade the Runtime Edition of ADF Desktop Integration On a Local System."