2 Introduction to the Oracle ADF Desktop Integration Sample Application

This chapter provides an overview of the Master Price List module which is the Oracle ADF Desktop Integration module's sample application. The Master Price List module is a module in the Fusion Order Demo application. It contains several Microsoft Excel workbooks that are integrated with a Fusion web application.

This chapter includes the following sections:

Section 2.1, "Introduction to the Master Price List Module"
Section 2.2, "Setting Up and Executing the Master Price List Module"
Section 2.3, "Overview of the Integrated Excel Workbooks in the Master Price List Module"

2.1 Introduction to the Master Price List Module

The Master Price List module allows end users to download information (product names, prices, and so on) about electronic devices that are sold through a storefront-type web application. End users can search the downloaded information, modify pricing information, and upload the modified information to the Fusion web application.

You must set up your development environment before you can set up and run the Master Price List module. After you set up your development environment, you can download the Fusion Order Demo application, which includes the Master Price List module.

2.2 Setting Up and Executing the Master Price List Module

Set up your development environment as described in Chapter 3, "Setting Up Your Development Environment" so that you can run the Master Price List module.

Once you have set up your development environment, download the Fusion Order Demo application, which includes the Master Price List module. For information about how to download the Fusion Order Demo application, see the "How to Download the Application Resources" section in the Oracle Fusion Middleware Fusion Developer's Guide for Oracle Application Development Framework.

The Fusion Order Demo application that you download includes a directory named Infrastructure. This directory includes scripts that create the users and data that the Fusion Order Demo application and Master Price List module require. For information about how to run these scripts, see the "How to Install the Fusion Order Demo Schema" section in the Oracle Fusion Middleware Fusion Developer's Guide for Oracle Application Development Framework.

To execute the Master Price List module:

Open the MasterPriceList.jws file in JDeveloper.

This file is located in the MasterPriceList subdirectory of the directory into which you extracted the Fusion Order Demo application.
In the Application Navigator, click the Application Resources accordion title to expand the panel.
Right-click FOD connection and choose Properties.

In the Edit Database Connection dialog, modify the connection information shown in Table 2-1 for your environment.

Table 2-1 Database Connection Properties for Master Price List Module

Property Description

Property	Description
Host Name	The host name for your database. For example: `localhost`
JDBC Port	The port for your database. For example: `1521`
SID	The SID of your database. For example: `ORCL` or `XE`

Host Name

The host name for your database. For example:

localhost

JDBC Port

The port for your database. For example:

1521

SID

The SID of your database. For example:

ORCL or XE

Do not modify the user name and password fod/fusion. These must remain unchanged. Click OK.

In the Application Navigator, right-click Model and choose Rebuild Model.jpr.
In the Application Navigator, right-click ViewController and choose Rebuild ViewController.jpr.
In the Application Navigator, expand the ViewController project, right-click login.jspx and choose Run.

The login.jspx page runs and displays a login form.
To log on as an administrator, enter sking in the User Name field and welcome1 in the Password field. To log on as a manager, enter ahunold in the User Name field and welcome1 in the Password field. For more information about users, see Section 2.3.1, "Log on to the Fusion Web Application from an Integrated Excel Workbook".

You can now open and connect the integrated Excel workbooks described in Section 2.3, "Overview of the Integrated Excel Workbooks in the Master Price List Module" to the Fusion web application that the Master Price List module deploys.

2.3 Overview of the Integrated Excel Workbooks in the Master Price List Module

The Master Price List module provides the EditPriceList.xlsx, AdvEditPriceList.xlsx and ReadOnlyPriceList.xlsx integrated Excel workbooks. All workbooks allow end users to:

Log on to the Fusion web application from the workbook
Download rows of data about product pricing
Search the workbook for information it contains about product pricing

In addition, the EditPriceList.xlsx and AdvEditPriceList.xlsx workbooks permits end users to:

Search the Master Price List module Fusion web application for information about products and product pricing
Modify product pricing information in the workbook
Use Excel formulas to perform calculations on values in an ADF Table component
Upload modified product pricing information to the Master Price List module Fusion web application from the workbook

Subsequent sections in this chapter provide more information about the functionality in the workbooks along with cross-references to implementation details.

2.3.1 Log on to the Fusion Web Application from an Integrated Excel Workbook

At runtime, both workbooks in the Master Price List module render a menu that allows end users to log on to the Fusion web application. Figure 2-1 shows the runtime menu in the EditPriceList.xlsx workbook.

Figure 2-1 Runtime Menu

Runtime Menu in the EditPriceList.xlsx workbook

The EditPriceList.xlsx workbook prompts the end user to log on to the Fusion web application when the end user clicks Login or invokes an action that requires a connection with the Fusion web application. Because the worksheet Startup event in the EditPriceList.xlsx workbook invokes the ADF Table component Download action, end users are prompted to log on immediately after starting up the EditPriceList.xlsx workbook.

The Login menu item is a workbook menu item that invokes the workbook Login action. For information about configuring the Login menu item (and other menu items in Figure 2-1), see Section 8.3, "Creating Menu Items".

The workbook Login action invokes the Fusion web application's authentication process. For more information about implementing this functionality, see Chapter 11, "Securing Your Integrated Excel Workbook".

The Master Price List module provides two user profiles to log in to the application. Table 2-2 summarizes both user profiles.

Table 2-2 User Profiles for Master Price List Module

Login Name	Password	Role	Description
sking	welcome1	Administrator	Enables you to access and modify information.
ahunold	welcome1	Manager	Enables you to access information, but not to modify it.

2.3.2 Download Rows of Data About Product Pricing

The EditPriceList.xlsx workbook uses an ADF Table component to host information downloaded from the Fusion web application about product pricing. This component allows end users to edit rows and upload modified rows to the Fusion web application.

The following sections provide information about how to implement the download functionality:

Each worksheet that you integrate with a Fusion web application requires an associated page definition file. The Price List worksheet in the EditPriceList.xlsx workbook is associated with the ExcelPriceListPageDef.xml page definition file. In the Application Navigator, expand the following nodes to view this file:

ViewController > Application Sources > oracle.foddemo.masterpricelist > view > pageDefs

For information about how to configure a page definition file, see Section 4.3, "Working with Page Definition Files for an Integrated Excel Workbook".
The ADF Table component Download action downloads data from the Fusion web application to the worksheet. For information about how you invoke this action, see Section 7.6, "Configuring Oracle ADF Component to Download Data to an ADF Table Component".
In the EditPriceList.xlsx workbook, the worksheet Startup event invokes an action set that includes the ADF Table component Download action. For information about configuring worksheet events, see Section 8.2.4, "How to Invoke an Action Set from a Worksheet Event".

The ReadOnlyPriceList.xlsx workbook uses an ADF Read-only Table component to download data from the Fusion web application about product pricing. End users can view this data, but they cannot modify data or save changes to the Fusion web application.

The following sections provide information about how to implement the download functionality of the ReadOnlyPriceList.xlsx workbook:

For information about creating an ADF Read-only Table component, see Section 7.15, "Creating an ADF Read-Only Table Component".
An ADF Button component is configured to invoke an action set that includes the ADF Read-only Table component Download action. For information about creating an ADF Button component, see Section 6.2, "Inserting an ADF Button Component".

2.3.3 Simple Search for Products in the Workbooks

Both the EditPriceList.xlsx and the ReadOnlyPriceList.xlsx workbooks have ADF components configured to provide end users with a search form. End users can enter a search term in the form to invoke a query on the Fusion web application and download the results to the workbook. Figure 2-2 shows a runtime view of these components in the EditPriceList.xlsx workbook.

Figure 2-2 Runtime View of a Simple Search Form in the EditPriceList.xlsx Workbook

The following sections provide information about how to implement a simple search form that you can use in the EditPriceList.xlsx workbook:

For information about creating a search form, see Section 8.6, "Creating ADF Databound Search Forms in an Integrated Excel Workbook".
For information about creating a form, Section 8.7, "Adding a Form to an Integrated Excel Workbook".

2.3.4 Advanced Search for Products in the Edit Price List Workbook

The EditPriceList.xlsx workbook has search functionality configured that allows an end user to invoke a page from the Fusion web application, specify search criteria, and download the results to the ADF Table component in the workbook. Figure 2-3 shows the page from the Fusion web application that end users invoke by clicking the Advanced Search button.

Figure 2-3 Advanced Search Dialog in the EditPriceList.xlsx Workbook

For more information about how to implement the advanced search functionality in the EditPriceList.xlsx workbook, see Section 8.6, "Creating ADF Databound Search Forms in an Integrated Excel Workbook".

2.3.5 Modify Product Pricing Information in the Edit Price List Workbook

End users of the EditPriceList.xlsx workbook can edit product pricing information that the ADF Table component downloads from the Fusion web application. Columns in the runtime ADF Table component that have an UpdateComponent property configured permit end users to modify values and upload the changes to the Fusion web application. For example, end users can modify the values that appear in the ProductId, ProductName, and CostPrice columns.

End users can enter or modify the values that appear in the cells of other columns. However, the ADF Table component does not upload these changes to the Fusion web application, because some of these columns display the results of evaluating Excel formulas using values downloaded from the Fusion web application. Such columns should use a read-only style to distinguish themselves from other columns. For example, the Difference column displays the result of an Excel formula that subtracts the cost price from the list price and uses a read-only style, which makes it easily distinguishable from other input columns.

Other columns, such as Status and Changed, appear in the ADF Table component to provide status information about upload operations and changed columns.

The following sections provide information about how to implement this functionality:

For information about inserting an ADF Table component, see Section 7.3, "Inserting an ADF Table Component into an Excel Worksheet".
For information about using Excel formulas, see Section 8.10, "Using Calculated Cells in an Integrated Excel Workbook".
For information about special columns, such as Status and Changed, see Section 7.11, "Special Columns in the ADF Table Component".

2.3.6 Upload Modified Product Information to the Fusion Web Application

The EditPriceList.xlsx workbook allows end users to upload modified data in the ADF Table component to the Fusion web application. An action set is configured for the runtime Save Changes button that invokes the ADF Table component's Upload action. For information about implementing this functionality, see Section 7.8, "Configuring an Oracle ADF Component to Upload Changes from an ADF Table Component".