6.2 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 you are creating.


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 was based on jQuery Mobile. Because jQuery Mobile is desupported, you must migrate existing mobile applications to the Universal Theme.

6.2.1 Component Page Types

Learn about available Component page types when running the Create Page Wizard and using the Universal Theme.

Table 6-1 Create Page Wizard Component Page Types

Page Type Description To Learn More

Blank Page

Creates a page with no built-in functionality. Once you create the application, you can create regions on the page in Page Designer.

See online Help when creating this page.


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

See: Creating Calendars


A cards page features an orderly layout of information tiles. Developers choose between three layouts: Grid, Float, or Horizontal (Row).


  • Customize every aspect of a cards region's UI (including layout, appearance, icon, badge, and media).
  • Declaratively create links from a cards page by adding actions. Action types include Button, Full Card, Title, Subtitle, or Media.
  • Supports advanced HTML expressions including template directives for client-side conditional formatting.

See: Managing Cards


Creates a new page containing a chart. Supported chart types include area, bar, box plot, bubble, combination, status meter gauge, donut, funnel, gantt, line, line with area, pie, polar, pyramid, radar, scatter, and stock charts.

See: Creating Charts


Creates a dashboard page. Choose from four different chart layouts which you can easily customize in Page Designer. Available chart layouts include Primary and 2 secondary charts, Grid of 4 charts, Primary and 3 secondary charts, and Grid of 6 charts.

See: Creating a Dashboard Page Using the Create Application Wizard

Faceted Search

A faceted search page displays and filters data using an intuitive experience users recognize from ecommerce sites (a left Search region and report region). Displays search results as cards or a classic report.


  • Select options from facets in the left Search region to narrow down search results.
  • Set filters using facets that show possible values together with the occurrence count within the result set.
  • Built-in search capability.
  • Optionally include a chart for any facet.
  • Toggle between a bar chart (which is the default) and pie chart type.
  • Create facet groups for data models having multiple flag columns.

See: Managing Faceted Search

Smart Filters

A smart filters page features single search field at the top of the page and a search results report (classic report, cards, map, or calendar). While a Smart Filter behaves similarly to faceted search, it features a more space efficient layout.


  • Includes a search field at the top of the page with filters that display as suggestion chip.
  • The Search Results can display as a classic report, cards, map, or calendar.
  • Clicking a filter name displays a list of values.
  • Clicking to right of a suggestion chip changes it to an applied filter chip and moves to the Applied Filters Area. Clicking the applied filter chip again displays a list.
  • Built-in search capability.

See: Managing Smart Filters


Forms enable users to update a single row or multiple rows in a table.

When a local table which has foreign keys is selected as the data source, then for those columns, the item type is set as Select List.

See: Creating a Form

Interactive Grid

An interactive grid presents data in a searchable, customizable report. Includes similar customization capabilities available in interactive reports plus the ability to rearrange the report interactively using the mouse or keyboard.


  • Extensive customization capabilities using menus or inline editing.
  • Turn editing on or off using the region Attribute, Edit, Enabled.
  • Built-in search capability.
  • For both editable and non-editable reports, users can change the report layout and create private reports:
    • Column Heading menu - Change the report layout with Control Break, Aggregations, Freeze, Hide, and Filter.
    • Actions menu:
      • Columns - Configure the columns to show or hide.
      • Filters - Create filters to alter the display.
      • Data - Sort, Aggregate, Refresh, Flashback.
      • Format - Control Break, Highlight, Stretch Column Widths.
      • Selection - Cell Selection, Copy to Clipboard, Refresh Rows.
      • Chart - Create chart.
      • Report - Create, edit, and manage saved Private or Alternative reports.
      • Download - Download or email the report as a CSV, HTML, PDF, or Excel file
  • If editable, users can edit the data directly:

    • Row Actions menu - Single Row View, Add Row, Duplicate Row, Delete Row, Refresh Row, Revert Changes.
    • Add Rows - Add new rows by clicking the Add Row button.
    • Edit Rows - Edit a row by selecting or double-clicking a cell with the mouse, editing the content, and clicking the Save button.

See: Managing Interactive Grids

Interactive Report

An interactive report page features a searchable, easily customizable report.


  • Report can display as a standard application page or as a modal dialog.
  • Enable the Include Form option to create a report and update form combination.
  • Built-in search capability.
  • Change the report layout and create private reports using menus:
    • Column Heading menu: Change the report layout with Sort Ascending, Sort Descending, Hide Column, Control Break, and Filter.
    • Actions menu:
      • Columns - Configure the columns to show or hide.
      • Filters - Create filters to alter the display.
      • Data - Sort, Aggregate, Compute, Flashback.
      • Format - Control Break, Highlight, Rows Per Page.
      • Chart - Create a chart.
      • Group By - Group sets of results by one or more columns with Group By.
      • Pivot - Pivot reports transpose rows into columns to generate results in a cross tab format.
      • Report - Create, edit, and manage saved Named reports.
      • Download - Download or email the report as a CSV, HTML, Excel, or PDF.
      • Subscription - Subscribe to report updates in CSV, HTML, Excel, or PDF format.

See: Managing Interactive Reports


The map component consists of a background map and spatial geometry objects (or layers) sourced from data in a local table. Supported spatial geometry objects (or layers) include: Points, Lines, Polygons, Heat Map, or Extruded Polygons. Spatial geometry objects can be either:

  • Geometry Column - Supported datatypes include SDO_GEOMETRY, VARCHAR2, or CLOB. VARCHAR2 and CLOB columns must contain geometry information in GeoJSON format.

  • Two Numeric Columns - These columns must contain longitude and latitude values. This option only applies to Point and Heat Map layers.

See: Creating Maps

Master Detail

A master detail reflects a one-to-many relationship between two tables in a database. Master detail forms enable users to insert, update, and delete values from two tables or views. Master Detail options include:

  • Stacked - Creates a single page master detail with editable interactive grids. Users select a row in the master grid to update the detail grids.

  • Side by Side - Create a single page 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: Creating Master Detail Forms

Classic Report

A classic report features a simple report page based on the formatted result of a SQL query.


  • Report can display as a standard application page or as a modal dialog.

  • Enable the Include Form option to create a report and update form combination.
  • Enable column sorting in Page Designer by selecting a column and configuring Column, Sorting attributes.
  • The most versatile report as it is template-driven. Choose from the predefined report templates, including Media List, Comments, Timeline, Badge List, Value Attributes Pairs, and so on. Or, create your own template to customize and visualize data.
  • Download the report as a CSV, HTML, Excel, or PDF.
  • Supports Report Layouts to format PDF exports.

See: Managing Classic Reports

Plug-in Page

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 APEX.

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


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

Data Loading

If a Data Load Definition exists, you can create a Data Loading page. The Create Page Wizard creates a single page with the Native Data Loading page process to provide the ability to upload data from a file or by copy and paste, and then upload the data. This Data Loading page enables end users to manage the loading of data.

See: Creating a Data Loading Page Using the Create Page 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.

Unified Task List

Create a page that allows users to view, action, or edit their approval tasks.

See: Managing Unified Task Lists

6.2.2 Feature Page Types

Learn about available Feature page types when running the Create Page Wizard and using the Universal Theme.

Table 6-2 Create Page Wizard Feature Page Types

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 Reporting Includes 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.


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.

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.

6.2.3 Legacy Page Types

Learn about Legacy page types available when running the Create Page Wizard. Oracle still supports legacy pages, but does not recommend using them.

Legacy page available when running the Create Page Wizard include:

  • Form on Local Procedure

  • Summary Page

  • Report on Legacy Web Service

  • Form on Legacy Web Service

  • Form and Report on Legacy Web Service

  • Legacy Data Loading