Using Some Additional New Features in Oracle Application Express 3.1

Purpose

This tutorial shows you how to use some additional new features in Oracle Application Express 3.1.

Time to Complete

Approximately 25 minutes

Topics

This tutorial covers the following topics:

 Overview
 Prerequisites
 Creating a Master-Detail Application
 Adding a Custom Theme to the Theme Repository
 Creating a Report with a Search Bar
 Summary
 Related Information

Viewing Screenshots

 Place the cursor over this icon to load and view all screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. You can hide an individual screenshot by clicking it.

Overview

In this tutorial, you examine the following new features:

Custom Themes: In addition to the default themes provided with Oracle Application Express, you can create your own customized themes. This enables you to design a very specific look and feel to meet your corporate requirements and then publish this as a theme for all other applications to use. This can be done at the workspace level (Workspace Themes) or at the instance level (Public Themes). Two new standard themes have also been added.

Master Detail Application: You can now create master detail reports in the create application wizard.

Search Region Creation: The ability to add a search region when creating a report.

To get more information about the 3.1 New Features, click here.

Back to Topic List

Prerequisites

Before you perform this tutorial, you should:

1.

Install Oracle Database 9.2 or above.

2.

Download and Configure Oracle Application Express 3.1.

3.

Download the OEHR Sample Objects Packaged Application here and import it into your Oracle Application Express 3.1 instance.

4.

Download and unzip the apexnf.zip file which contains files necessary to perform this tutorial

5.

To perform this tutorial, you need to perform the Building and Customizing an Interactive Report in Oracle Application Express 3.1 tutorial. Alternatively, you can import the OBE New Features application as a packaged application in Application Express. Download and unzip the apexnf.zip file and import the irrobe_packagedapp.sql packaged application file.

Back to Topic List

Creating a Master Detail Application

In Oracle Application Express 3.1, you can create a master detail application. In prior releases, you could only create a master-detail page. Perform the following steps:

1.

Navigate to the Application Builder page. Click Create.

 

2.

Select Create Application and click Next.

 

3.

Enter an application name and click Next.

 

4.

Select Master Detail for Page Type and select OEHR_DEPARTMENTS for Master Table Name and OEHR_EMPLOYEES for Detail Table Name and click Add Page.

 

5.

The Master Detail pages were created, click Next.

 

6.

Accept the default and click Next.

 

7.

Accept the default and click Next.

 

8.

You can define a date format that will be used throughout your application. This date format will be used to alter the NLS_DATE_FORMAT database session setting prior to showing or submitting any page within the application. This format is used by all reports showing dates and is also picked up by form items of type 'Date Picker (use Application Date Format)'. This can be set using:

  1. Application Builder > Application Builder Defaults (under Tasks): These are specific to a Workspace, not a developer, and will be used as the default when using the create application wizard.
  2. Application Builder > Create Application Wizard > Attributes page
  3. Application Builder > Your Application > Shared Components > Edit Globalization Attributes

Select an Application Date Format for your Application and click Next.

 

9.

Select theme 20 and click Next.

 

10.

Click Create.

 

11.

Your application was created successfully. Click Run Application.

 

12.

Login as the same user you logged in to Application Express and click Login. Your report is displayed. Select the edit icon for one of the rows.

 

13.

The master detail form is displayed. Click the Application breadcrumb in the developer toolbar.

 

Back to Topic List

Adding a Custom Theme to the Theme Repository

In Oracle Application Express 3.1, you can add a custom theme to the Theme Repository, either at the Workspace or Instance level. Perform the following steps:

1.

From the Human Resources Application home page, click Shared Components.

 

2.

Under User Interface, select the Themes link.

 

3.

It is best practice not to modify a prepackaged theme. If you want to make changes, you can copy an existing theme and make changes to the copy. In the Tasks menu on the right side of the window, select the Copy Theme link.

 

4.

Enter 120 for the Theme Identification Number. The number must be higher than 100. Then click Next.

 

5.

Click Copy Theme.

 

6.

Your theme was copied. You now want to modify the copied theme. In the Tasks menu, select the Edit Theme link.

 

7.

Select Modern Blue link for the theme 120.

 

8.

Change the name of the theme to something else. You can also change the image to differentiate it from the standard image. Select Yes for Custom Image and select the alt_theme.png from the files provided in the prerequisites and click Apply Changes.

 

9.

Your theme was updated. Note that you can edit the templates in the theme to have the look and feel that you want. This should be done and tested thoroughly before promoting the theme to a workspace theme. By promoting the theme to a workspace theme, you make it available to other applications in this workspace. Under the tasks menu, select the Manage Workspace Themes link.

 

10.

Select Create and click Next.

 

11.

Select theme 120 for Application Theme to Copy and click Next.

 

12.

You can change the name and number of the workspace theme. Accept the default and click Next.

 

13.

Click Create Workspace Theme.

 

14.

Your workspace theme was created successfully. Note that workspace themes are not editable. If you need to make changes, you create an application based upon the theme, edit the theme within the application and then drop the old workspace theme and create the modified one as a new workspace theme (workspace themes can not be replaced currently).

Now you can create a new application and select the workspace theme you just created. Select the Application Builder breadcrumb

 

15.

At the Application Builder page, click Create.

 

16.

Accept the default and click Next.

 

17.

Enter a name for your Application and click Next.

 

18.

Make sure Blank is select for the Page Type and enter Home for the name and click Add Page.

 

19.

Click Next.

 

20.

Accept the default and click Next.

 

21.

Accept the default and click Next.

 

22.

Accept the default and click Next.

 

23.

Select the workspace theme 120 you created and click Next.

 

24.

Click Create.

 

25.

Your application was created successfully. In the next section, you create a report and enable a search bar.

 

Back to Topic List

Creating a Report with a Search Bar

When you create a report page, you can now include a search bar. Perform the following steps:

1.

From your application page, click Create Page.

 

2.

Click Report for page type.

 

3.

Click SQL Report for Report type.

 

4.

Enter Location Information for the Name and click Next.

 

5.

Accept the default and click Next.

 

6.

Enter the following query and click Next.

select * from oehr_locations

 

7.

Enter Location List for Region Name, select Yes for Enable Search. A list of varchar columns from within your query is then displayed. Select both STREET_ADDRESS and STATE_PROVINCE and click > (or click >> which brings over all the columns). Note: These columns will be included in the resulting where clause. Click Next.

 

8.

Click Finish.

 

9.

Click Run Page.

 

10.

Your report is displayed with the search bar at the top. Enter South and click Go.

 

11.

Even though there were two cities that contained the word South, only one record was display because the column CITY was not selected to be searched on when you created the page.

 

Back to Topic List

Summary

In this tutorial, you learned how to:

 Create a Custom and Workspace Theme
 Create a master-detail application
 Create a report with a search bar

Back to Topic List

Related Information

To learn more about Application Express, you can review the following:

Related Documentation

Description

Online Help

To access this help, click the Help button displayed in the top right corner of Application Express. Search on topics of interest.

Release Notes

These notes contain important information not included in the Oracle Application Express documentation.

Installation Guide

This guide explains how to install and configure Oracle Application Express.

2 Day + Developer’s Guide

This guide shows you how to set up a development environment or access a hosted demonstration environment to use with this guide. It then walks you through building an initial application, modifying it, and previewing it.

User’s Guide

This guide describes how to use the Oracle Application Express development environment to build and deploy database-centric Web applications. Oracle Application Express turns a single Oracle database into a shared service by enabling multiple workgroups to build and access applications as if they were running in separate databases.

Advanced Tutorial

Tutorials with step-by-step instructions that explain how to create a variety of application components and entire applications using the Oracle Application Express development environment.

Back to Topic List

 Place the cursor over this icon to hide all screenshots.

 

 

 

Left Curve
Popular Downloads
Right Curve
Untitled Document