Understanding Page Types in the Create Page Wizard

Run the Create Page Wizard to add a new page to existing application. How the wizard works depends upon the type of page your are creating.

Tip:

Universal Theme - 42 is optimized to work equally well in either a mobile or desktop environment. In previous releases and in earlier themes, the Mobile user interface is based on jQuery Mobile. Oracle recommends migrating existing mobile applications to the Universal Theme as soon as possible.

Available Component Page Types

Learn about available components when running the Create Page Wizard using the Universal Theme.

Table 7-1 Desktop Applications — Component Types

Page Type Description To Learn More

Blank Page

Creates a page with no built-in functionality.

See online Help when creating this page.

Report

A report is the formatted result of a SQL query. Report options include:

  • Interactive Report

  • Interactive Grid

  • Classic Report

  • Report and Form on Table

  • List View (Optimized for mobile)

  • Column toggle Report (Optimized for mobile)

  • Reflow Report (Optimized for mobile)

  • Report on Web Service

See:

Form

Forms enable users to update a single row or multiple rows in a table. Form options include:

  • Report with Form on Table

  • Report with List View on Table (Optimized for mobile)

  • Editable Interactive Grid

  • Form on a Table

  • Form on a Procedure

  • Form on a SQL Query

  • Form on a Web Service

  • Report and Form on a Web Service

See:

Master Detail

Create a master detail form that enables users to query, insert, update, and delete values from related tables or views. You choose the tables on which to build the master and detail regions. Master Detail options include:

  • Stacked - Creates a single page master detail with editable interactive grids.

  • Side by Side - Creates a single page (or Side by Side) master detail utilizing side by side layout and report regions with modal edit windows. The left side contains a master list to navigate to the master record. The right side contains the selected master record and the associated detail report.

  • Drill Down - Creates a two page (or Drill Down) master detail. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail.

See:

Plug-ins

Creates a new page based on a region type plug-in. Plug-ins enable developers to declaratively extend, share, and reuse the built-in types available with Oracle Application Express.

See "Importing a Plug-in from the Plug-in Page"

Chart

Enables you to create graphical charts.

See "Creating Charts"

Dashboard

Creates a first-cut dashboard based on sample data that you can easily customize using Page Designer. Choose from a number of different chart layouts as the starting point for your page.

See online Help when creating this page.

Calendar

Generates a calendar with monthly, weekly, and daily views.

See "Creating Calendars"

Tree

Creates a tree to graphically communicate hierarchical or multiple level data and optionally navigating to a page or URL specific to each tree node.

See "Managing Trees"

Wizard

Create a collection of pages to be used as a wizard. Generally wizards are used for entering data across multiple steps.

See online Help when creating this page.

Data Loading

Creates a Data Loading wizard allowing the end user to manage the loading of data into a table to all schemas for which the user has privileges.

See "Creating Applications with Data Loading Capability"

Legacy Page

Legacy pages contains components Oracle still supports but does not recommend using. Options include:

  • Tabular Form

  • Legacy Master Detail

  • AnyChart Chart

  • Summary Page

  • Legacy Calendar

See "Managing Application Legacy Components"

Available Features Page Types

Learn about available features when running the Create Page Wizard using the Universal Theme.

This table lists available Features for Desktop Applications when running the Create Page Wizard.

Table 7-2 Create Page Wizard — Features

Page Type Description To Learn More

About Page

Include an About this Application page which features a description field that describes the application, includes the application version, and a count of the number of pages

See online Help when creating feature.

Access Control

Creates pages to manage an access control list. Use the Application Access Control shared component to associate application roles with application users. This wizard also adds a readercontributor and administrator role and corresponding authorization scheme to your application. Apply these authorization schemes to pages and page components to manage access by user and role.

See "Controlling Access to Applications, Pages, and Page Components"

Activity Monitoring

Include numerous reports on end user activity for your application. Determine the most active users, the most used pages, the performance of pages, and errors raised, to better understand how your application is being utilized and areas for improvement.

Not applicable.

Configuration Options

Enables application administrators to enable or disable specific functionality within the application. This feature is useful if you select features that need additional development effort before they can be used by end users.

You can expand this feature to application-specific features. If developers define additional build options and associate them with specific functionality throughout the application, then they can be added to the configuration settings for administrators.

Not applicable.

Email Reporting

Include numerous reports on emails queued from this application, emails sent, and errors sending emails.

Not applicable.

Feedback

Feedback provides a mechanism for end users to post general comments for application administrators and developers. The posts include useful session state information to help developers determine where the end user sent the feedback from.

Creating Feedback:

  • Creates Navigation bar icon which users can click to leave feedback.

  • Creates an report for viewing and updating feedback.

  • Captures the application and page ID, feedback comments, date and time, and user information.

See "Managing Feedback".

Job Reporting

This option only appears if you have database jobs associated with the underlying schemas for the workspace.

Include reports on jobs and job run details within the schema associated with this application.

Not applicable.

Login Page

Creates a Login Page which enables the user to enter login credentials for accessing your application. Developers can select a template and labels for the Username and Password fields as well as determine if the Username value is stored a system-generated cookies.

Not applicable.

Theme Style Selection

Enables administrators to select a default color scheme (theme style) for the application. Administrators can also choose to allow end users to choose their own theme style. End users can simply click on the Customize button at the bottom of the home page, and select from the available theme styles. For example, users with visual impairment may prefer to utilize the Vista theme style which has a much higher color contrast.

Not applicable.

Available Components for Mobile User Interface Applications

Learn about available components when running the Create Page Wizard using the Mobile User Interface.

The Mobile User Interface based on jQuery Mobile has been desupported in Application Express 18.1. Only apps built in previous releases can have an associated Mobile User Interface.

Tip:

Universal Theme - 42 is optimized to work equally well in either a mobile or desktop environment. In previous releases and in earlier themes, the Mobile user interface is based on jQuery Mobile. Oracle recommends migrating existing mobile applications to the Universal Theme as soon as possible.

In previous releases, developers selected the Mobile User Interface to optimize applications for mobile environments. The Mobile user interface is based on jQuery Mobile. If your application users an older theme and the Mobile User Interface, the Create Page Wizard supports the following page types.

Table 7-3 Mobile User Interface Applications — Component Types

Page Type Description To Learn More

Blank Page

Creates a page with no built-in functionality.

Not applicable

Report

A report is the formatted result of a SQL query. Available report options include:

  • List View

  • Column Toggle Report

  • Reflow Report

  • Report on Web Service

See:

Form

Forms enable users to update a single row or multiple rows in a table. Available form options include:

  • Report with List View on Table

  • Form on a Table

  • Form on a Procedure

  • Form on a SQL Query

  • Form on a Web Service

  • Report and Form on a Web Service

See:

Plug-ins

Creates a new page based on a region type plug-in. Plug-ins enable developers to declaratively extend, share, and reuse the built-in types available with Oracle Application Express.

See "Importing a Plug-in from the Plug-in Page"

Chart

Enables you to create graphical charts.

See "Managing Legacy Charts"

Calendar

Generates a calendar with monthly, weekly, and daily views.

See "Creating Calendars"

Tree

Creates a tree to graphically communicate hierarchical or multiple level data and optionally navigating to a page or URL specific to each tree node.

See "Managing Trees"

Wizard

Create a collection of pages to be used as a wizard. Generally wizards are used for entering data across multiple steps.

See online Help when creating this page.

Data Loading

Creates a Data Loading wizard allowing the end user to manage the loading of data into a table to all schemas for which the user has privileges.

See "Creating Applications with Data Loading Capability"

Legacy Page

Legacy pages contains components Oracle still supports but does not recommend using. Options include:

  • Tabular Form

  • Legacy Master Detail

  • AnyChart Chart

  • Summary Page

  • Legacy Calendar

See "Managing Application Legacy Components"

About Removing Features Created with the Create Page Wizard

Remove features created with a wizard using build options.

When you add a feature using a wizard, the wizard creates one or more pages and other components and processes to seamlessly integrate it into your application. Each feature is associated with a build option which contains one or more components. You use the associated build option to enable, disable, or permanently remove features.

Using Build Options to Include or Exclude Features

Build options have two possible values: Include and Exclude. If you select the build option status of Include, then the Application Express engine considers the associated components (in this case features) as part of the application definition at runtime. Conversely, if you specify the build options status as Exclude, then the Application Express engine treats it and any associated components as if it did not exist.

Removing Features Permanently

You remove features created with a wizard by first removing the components associated with the build option and then deleting the build option.