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.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"
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.
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 |
---|---|
Host Name |
The host name for your database. For example:
|
JDBC Port |
The port for your database. For example:
|
SID |
The SID of your database. For example:
|
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.
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.
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.
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.
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".
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.
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".
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.
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".
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".
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".