ADF Desktop Integration 12c Component and Feature Demo

An Oracle JDeveloper How To Document
Written by James Amalraj, Arunkumar Ramamoorthy, Sireesha Pinninti, Gayathri Sekar and Dhiraj Shivpriya, Oracle Corporation
Created : February, 2010
Updated : August, 2013

Introduction

ADF Desktop Integration or ADFdi is one of the features of  Oracle ADF that enables desktop integration with MS Excel spreadsheets to manage large volumes of data from web applications via Excel.
ADF Desktop Integration 12c component and feature demo application is a collection showcasing the capabilities of the components and features of ADF Desktop Integration.

Components covered

  • ADF Input Text
  • ADF Output Text
  • ADF Label
  • ADF Button
  • ADF List of Values
  • ADF Table
  • ADF Read-only Table

Features covered

  • Form with DLOV
    • Form with Navigation Buttons and DML operations
    • Dependent List of Values
    • Worksheet Errors
    • Attribute Hints
    • Internationalization
  • Form with Webpicker and RSDC
    • Web Picker
    • Restore Server Data Context
    • Double-click ActionSet
  • Table with DLOV
    • List of Values in Table Column
    • Dependent List of Values in Table Column
    • Table Errors
    • Worksheet Menu Items
  • Table with Webpicker
    • Web Picker
    • Workbook Menu Items
    • Upload All-Or-Nothing
  • Custom Upload Options
    • Custom Upload Options
    • Excel Validation
    • Entity level Validation
  • Table with Custom Download For Insert
    • Custom Download For Insert
    • Worksheet Events
  • Search Form with Resultant ROT
    • Databound Search Form
    • Dynamically Generated Hyperlink
    • Excel formula in Table Column
  • Master Form-Detail ROT
    • Master Form - Detail Table
    • Calculated fields
  • Table with Dynamic Columns
    • Dynamic Columns in Table
    • Styles Based on EL Expressions
    • Row Limit
  • Table with Polymorphic VOs
  • Hierarchical Table
    • Model API
  • Overriding reserved resource bundle
  • Custom Error Handling
  • Worksheet Protection
  • Support for merged cells in form components
  • Default runtime values for resource properties
  • Progress bar

Software Requirement

Pre-requisites

Running and Invoking Demo application

  1. Download the application from here and extract it (extracted location is referred as APPLICATION_HOME)
  2. Run the SQL Script included with the application (APPLICATION_HOME/DBSchema/cfdemocreateschema.sql) by connecting as sys user to create a new schema (adfdi)
  3. Run the SQL Script included with the application (APPLICATION_HOME/DBSchema/cfdemopopulateschema.sql) by connecting as newly created user (adfdi) to create the tables and populate data
  4. Open the application in Jdeveloper
  5. Modify the database connections to point to database on which the sql script has been run by following the below steps
    1. Invoke the Project Properties of the Model project
    2. Select Business Components node
    3. Change the connection details by clicking on the edit (pencil) icon
    4. Save and Compile all the projects
    5. Run the adfc-config.xml file available under View Controller project to start the Integrated WLS, deploy the Application and to run the page
    6. Follow the below steps for running the Component Demo Workbook
      1. Download the Component Demo workbook and save it to the local file system (ex: to Desktop)
      2. Open the workbook saved to the local file system
      3. Click on Yes in the connection confirmation dialog
      4. Follow the hints given in the workbook to complete the demo
    7. Follow the below steps for running the Feature Demo Workbook
      1. Download the Feature Demo Workbook and save it to the local file system (ex: to Desktop)
      2. Open the workbook saved to the local file system
      3. Click on Yes in the connection confirmation dialog
      4. Follow the hints given in the workbook to complete the demo
    8. Follow the below steps for downloading the search results into Excel workbook
      1. Click on the Go to Search Page link
      2. Enter the search criteria in the Enter Product Name field and hit the Search Products By Name button
      3. Click on Export Result to Excel button and save the workbook to local file system (ex: to Desktop)
      4. Open the workbook saved to the local file system
      5. Click on Yes in the connection confirmation dialog
      6. Follow the hints given in the workbook to complete the demo

Hint: Design Time Workbooks can be found under APPLICATION_HOME/ViewController/src/oracle/adfdi/demo/cf/view/excel/dt folder
Note: Workbook definition XML files that are present along with DT workbooks are generated while publishing workbooks, refer 14.3.3 What Happens When You Publish an Integrated Excel Workbook for more information