7.3 Understanding Page Types in the Create Page Wizard

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:

• "Developing Reports"

• "Understanding Report Types"

• "Report Options When Running the Create Page Wizard"

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:

• "Creating a Form"

• "Understanding Form Types"

• "Form Options When Running the Create Page Wizard"

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:

• "Managing Master Detail Forms"

• "About Master Detail Forms"

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"

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 reader, contributor 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.

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:

• "Developing Reports"

• "Understanding Report Types"

• "Report Options When Running the Create Page Wizard"

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:

• "Creating a Form"

• "Understanding Form Types"

• "Form Options When Running the Create Page Wizard"

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"