Go to main content
1/237
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Changes in This Release
Changes in Oracle Application Express Release 5.1
New Features
Deprecated and Desupported Features
Other Changes
1
Quick Start
1.1
About Accessing Your Development Environment
1.2
Understanding Oracle Application Express
1.2.1
What is Oracle Application Express?
1.2.2
How Oracle Application Express Works
1.2.3
About the Differences Between Runtime and Full Development Environments
1.3
Understanding the Workspace Home Page
1.3.1
Workspace Home Page
1.3.2
Top Apps and Top Users Dashboards
1.3.3
News and Messages
1.3.4
Developer Navigation Tools
1.3.4.1
Global Search Field
1.3.4.2
Administration Menu
1.3.4.2.1
Help Menu
1.3.4.3
Account Menu
1.3.5
Available Updates Region
1.3.6
Accessibility Mode Region
1.4
Understanding
App Builder
1.4.1
Accessing
App Builder
1.4.2
Using the
App Builder
Home Page
1.4.2.1
App Builder
Home Page
1.4.2.2
Reset and Create Buttons
1.4.2.3
App Builder
Home Recent List
1.4.2.4
Migrations Link
1.4.2.5
Using Workspace Utilities
1.4.3
Accessing the Application Home Page
1.4.4
Using the Application Home Page
1.4.4.1
Edit Application Properties Button
1.4.4.2
Application Home Page Icons
1.4.4.3
Create Page Button
1.4.4.4
Application Home Page Navigation Bar
1.4.4.5
About Customizing the Application Home Page
1.4.4.6
Application Home Page Tasks List
1.4.4.7
Recently Edited Pages
1.5
Editing Your Account Profile
1.5.1
Editing Your Account Profile
1.5.2
Changing Your Password
1.6
Editing User Preferences
1.7
Using Oracle Application Express Documentation
1.7.1
Accessing Oracle Help Center
1.7.2
Searching the Oracle Help Center
1.7.3
Downloading the Documentation Library
1.7.4
Viewing Field-Level Help
1.7.4.1
Viewing Field-level Help in Oracle Application Express
1.7.4.2
Viewing Help in Page Designer
2
App Builder
Concepts
2.1
Understanding Oracle Application Express Applications
2.1.1
What is an Oracle Application Express Application?
2.1.2
What Is an Application Page?
2.1.3
What is the Difference Between a Database and Websheet Application?
2.1.3.1
About Database Applications
2.1.3.2
About Websheet Applications
2.1.4
About Running the Create Application Wizard
2.2
Managing User Interface Design
2.2.1
About Determining Your Application User Interface
2.2.2
About Mobile Application Design
2.2.3
Understanding the Difference Between Mobile Design and Responsive Design
2.3
Running an Application or Page
2.3.1
Run Application and Run Page Buttons
2.3.2
How Your Browser Impacts the Way Applications Run
2.3.3
Running an Application from the App Builder Home Page
2.3.4
Running an Application from the Application Home Page
2.3.5
Running a Page on the Application Home Page
2.4
How Does Page Processing and Page Rendering Work?
2.4.1
How the Application Express Engine Renders and Processes Pages
2.4.2
About Implicit Commit Points
2.4.3
Understanding Conditional Rendering and Processing
2.4.3.1
What is a Condition?
2.4.3.2
Selecting a Condition
2.4.3.3
Condition Example: Current Page in Expression 1
2.4.3.4
Condition Example: Exists
2.4.3.5
Condition Example: PL/SQL Expression
2.4.4
About Verifying User Identity
2.4.5
About Controlling Access to Controls and Components
2.5
About Enabling Support for Bookmarks
2.6
Understanding Session State Management
2.6.1
What is Session State?
2.6.2
What Is a Session?
2.6.3
About Session IDs
2.6.4
Viewing Session State
2.6.4.1
Viewing Session State for a Page
2.6.4.2
Using the Session Page
2.7
Understanding URL Syntax
2.7.1
About the Application Page URL
2.7.2
About Using f?p Syntax to Link Pages
2.7.3
Application Alias
2.7.4
Page Alias
2.7.5
Calling a Page Using an Application and Page Alias
2.7.6
Calling a Page from a Button URL
2.8
Managing Session State Values
2.8.1
About Referencing Session State
2.8.2
Setting Session State
2.8.2.1
About Setting Session State
2.8.2.2
About Setting Session State with a Form Submission
2.8.3
Clearing Session State
2.8.3.1
About Clearing Cache for an Item
2.8.3.2
Clearing Cache for All Page Items
2.8.3.2.1
Example: Clearing Cache for Two Pages and Resetting Pagination
2.8.3.2.2
Example: Clearing Cache on a Page and Passing an Item Value
2.8.3.2.3
Example: Clearing Session Cache on a Page and Passing Values to Multiple Items
2.8.3.3
Example: Clearing Cache for an Entire Application
2.8.3.4
About Resetting an Application Completely
2.8.3.5
About Clearing Cache for the Current User Session
2.8.4
Referencing Session State Using Bind Variable Syntax
2.8.4.1
About Using Bind Variable Syntax
2.8.4.2
About Using Bind Variables in Regions Based on a SQL Query or LOV
2.8.4.3
About Using Bind Variables in Regions Based on PL/SQL
2.8.5
About Session Cloning
2.9
Understanding Substitution Strings
2.9.1
About Using Substitution Strings
2.9.2
Controlling Output Escaping in Substitution Strings
2.9.3
About Determining Substitution String Usage within Templates
2.9.4
Using Built-in Substitution Strings
2.9.4.1
APEX$ROW_NUM
2.9.4.2
APEX$ROW_SELECTOR
2.9.4.3
APEX$ROW_STATUS
2.9.4.4
APP_ID
2.9.4.5
APP_ALIAS
2.9.4.6
APP_AJAX_X01, ... APP_AJAX_X10
2.9.4.7
APP_DATE_TIME_FORMAT
2.9.4.8
APP_IMAGES
2.9.4.9
APP_NLS_DATE_FORMAT
2.9.4.10
APP_NLS_TIMESTAMP_FORMAT
2.9.4.11
APP_NLS_TIMESTAMP_TZ_FORMAT
2.9.4.12
APP_PAGE_ALIAS
2.9.4.13
APP_PAGE_ID
2.9.4.14
APP_REQUEST_DATA_HASH
2.9.4.15
APP_SESSION
2.9.4.16
APP_SESSION_VISIBLE
2.9.4.17
APP_TITLE
2.9.4.18
APP_UNIQUE_PAGE_ID
2.9.4.19
APP_USER
2.9.4.20
AUTHENTICATED_URL_PREFIX
2.9.4.21
BROWSER_LANGUAGE
2.9.4.22
CURRENT_PARENT_TAB_TEXT
2.9.4.23
DEBUG
2.9.4.24
HOME_LINK
2.9.4.25
IMAGE_PREFIX
2.9.4.26
JET_BASE_DIRECTORY
2.9.4.27
JET_CSS_DIRECTORY
2.9.4.28
JET_JS_DIRECTORY
2.9.4.29
LOGIN_URL
2.9.4.30
LOGOUT_URL
2.9.4.31
PRINTER_FRIENDLY
2.9.4.32
PROXY_SERVER
2.9.4.33
PUBLIC_URL_PREFIX
2.9.4.34
REQUEST
2.9.4.35
Using REQUEST
2.9.4.35.1
About Scope and Value of REQUEST for Posted Pages
2.9.4.35.2
About the When Button Pressed Attribute
2.9.4.35.3
About Referencing REQUEST Using Declarative Conditions
2.9.4.35.4
About Using REQUEST for Show Processing
2.9.4.35.5
About Using BRANCH_TO_PAGE_ACCEPT
2.9.4.36
SCHEMA OWNER
2.9.4.37
SQLERRM
2.9.4.38
SYSDATE_YYYYMMDD
2.9.4.39
THEME_DB_IMAGES
2.9.4.40
THEME_IMAGES
2.9.4.41
WORKSPACE_IMAGES
2.9.4.42
WORKSPACE_ID
3
Utilizing Packaged Applications
3.1
About Packaged Applications
3.2
Managing Packaged Applications in a Full Development Environment
3.2.1
Viewing Packaged Apps
3.2.2
Installing a Packaged Application
3.2.3
Running an Installed Packaged Application
3.2.4
Removing an Installed Packaged Application
3.2.5
Changing Authentication for an Installed Packaged Application
3.2.6
Unlocking an Installed Productivity Application
3.2.7
Updating a Packaged Application
3.3
Understanding Sample Database Application
3.3.1
Installing and Running Sample Database Application
3.3.2
Understanding Sample Database Application
3.3.2.1
Home Page
3.3.2.2
Customers Page
3.3.2.3
Using the Customers Page
3.3.2.3.1
Editing a Customer
3.3.2.3.2
Creating a Customer
3.3.2.3.3
Uploading Data
3.3.2.4
Products Page
3.3.2.5
Using the Products Page
3.3.2.5.1
Editing a Product
3.3.2.5.2
Adding a Product
3.3.2.6
Orders Page
3.3.2.7
Using the Orders Page
3.3.2.7.1
Editing an Order
3.3.2.7.2
Placing an Order
3.3.2.8
Reports Page
3.3.2.9
Administration Page
3.3.2.10
Accessing the Mobile Version
3.3.3
Modifying Sample Database Application
3.3.3.1
Why Modify a Sample Database Application?
3.3.3.2
Editing Sample Database Application
3.4
Understanding AnyCo IT Department Websheet
3.4.1
Installing and Running AnyCo IT Department
3.4.2
Understanding Websheet Navigation
3.4.3
Understanding AnyCo IT Department
3.4.3.1
Navigating Between Pages and Viewing Page Sections
3.4.3.2
Home Page
3.4.3.3
Projects Page
3.4.3.4
Project Review Page
3.4.3.5
Systems Page
3.4.3.6
Planned Purchase Review
3.4.3.7
Systems Budget Review
3.4.4
Modifying Websheet Content
3.4.4.1
Why Modify Sample Websheet Application?
3.4.4.2
Updating a Websheet Section
3.5
Utilizing Packaged App Administration
3.5.1
Making a Service Request
3.5.2
Setting Workspace Preferences
3.5.3
Managing Users
3.5.4
Managing Saved Interactive Reports
3.5.5
Managing Interactive Report Subscriptions
3.5.6
Viewing Activity Reports
3.5.7
Viewing Page Views
3.5.8
Viewing Top Users
3.6
Using a Packaged Apps Only Workspace
3.6.1
What Is a Packaged Apps Only Workspace?
3.6.2
Requesting a Packaged Apps Only Workspace
3.6.3
Signing In To a Packaged Apps Only Workspace
3.6.4
Using the Packaged App Page
4
Managing the Application Life Cycle with Team Development
4.1
Accessing Team Development
4.2
Team Development Home Page
4.3
About Utilizing the Tags Summary
4.4
Tracking Features
4.4.1
Viewing the Features Report
4.4.2
Creating a Feature
4.4.3
About Creating Parent Features
4.4.4
Updating a Feature
4.4.5
How to Attach Files to a Feature
4.4.5.1
Attaching a File to a Feature
4.4.5.2
Viewing, Editing, and Removing Attached Files
4.4.6
Viewing Other Feature Reports
4.4.6.1
Viewing the Features Tree
4.4.6.2
Viewing the Features Calendar
4.4.6.3
Viewing The Feature History Report
4.4.6.4
Viewing the Feature Progress Log
4.4.6.5
Viewing the Feature Focus Areas Chart
4.4.6.6
Viewing the Approval Statuses
4.4.6.7
Viewing the Feature Owners Chart
4.4.6.8
Feature Utilities
4.5
Tracking Milestones
4.5.1
Viewing the Milestones Report
4.5.2
Creating a Milestone
4.5.3
Updating a Milestone
4.5.4
Viewing Other Milestone Reports
4.5.4.1
Viewing the Milestone Calendar
4.5.4.2
Viewing the Milestones By Owner Report
4.5.4.3
Viewing the Features by Milestone Report
4.6
Tracking To Dos
4.6.1
Viewing To Dos
4.6.2
Creating a To Do
4.6.3
Updating a To Do
4.6.4
Managing Files Attached to a To Do
4.6.4.1
Attaching a File to a To Do
4.6.4.2
Viewing, Editing, and Removing Attached Files
4.6.5
Viewing Other To Do Reports
4.6.5.1
Viewing the To Do Calendar
4.6.5.2
Viewing the To Do Progress Log
4.7
Managing Bugs
4.7.1
Viewing and Editing Bugs
4.7.2
Creating a Bug
4.7.3
Editing a Bug
4.7.4
Managing Files Attached to a Bug
4.7.4.1
Attaching a File to a Bug
4.7.4.2
Viewing, Editing, and Removing Attached Files
4.7.5
Viewing Other Bug Reports
4.7.5.1
Bugs Dashboard
4.7.5.2
Viewing the Bug Calendar
4.7.5.3
Viewing the Bugs By Developer
4.7.5.4
Viewing the Bugs By Day
4.8
Managing Feedback
4.8.1
Viewing Feedback
4.8.2
Adding a Feedback Page to an Application
4.8.3
Submitting Feedback
4.8.4
Reviewing Feedback
4.8.5
Viewing Other Feedback Reports
4.8.5.1
Viewing the Feedback Calendar
4.8.5.2
Viewing Feedback By Filing User
4.9
Managing Team Development Utilities
4.9.1
Accessing Team Development Utilities
4.9.2
Configuring Team Development Settings
4.9.3
Viewing a Release Summary
4.9.4
Managing Feature Utilities
4.9.5
Editing Focus Areas
4.9.6
Viewing File Attachments
4.9.7
Purging Data
4.9.8
Managing News Entries
4.9.9
Managing Links
4.9.9.1
Adding Links to the Links Page
4.9.9.2
Editing or Deleting a Link
5
Creating Websheet Applications
5.1
About Websheet Applications
5.2
Creating a Websheet Application
5.2.1
Creating a Websheet from
App Builder
5.2.2
Creating a Websheet Application from a Running Websheet
5.3
Copying an Existing Websheet Page
5.4
Running a Websheet
5.4.1
Running a Websheet from the
App Builder
Home Page
5.4.2
Running a Websheet from the Application Home Page
5.4.3
Determining a Websheet URL
5.5
Editing Page Details
5.6
Deleting a Websheet Application
5.7
Viewing the Websheet Dashboard
5.8
Monitoring Websheet Activity
5.9
Understanding Websheet Properties
5.9.1
Editing Websheet Properties
5.9.2
Websheet Properties
5.9.2.1
Websheet
5.9.2.2
Details
5.9.2.3
Logo
5.9.2.4
Style
5.9.2.5
Authentication
5.9.2.6
Authorization
5.9.2.7
SQL
5.10
Controlling Websheet Access
5.10.1
How Websheet Access Works
5.10.2
Specifying the Access Control List Type
5.10.3
Creating Access Control List Entries
6
Creating Database Applications
6.1
Using the Create Application Wizard
6.1.1
About the Create Application Wizard
6.1.2
Available Page Types When Running the Create Application Wizard
6.2
Creating a Database Application
6.2.1
Creating a Database Application Based on a Table, Query, or Drill-Down Query
6.2.2
Creating a Desktop Database Application from a Spreadsheet
6.2.3
Copying a Database Application
6.2.3.1
Copying a Database Application Using the Create Application Wizard
6.2.3.2
Copying an Application from the Application Home Page
6.3
Creating Mobile Applications
6.3.1
About jQuery Mobile Support
6.3.2
Creating a Mobile Application
6.4
Deleting an Application
6.4.1
Deleting an Application from the Application Home Page
6.4.2
Deleting an Application from the Edit Application Definition Page
6.5
Managing Application Attributes
6.5.1
Editing Application Attributes
6.5.1.1
Accessing the Edit Application Definition Page
6.5.1.2
Edit Application Definition Page
6.5.1.2.1
Name
6.5.1.2.2
Properties
6.5.1.2.3
Availability
6.5.1.2.4
Error Handling
6.5.1.2.5
Global Notification
6.5.1.2.6
Substitutions
6.5.1.2.7
Build Options
6.5.2
Configuring Security Attributes
6.5.2.1
Accessing the Edit Security Attributes Page
6.5.2.2
Security Attributes Page
6.5.2.2.1
Authentication
6.5.2.2.2
Authorization
6.5.2.2.3
Session Management
6.5.2.2.4
Session State Protection
6.5.2.2.5
Browser Security
6.5.2.2.6
Database Session
6.5.3
Configuring Globalization Attributes
6.5.3.1
Accessing the Globalization Attributes Page
6.5.3.2
Edit Globalization Attributes Page
6.5.3.2.1
Application Primary Language
6.5.3.2.2
Application Language Derived From
6.5.3.2.3
Document Direction
6.5.3.2.4
Application Date Format
6.5.3.2.5
Application Date Time Format
6.5.3.2.6
Application Timestamp Format
6.5.3.2.7
Application Timestamp Time Zone Format
6.5.3.2.8
Character Value Comparison
6.5.3.2.9
Character Value Comparison Behavior
6.5.3.2.10
Automatic Time Zone
6.5.3.2.11
Automatic CSV Encoding
6.5.4
Managing the Application User Interface
6.5.4.1
Accessing User Interface Attributes
6.5.4.2
User Interface Page
6.5.4.2.1
General Properties
6.5.4.2.2
Logo
6.5.4.2.3
Favicon
6.5.4.2.4
User Interface Detection
6.5.4.2.5
User Interfaces
6.5.4.3
Defining an Application Logo
6.5.4.4
Creating a New User Interface
6.5.4.5
User Interface Details Page
6.5.4.5.1
Identification
6.5.4.5.2
Attributes
6.5.4.5.3
Navigation Menu
6.5.4.5.4
Navigation Bar
6.5.4.5.5
JavaScript
6.5.4.5.6
Cascading Style Sheets
6.5.4.5.7
Concatenated Files
6.6
Managing Pages in a Database Application
6.6.1
About Adding Pages to a Database Application
6.6.2
Page Types When Running the Create Page Wizard
6.6.3
Creating a Page from the Application Home Page
6.6.4
Creating Dialog Pages
6.6.4.1
About Supported Dialogs
6.6.4.2
Using a Dialog Page Template
6.6.4.2.1
Creating a Dialog Page Template
6.6.4.2.2
About Defining Dialog Page Template Attributes
6.6.4.3
Defining a Page as a Dialog in Component View
6.6.4.4
Defining a Page as a Dialog in Page Designer
6.6.4.5
Generating a Cancel Dialog Dynamic Action on the Dialog Page
6.6.4.6
Generating a Close Dialog Page Process on the Dialog Page
6.6.4.7
About Branching with Dialog Pages
6.6.4.8
Handling Refresh Actions on Parent Page
6.6.5
About Copying Database Application Pages
6.6.6
About Copying Pages Between User Interfaces
6.6.7
About Deleting Database Application Pages
6.7
Using the Find Icon
6.7.1
Using the Find Icon
6.7.2
Searching for Items
6.7.3
Searching for Pages
6.7.4
Searching for Queries
6.7.5
Searching for Tables
6.7.6
Using the PL/SQL Finder
6.7.7
Searching for Images
6.8
Creating Page Groups
6.8.1
Viewing Page Groups
6.8.2
Creating a Page Group
6.8.3
Editing a Page Group Definition
6.8.4
Assigning a Page to a Page Group
6.8.5
Viewing Pages by Page Group
6.8.6
Deleting a Page Group
6.9
Locking and Unlocking a Page
6.9.1
Determining If a Page Is Locked
6.9.2
Locking a Page
6.9.2.1
Locking a Page from the Application Home Page
6.9.2.2
Locking a Page from the Page Locks Page
6.9.2.3
Locking a Page in Page Designer
6.9.2.4
Locking a Page in Legacy Component View
6.9.3
Unlocking a Page
6.9.3.1
Unlocking Pages from Utilities
6.9.3.2
Unlocking Pages from the Application Home Page
6.9.3.3
Unlocking a Page in Page Designer
6.9.3.4
Unlocking a Page in Legacy Component View
6.9.3.5
Unlocking Pages As a Workspace Administrator
6.10
Adding Developer Comments
6.10.1
Developer Comment, Bug, or To Do Button
6.10.2
Adding Developer Comments to an Application
6.10.3
Viewing and Editing Developer Comments
6.10.4
Deleting Developer Comments
6.10.4.1
Deleting a Specific Developer Comment
6.10.4.2
Deleting Multiple Developer Comments
6.10.5
Accessing the Developer Comments from Shared Components
6.10.6
Viewing the Developer Comments Calendar
6.11
Adding Database Application Comments
6.12
Managing Application Groups
6.12.1
Viewing Database Application Groups
6.12.2
Creating a Database Application Group
6.12.3
Assigning a Database Application to an Application Group
6.12.4
Removing a Database Application from an Application Group
6.12.5
Deleting an Database Application Group
6.13
Using Application Utilities
6.13.1
Accessing the Utilities Page
6.13.2
Viewing the Application Dashboard
6.13.3
Upgrading an Application to Include New Components
6.13.3.1
About Upgrading to Include New Components
6.13.3.2
Running Upgrade Application
6.13.4
Viewing the Recently Updated Pages Report
6.13.5
Viewing the Change History Report
6.13.6
Using the Database Object Dependencies Report
6.13.7
Accessing Application Express Views
6.13.8
Accessing Page Specific Utilities
6.13.9
Accessing Cross Page Utilities
6.13.10
Accessing Cross Application Reports
6.13.11
Using Interactive Report Utilities
6.13.11.1
Deleting Saved Interactive Reports
6.13.11.2
Viewing Subscriptions
7
Managing Pages in Page Designer
7.1
About Page Designer
7.2
Understanding Page Designer UI Elements
7.2.1
Page Designer Toolbar
7.2.2
Left Pane of Page Designer
7.2.3
Central Pane of Page Designer
7.2.3.1
Layout Tab
7.2.3.2
Gallery
7.2.3.3
Component View Tab
7.2.3.4
Messages Tab
7.2.3.5
Page Search Tab
7.2.3.6
Help Tab
7.2.4
Right Pane of Page Designer (Property Editor)
7.2.5
Code Editor
7.3
Using Page Designer
7.3.1
Viewing a Page in Page Designer
7.3.2
Searching for Pages
7.3.3
Switching Between Three Pane and Two Pane Mode
7.3.4
Accessing Property Editor
7.3.5
Adding a Region, Item, or Button by Dragging and Dropping
7.3.6
About Adding Components Using Gallery Context Menus
7.3.7
Adding a Region, Item, or Button from the Rendering Tab
7.3.8
Adding a Region, Item, or Button from the Component View Tab
7.3.9
Copying a Region, Item, or Button
7.3.10
Creating Pre-Rendering Branches, Computations, and Processes
7.3.11
Creating Page Submission Branches, Validations, Computations, and Processes
7.4
Managing Page Attributes in Page Designer
7.4.1
Editing Page Attributes in the Property Editor
7.4.2
Incorporating JavaScript Using Page Designer
7.4.3
Configuring Rejoin Sessions in Page Designer
7.4.4
Configuring Dialog Attributes in Page Designer
7.4.5
Configuring Page Attributes to Warn Users of Unsaved Changes
7.5
Running a Page from Page Designer
7.6
Runtime Developer Toolbar
7.7
Copying a Database Application Page in Page Designer
7.8
Deleting Pages in Page Designer
7.8.1
Deleting a Page in Page Designer
7.8.2
Deleting Multiple Pages
7.8.3
Deleting a Range of Pages
7.9
Switching from Legacy Component View to Page Designer
8
Developing Reports
8.1
Understanding Report Types
8.1.1
Interactive Grid
8.1.2
Interactive Reports
8.1.3
Classic Report
8.1.4
Report and Form
8.2
Creating a Report
8.2.1
Creating Reports Using a Wizard
8.2.1.1
Report Options When Running the Create Application Wizard
8.2.1.2
Report Options When Running the Create Page Wizard
8.2.1.3
Creating a Report Using the Create Application Wizard
8.2.1.4
Creating a Report Using the Create Page Wizard
8.2.2
Creating a Report by Dragging and Dropping from the Gallery
8.3
Managing Interactive Grids
8.3.1
Managing Interactive Grid Region Attributes
8.3.1.1
Editing Interactive Grid Region Attributes
8.3.1.2
Creating Master Detail from an Existing Interactive Grid
8.3.1.3
Displaying Interactive Grids Conditionally
8.3.2
Managing Interactive Grid Attributes
8.3.2.1
Editing Interactive Grid Attributes
8.3.2.2
Making an Existing Interactive Grid Editable
8.3.2.3
Controlling Interactive Grid Pagination
8.3.2.4
Customizing the Interactive Grid Toolbar
8.3.2.5
Enabling Users to Save Public Reports in Interactive Grids
8.3.2.6
Restricting Who Can Save Public Reports
8.3.2.7
Enabling Icon View in an Interactive Grid
8.3.2.7.1
Adding Icon View to an Interactive Grid
8.3.2.7.2
Adding a Custom Icon View Link to an Interactive Grid
8.3.2.8
Enabling Detail View in an Interactive Grid
8.3.2.8.1
Adding a Detail View to an Interactive Grid
8.3.3
Managing Interactive Grid Column Attributes
8.3.3.1
Editing Grid Column Attributes
8.3.3.2
Defining a Column as a List of Values for Filtering
8.3.3.3
Creating a Column Link in an Interactive Grid
8.3.4
About Customizing Interactive Grids in a Running Application
8.3.5
Saving Interactive Grids
8.3.5.1
How the User Type Effects Available Save Options
8.3.5.2
About Configuration Dependencies When Saving Interactive Grids
8.3.5.3
Saving a Private Interactive Grid
8.3.5.4
Saving a Public Interactive Grid
8.3.5.5
Saving or Renaming a Primary Interactive Grid
8.3.5.6
Saving an Alternative Interactive Grid
8.3.5.7
Renaming a Saved Interactive Grid Report
8.3.5.8
Deleting a Saved Interactive Grid Report
8.3.5.9
Resetting a Saved Interactive Grid Report
8.4
Managing Interactive Reports
8.4.1
Editing Interactive Reports in Page Designer
8.4.1.1
Editing Interactive Report Region Attributes in Page Designer
8.4.1.2
Editing Interactive Report Column Attributes in Page Designer
8.4.1.3
About Filtering on Conditional Links in Interactive Report Columns
8.4.1.4
Editing Interactive Report Attributes in Page Designer
8.4.1.5
Controlling Interactive Report Pagination in Page Designer
8.4.1.6
Customizing the Interactive Report Search Bar
8.4.1.6.1
Interactive Report Search Bar
8.4.1.6.2
Customizing the Search Bar in Page Designer
8.4.1.6.3
Removing the Interactive Report Search Bar in Page Designer
8.4.1.7
Customizing the Actions Menu in Page Designer
8.4.1.8
Configuring Actions Menu Download Options in Page Designer
8.4.1.8.1
Enabling Download Formats
8.4.1.8.2
Enabling CSV Download
8.4.1.8.3
Enabling Email Download
8.4.1.9
Managing Link Columns in Page Designer
8.4.1.9.1
Linking to a Single Row View
8.4.1.9.2
Linking to a Specific Page
8.4.1.9.3
Linking to a URL
8.4.1.9.4
Excluding a Link Column
8.4.1.10
Creating a Column Link in an Interactive Report
8.4.1.11
Displaying Interactive Reports Conditionally
8.4.1.12
Defining a Column as a List of Values in an Interactive Report
8.4.1.13
Formatting Columns in an Interactive Report
8.4.1.14
Enabling Icon View in Page Designer
8.4.1.14.1
Adding a View Icon Button
8.4.1.14.2
Adding a Custom Icon View Link
8.4.1.15
Enabling Detail View in Page Designer
8.4.1.16
Configuring Advanced Attributes for Interactive Reports
8.4.1.16.1
Configuring Advanced Attributes in Page Designer
8.4.1.16.2
About Emailing from an Interactive Report
8.4.2
Editing Interactive Reports in Legacy Component View
8.4.2.1
Editing Interactive Report Attributes in Component View
8.4.2.1.1
Accessing the Interactive Report Attributes Page in Component View
8.4.2.1.2
Report Attribute Page Navigation Alternatives
8.4.2.2
Editing Column Attributes in Component View
8.4.2.3
Creating Column Groups
8.4.2.4
Controlling Interactive Report Pagination in Component View
8.4.2.5
Managing the Search Bar and Actions Menu in Component View
8.4.2.5.1
Interactive Report Search Bar and Actions Menu
8.4.2.5.2
Customizing the Search Bar and Actions Menu
8.4.2.5.3
Removing the Search Bar
8.4.2.5.4
Configuring Download Options on the Actions Menu
8.4.2.6
Managing Link Columns in Component View
8.4.2.6.1
Linking to a Single Row View
8.4.2.6.2
Linking to a Specific Page
8.4.2.6.3
Linking to a URL
8.4.2.6.4
Excluding a Link Column
8.4.2.7
Creating a Column Link in an Interactive Report
8.4.2.7.1
Creating a Column Link to Another Page
8.4.2.7.2
Create a Column Link to a URL
8.4.2.8
Displaying Interactive Reports Conditionally
8.4.2.9
Defining a Column as a List of Values in an Interactive Report
8.4.2.10
Formatting Columns in an Interactive Report
8.4.2.11
Enabling Icon View in Component View
8.4.2.11.1
Adding Icon View to an Interactive Report
8.4.2.11.2
Adding a Custom Icon View Link
8.4.2.12
Enabling Detail View in Component View
8.4.2.13
Configuring Interactive Report Advanced Attributes
8.4.2.13.1
Configuring Advanced Attributes
8.4.2.13.2
About Emailing from an Interactive Report
8.4.2.14
Editing Saved Default Interactive Reports in Component View
8.4.2.14.1
Editing the Alias of Default Report in Component View
8.4.2.14.2
Deleting Saved Default Reports in Component View
8.4.2.15
Viewing Saved Interactive Report Activity
8.4.3
Linking to Interactive Reports
8.4.3.1
Request Syntax
8.4.3.2
Name and Value Syntax
8.4.3.3
ClearCache Syntax
8.4.3.4
Restrictions When Linking to Interactive Reports
8.4.3.5
Valid Linking Examples
8.4.3.6
Invalid Linking Examples
8.4.3.7
Linking to Shared Interactive Reports
8.4.3.7.1
Editing the Alias of Default Report in Page Designer
8.4.3.7.2
Link Examples to a Primary Report
8.4.3.7.3
Link Examples to Saved Reports
8.4.4
Customizing Interactive Reports in a Running Application
8.4.4.1
About the Search Bar
8.4.4.2
About the Actions Menu
8.4.4.3
Using Interactive Report Filters
8.4.4.4
Saving Interactive Reports
8.4.4.4.1
About the User Type and Available Save Options
8.4.4.4.2
About Configuration Dependencies
8.4.4.4.3
Saving a Public or Private Interactive Report
8.4.4.4.4
Saving a Default Interactive Report
8.4.4.4.5
Renaming a Public or Private Interactive Report
8.4.4.4.6
Deleting a Public or Private Interactive Report
8.4.4.4.7
About Exporting Interactive Reports
8.5
Managing Classic Reports
8.5.1
Editing Classic Reports in Page Designer
8.5.1.1
Altering Classic Report Layout in Page Designer
8.5.1.2
Editing Classic Report Attributes in Page Designer
8.5.1.3
Editing Classic Report Pagination in Page Designer
8.5.1.4
Enabling Classic Report CSV Output Option in Page Designer
8.5.1.5
Adding Support for XML File or a CSV File Export in Page Designer
8.5.1.6
Enabling Column Sorting in a Classic Report in Page Designer
8.5.1.7
Creating a Column Link in a Classic Report in Page Designer
8.5.1.8
Adding a Download Link to a Classic Report in Page Designer
8.5.1.9
Defining an Updatable Column in a Classic Report in Page Designer
8.5.1.10
Controlling When Classic Report Columns Display in Page Designer
8.5.1.11
Defining a Column as a List of Values in a Classic Report in Page Designer
8.5.1.12
Controlling Classic Report Column Breaks in Page Designer
8.5.2
Editing Classic Reports in Legacy Component View
8.5.2.1
Editing Classic Report Attributes in Component View
8.5.2.2
Altering Classic Report Layout in Component View
8.5.2.3
Controlling Classic Report Pagination in Component View
8.5.2.3.1
Pagination in a Classic Report
8.5.2.3.2
Controlling Classic Report Pagination
8.5.2.3.3
Including Pagination After the Rows in a Classic Report
8.5.2.3.4
Including Pagination Before the Rows in a Classic Report
8.5.2.4
Enabling Column Sorting in a Classic Report in Component View
8.5.2.5
Adding a Download Link to a Classic Report in Component View
8.5.2.6
Enabling Classic Report CSV Output in Component View
8.5.2.7
Adding Support for XML File or a CSV File Export
8.5.2.8
Creating a Column Link in a Classic Report in Component View
8.5.2.8.1
Creating a Column Link to Another Page
8.5.2.8.2
Creating a Column Link to a URL
8.5.2.9
Defining an Updatable Column in Component View
8.5.2.10
Defining a Column as a List of Values in a Classic Report in Component View
8.5.2.11
Controlling When Classic Report Columns Display in Component View
8.5.2.12
Controlling Classic Report Column Breaks in Component View
8.5.2.13
Synchronizing Classic Report Column Order with Region Source
8.6
Printing Report Regions
8.6.1
About Printing Reports to PDF
8.6.2
About Report Printing Configuration Options
8.6.3
About Classic Report Printing Methods
8.6.4
Configuring Classic Report Region Print Attributes
8.6.4.1
Configuring a Classic Report Print Attributes in Page Designer
8.6.4.2
Configuring a Classic Report Print Attributes in Component View
8.6.5
Configuring Interactive Report Region Print Attributes
8.6.5.1
Configuring Interactive Report Regions for Printing in Page Designer
8.6.5.2
Configuring Interactive Report Regions for Printing in Legacy Component View
8.6.6
About Report Queries
8.6.7
About Report Layouts
8.7
Understanding BLOB Support in Forms and Reports
8.7.1
About BLOB Support in Reports
8.7.2
About Providing a Download Link
8.7.3
About Displaying the BLOB
8.7.4
About Working With BLOBs Procedurally
9
Developing Forms
9.1
Understanding Form Types
9.1.1
Editable Interactive Grid
9.1.2
Form on Table
9.1.3
Master Detail Forms
9.2
Creating a Form
9.2.1
Form Options When Running the Create Page Wizard
9.2.2
Creating a Form Using the Create Page Wizard
9.2.3
Creating a Form Using the Create Application Wizard
9.2.4
Creating a Form Manually in Legacy Component View
9.2.4.1
About Creating Forms Manually in Component View
9.2.4.2
Processing a Form
9.2.4.2.1
Creating an Automatic Row (DML) Processing Process
9.2.4.2.2
Creating a Process that Contains One or More Insert Statements
9.2.4.2.3
Using a PL/SQL API to Process Form Values
9.2.4.3
Populating Forms in Component View
9.2.5
Creating a Form Region in Page Designer
9.3
About Making an Interactive Grid Editable
9.4
Managing Master Detail Forms
9.4.1
About Master Detail Forms
9.4.2
Creating a Single Page Master Detail Using the Create Application Wizard
9.4.3
Creating a Single Page Master Detail Using the Create Page Wizard
9.4.4
Creating a Two Page Master Detail Using the Create Page Wizard
9.5
Validating User Input in Forms
9.5.1
About Creating Validations and Error Messages
9.5.2
Associating a Validation with a Specific Item in Page Designer
9.5.3
Associating a Validation with a Specific Item in Component View
9.5.4
About the Error Message Display Location
9.6
Understanding BLOB Support in Forms
9.6.1
About BLOB Support in Forms
9.6.2
About Uploading and Downloading Files into a BLOB
9.6.3
About Displaying the BLOB
9.6.4
About Removing the Image Reference
10
Managing Database Application Components
10.1
Creating Calendars
10.1.1
About Supported Calendars
10.1.2
Sample Calendar
10.1.3
Adding a Calendar to a New Page
10.1.4
Creating a Calendar in Page Designer
10.1.5
Managing Calendar Attributes in Page Designer
10.1.5.1
Editing Calendar Attributes in the Property Editor
10.1.5.2
Editing an Existing Calendar to Include Add and Edit Functionality
10.1.5.3
Adding Calendar Initialization JavaScript Code
10.1.5.4
Enabling the Dragging and Dropping of Data In an Existing Calendar
10.1.6
About Dynamic Action Support for Calendar
10.2
Creating Maps
10.2.1
About Map Chart Support
10.2.2
About Creating SQL Queries for Maps
10.2.3
Adding Map Charts to a New Page
10.2.4
Managing Map Charts in Page Designer
10.2.4.1
Adding a Map Chart in Page Designer
10.2.4.2
Editing Map Chart Attributes in Page Designer
10.2.4.3
Using Custom XML with Map Charts
10.2.4.4
Enabling Automatic Updates
10.2.5
Managing Map Charts in Legacy Component View
10.2.5.1
Adding a Map Chart in Component View
10.2.5.2
Editing Map Chart Attributes
10.2.5.3
Using Custom XML with Map Charts
10.2.5.4
Enabling Asynchronous Updates
10.3
Creating Charts
10.3.1
About Supported Charts
10.3.2
Sample Charts
10.3.3
Adding a Chart to a New Page
10.3.4
Managing Charts
10.3.4.1
Adding a Chart in Page Designer
10.3.4.2
Editing Chart Attributes in Page Designer
10.3.4.3
Switching Chart Type in Page Designer
10.3.4.4
Enabling Automatic Refresh
10.3.4.4.1
Enabling the Automatic Refresh Attribute
10.3.4.4.2
Creating a Refresh Dynamic Action in Page Designer
10.3.5
Using Custom JavaScript with Charts
10.4
Creating Help for Your Application
10.4.1
Creating Help in Page Designer
10.4.1.1
About Creating Help
10.4.1.2
Creating a Help Page and Region in Page Designer
10.4.1.3
Defining Page Help in Page Designer
10.4.1.4
Defining Item Help in Page Designer
10.4.2
Creating Help in Legacy Component View
10.4.2.1
About Creating Help
10.4.2.2
Creating a Help Page and Region in Component View
10.4.2.3
Defining Page Help in Component View
10.4.2.4
Defining Item Help in Component View
10.4.3
Editing Multiple Item Help Topics Simultaneously
10.4.3.1
Using the Bulk Edit Item Help Report
10.4.3.2
Seeding Item Help Topics
10.4.4
Creating a Help Navigation Bar Entry
11
Using Themes and Theme Styles
11.1
Using Themes
11.1.1
About Themes
11.1.2
About Responsive Design
11.1.3
About Grid-based Themes
11.1.4
Using Theme Styles
11.1.4.1
About Theme Styles
11.1.4.2
Creating a Theme Style
11.1.4.3
Editing a Theme Style from the Themes Page
11.1.4.4
Editing a Theme Style from the User Interface Page
11.1.4.5
Enabling Users to Select a Theme Style
11.1.4.6
Using Theme Roller
11.1.5
Understanding Template Options
11.1.5.1
About Template Options
11.1.5.2
About Default Template Options
11.1.5.3
About Template Option Groups and Presets
11.1.6
Accessing the Themes Page
11.1.7
Editing Themes
11.1.7.1
Editing a Theme
11.1.7.2
Theme Attributes
11.1.7.2.1
Name
11.1.7.2.2
Theme Subscription
11.1.7.2.3
JavaScript and Cascading Style Sheets
11.1.7.2.4
Component Defaults
11.1.7.2.5
Region Defaults
11.1.7.2.6
Dialog Defaults
11.1.7.2.7
Transition Defaults
11.1.7.2.8
Global Templates Options
11.1.7.2.9
Icons
11.1.7.2.10
Image
11.1.7.2.11
Styles
11.1.7.2.12
Files
11.2
Managing Themes and Subscriptions
11.2.1
Understanding Theme Subscriptions
11.2.1.1
About Theme Subscriptions
11.2.1.2
About Modifying a Theme Subscription
11.2.1.3
Verifying if a Theme Refresh Is Needed
11.2.1.4
Refreshing a Subscribed Theme
11.2.1.5
Unsubscribing to a Theme
11.2.1.6
Re-subscribing to a Built-in Theme
11.2.2
Creating a Theme
11.2.3
Switching Themes
11.2.3.1
About Switching the Active Theme
11.2.3.2
About Switching to the Universal Theme
11.2.3.3
Switching an Active Theme
11.2.4
Changing a Theme Identification Number
11.2.5
Copying a Theme
11.2.6
Deleting a Theme
11.2.7
Creating a Master Theme Application
11.2.7.1
Creating a Master Theme Application by Creating a New Application
11.2.7.2
Creating a Master Theme Application from an Existing Application
11.2.8
Managing Workspace Themes
11.2.8.1
Adding a Workspace Theme to the Theme Repository
11.2.8.2
Viewing an Existing Workspace Theme
11.2.8.3
Deleting a Workspace Theme
11.2.8.4
Modifying a Workspace Theme
11.2.8.5
Exporting a Workspace Theme
11.2.9
Managing Instance Themes
11.2.10
About Exporting and Importing Themes
11.2.11
Viewing Theme Reports
11.2.11.1
Viewing All Templates in a Theme
11.2.11.2
Viewing Theme Template Counts
11.2.11.3
Viewing File References
11.2.11.4
Viewing Class References
11.2.11.5
Viewing Template Substitution Strings
11.3
Creating Custom Themes
11.3.1
About Cascading Style Sheets
11.3.2
About Calling the JavaScript File from the Page Template
11.3.3
About Using Escaping Syntax in Substitution Strings
11.3.4
Selecting a Default Page Template
11.3.4.1
Selecting a Page-level Template Within a Theme
11.3.4.2
Selecting a Page-level Template for a Specific Page
11.3.5
Creating a New Template
11.3.6
Using Template Options
11.3.6.1
Managing Global Template Option Groups
11.3.6.1.1
Creating a Global Template Option Group
11.3.6.1.2
Editing Global Template Option Groups
11.3.6.2
Managing Global Template Options
11.3.6.2.1
Creating Global Template Options
11.3.6.2.2
Editing Global Template Options
11.3.6.3
Managing Template Options
11.3.6.3.1
Creating Template Options
11.3.6.3.2
Editing Template Options
11.3.6.3.3
Using Quick Edit to Modify Live Template Options
11.3.7
Viewing Template Reports
11.3.8
Managing Templates
11.3.8.1
Viewing Templates on the Templates Page
11.3.8.2
Viewing Templates Associated with a Specific Page
11.3.8.3
Replacing Templates
11.3.8.4
Replacing All Templates within an Application
11.3.8.5
Viewing Region Position Utilization by Page Template
11.3.8.6
Unsubscribing to Templates
11.3.8.7
Publishing Templates
11.3.9
Breadcrumb Templates
11.3.9.1
About Breadcrumb Style Navigation
11.3.9.2
Breadcrumb Template Attributes
11.3.9.2.1
Name
11.3.9.2.2
Definition
11.3.9.2.3
Substitution Strings
11.3.10
Button Templates
11.3.10.1
Button Template Attributes
11.3.10.1.1
Name
11.3.10.1.2
Definition
11.3.10.1.3
Substitution Strings
11.3.11
Legacy Calendar Templates
11.3.11.1
Supported Legacy Calendar Template Substitution Strings
11.3.11.2
Legacy Calendar Template Attributes
11.3.11.2.1
Name
11.3.11.2.2
Subscription
11.3.11.2.3
Comments
11.3.12
Label Templates
11.3.12.1
Label Template Attributes
11.3.12.1.1
Name
11.3.12.1.2
Definition
11.3.12.1.3
Error Display
11.3.12.1.4
Field Container
11.3.12.1.5
Substitution Strings
11.3.12.2
About Using #CURRENT_ITEM_HELP_TEXT# to Create Item Help
11.3.13
List Templates
11.3.13.1
About Hierarchical Lists
11.3.13.2
List Template Attributes
11.3.13.2.1
Name
11.3.13.2.2
Before List Entry
11.3.13.2.3
Template Definition
11.3.13.2.4
Template Definitions for First Entry
11.3.13.2.5
Before Sublist Entry
11.3.13.2.6
Sublist Entry
11.3.13.2.7
After Sub List Entry
11.3.13.2.8
After List Entry
11.3.13.2.9
Substitution Strings
11.3.14
Page Templates
11.3.14.1
Page Template Attributes
11.3.14.1.1
Name
11.3.14.1.2
Definition
11.3.14.1.3
JavaScript
11.3.14.1.4
Cascading Style Sheet
11.3.14.1.5
Subtemplate
11.3.14.1.6
Image Based Tab Attributes
11.3.14.1.7
Layout
11.3.14.1.8
Display Points
11.3.14.1.9
Dialog
11.3.14.1.10
Error Page Template Control
11.3.14.1.11
Substitution Strings
11.3.14.2
Required Dialog Page Template Attributes
11.3.15
Popup LOV Templates
11.3.15.1
Popup List of Values Template Attributes
11.3.15.1.1
Search Field
11.3.15.1.2
Buttons
11.3.15.1.3
Window
11.3.15.1.4
Pagination
11.3.15.1.5
Result Set
11.3.15.1.6
Page Attributes
11.3.16
Region Templates
11.3.16.1
Region Template Attributes
11.3.16.1.1
Name
11.3.16.1.2
Definition
11.3.16.1.3
Layout
11.3.16.1.4
Sub Regions
11.3.16.1.5
Substitution Strings
11.3.17
Report Templates
11.3.17.1
Generic Column Templates and Named Column Templates
11.3.17.1.1
Generic Column Templates
11.3.17.1.2
Named Column Templates
11.3.17.2
Report Column Template Attributes for Generic Column Templates
11.3.17.2.1
Report Template
11.3.17.2.2
Before Rows
11.3.17.2.3
Column Headings
11.3.17.2.4
Before Each Row
11.3.17.2.5
Column Templates
11.3.17.2.6
After Each Row
11.3.17.2.7
After Rows
11.3.17.2.8
Row Highlighting
11.3.17.2.9
Pagination Subtemplate
11.3.17.2.10
Comments
11.3.17.3
Report Column Template Attributes for Named Column Templates
11.3.17.3.1
Name
11.3.17.3.2
Subscription
11.3.17.3.3
Row Templates
11.3.17.3.4
Column Headings
11.3.17.3.5
Before first and after last row text
11.3.17.3.6
Pagination
11.3.17.3.7
Comments
11.3.17.4
About Using JavaScript in Column Templates
11.4
Using Custom Cascading Style Sheets
11.4.1
About Uploading Cascading Style Sheets
11.4.2
Referencing an Uploaded Cascading Style Sheet in the Page Template
12
Controlling Page Layout
12.1
About Page Layout in Oracle Application Express
12.2
Optimizing a Page for Printing
12.2.1
Selecting a Printer Friendly Template for an Application
12.2.2
Using f?p Syntax to Toggle to Printer Friendly Mode
12.3
Creating a Global Page to Display Components on Every Page
12.3.1
Creating a Global Page
12.3.2
Navigating to the Global Page
12.4
About Regions
12.5
Managing Regions in Page Designer
12.5.1
Creating a Region in Page Designer
12.5.2
Managing Regions in Page Designer
12.5.2.1
Editing Region Attributes in Page Designer
12.5.2.2
Controlling Region Positioning
12.5.2.3
Specifying a Region Header and Footer
12.5.2.4
Enabling Users to Customize a Page
12.5.2.5
Utilizing Region Caching in Page Designer
12.5.2.5.1
About Region Caching
12.5.2.5.2
Enabling Region Caching in Page Designer
12.5.2.6
Specifying a Static Region ID
12.5.2.7
Adding a Region Image
12.5.2.8
Creating a Region Display Selector
12.5.3
Copying a Region in Page Designer
12.5.4
Deleting Regions in Page Designer
12.6
Managing Regions in Legacy Component View
12.6.1
Region Types When Running the Create Region Wizard
12.6.2
Creating a Region in Component View
12.6.3
Managing Regions in Component View
12.6.3.1
Editing Region Attributes in Component View
12.6.3.2
How Region Attributes Affect Page Layout
12.6.3.2.1
Component View Region Attributes Affecting Page Layout
12.6.3.2.2
Controlling Region Positioning in Component View
12.6.3.3
Specifying a Region Header and Footer
12.6.3.4
Enabling Users to Customize a Page
12.6.3.5
Utilizing Region Caching in Component View
12.6.3.5.1
About Region Caching
12.6.3.5.2
Enabling Region Caching
12.6.3.5.3
Managing Cached Regions
12.6.3.6
Specifying a Static Region ID
12.6.3.7
Adding a Region Image
12.6.3.8
Editing Multiple Regions at Once in Component View
12.6.3.8.1
Editing Multiple Attributes Across All Regions
12.6.3.8.2
Accessing Region Utilities
12.6.3.9
Managing Subregions in Component View
12.6.3.9.1
About Using Subregions
12.6.3.9.2
Creating a Subregion in Component View
12.6.3.9.3
Creating a Subregion by Editing Region Attributes
12.6.4
Creating a Region Display Selector
12.6.5
Copying a Region in Component View
12.6.6
Deleting Regions in Component View
12.6.6.1
Deleting a Region
12.6.6.2
Deleting Multiple Regions at Once
12.7
About Incorporating Content from Other Web Sites
12.8
About Managing Images
12.9
Rendering HTML Using Custom PL/SQL
13
Managing Database Application Controls
13.1
Understanding Page-Level Items
13.1.1
About the Differences Between Page Items and Application Items
13.1.2
About Item Naming Conventions
13.1.3
Referencing Item Values
13.1.4
About Referencing Items Using JavaScript
13.1.5
Working with Multiple Select List Item
13.1.5.1
About Handling Values Returned from a Multiple Select List Item
13.1.5.2
Using APEX_UTIL.STRING_TO_TABLE to Convert Selected Values
13.1.5.3
Creating a Shuttle Item
13.1.5.3.1
Creating a Report and From on a Table
13.1.5.3.2
Creating a Shuttle Item on the Form Page in Page Designer
13.1.5.3.3
Creating a Shuttle Item on the Form Page in Component View
13.2
Managing Page-Level Items in Page Designer
13.2.1
Viewing Page-Level Items in Page Designer
13.2.2
Creating Page-Level Items
13.2.2.1
Creating a Page-Level Item from the Rendering Tab
13.2.2.2
Adding a Page-Level Item from the Gallery
13.2.2.3
Creating a Static List of Values
13.2.2.3.1
Example 1: Four Values Displayed in Alphabetical Order
13.2.2.3.2
Example 2: Ten Values Displayed in the Order Listed
13.2.2.3.3
Example 3: A List of Values with Having Both a Return and Display Value
13.2.2.4
Creating a Cascading List of Values
13.2.3
Editing Page-Level Items in Page Designer
13.2.3.1
Editing Page Item Attributes in the Property Editor
13.2.3.2
Defining Default Values for Page Items
13.2.3.3
Configuring Page Item Security
13.2.3.4
Creating a Quick Pick Selection
13.2.3.5
Displaying Conditional Page Items
13.2.3.6
Displaying Read Only Page Items
13.2.3.7
Configuring Item Attributes to Warn Users of Unsaved Changes
13.2.3.8
Viewing Item Utilities
13.3
Managing Page-Level Items in Legacy Component View
13.3.1
Viewing Page-Level Items in the Component View
13.3.2
Creating Page-Level Items in Component View
13.3.2.1
Creating a Page-Level Item in Component View
13.3.2.2
Creating a Static List of Values
13.3.2.2.1
Example 1: Four Values Displayed in Alphabetical Order
13.3.2.2.2
Example 2: Ten Values Displayed in the Order Listed
13.3.2.2.3
Example 3: A List of Values with Having Both a Return and Display Value
13.3.2.3
Creating a Cascading List of Values
13.3.2.4
Creating Multiple Items Using a Tabular Form
13.3.3
Editing Page-Level Items in Component View
13.3.3.1
Editing Page Item Attributes in Component View
13.3.3.2
Defining Default Values
13.3.3.3
Configuring Page Item Security
13.3.3.4
Creating a Quick Pick Selection
13.3.3.5
Displaying Conditional Page Items
13.3.3.6
Displaying Read Only Page Items
13.3.3.7
Editing Multiple Items Simultaneously
13.3.3.7.1
Editing Multiple Items
13.3.3.7.2
Reassigning Region Items
13.3.3.7.3
Deleting Multiple Items
13.3.3.7.4
Viewing Item Utilities
13.3.3.7.5
Viewing Page Item History
13.4
Managing Dynamic Actions
13.4.1
About Dynamic Actions
13.4.2
Viewing Dynamic Action Examples
13.4.3
About Dynamic Action Events
13.4.4
Managing Dynamic Actions in Page Designer
13.4.4.1
Creating a Dynamic Action in Page Designer
13.4.4.2
Editing Dynamic Actions in Page Designer
13.4.4.3
Defining Dynamic Action Event Scope
13.4.4.4
Deleting a Dynamic Action in Page Designer
13.4.5
Managing Dynamic Actions in Legacy Component View
13.4.5.1
Creating a Dynamic Action in Component View
13.4.5.2
Editing Dynamic Actions in Component View
13.4.5.3
Adding Additional True Actions
13.4.5.3.1
About Adding Additional True Actions
13.4.5.3.2
Adding a True Action
13.4.5.4
Defining the Frequency and Scope
13.4.6
About Calling JavaScript Using a Dynamic Action
13.4.7
Debugging Dynamic Actions
13.4.7.1
About Debugging Dynamic Actions
13.4.7.2
Debugging Dynamic Actions
13.5
Creating Buttons
13.5.1
What Actions Can a Button Perform?
13.5.2
Managing Buttons in Page Designer
13.5.2.1
Creating a Button in Page Designer
13.5.2.2
Editing a Button in Page Designer
13.5.2.3
Displaying a Button Conditionally
13.5.2.4
Configuring Button Attributes to Warn Users of Unsaved Changes
13.5.3
Managing Buttons in Legacy Component View
13.5.3.1
Creating a Button in Component View
13.5.3.2
Creating Multiple Buttons in Component View
13.5.3.3
Editing a Button in Legacy Component View
13.5.3.3.1
Editing Button Attributes
13.5.3.3.2
About Execute Validations
13.5.3.3.3
Editing Multiple Buttons at Once
13.5.3.4
Displaying a Button Conditionally
13.5.4
About Calling JavaScript from a Button
13.5.5
About the Relationship Between Button Names and REQUEST
13.5.6
About Branching with Buttons
13.6
Creating Trees
13.6.1
About Trees
13.6.2
About Support for Legacy jsTrees
13.6.3
Managing Trees in Page Designer
13.6.3.1
Creating a Tree on New Page
13.6.3.2
Creating a Tree in Page Designer
13.6.3.3
Editing Tree Attributes in Page Designer
13.6.4
Managing Trees in Legacy Component View
13.6.4.1
Creating a Tree in Component View
13.6.4.2
Editing Tree Attributes in Component View
13.7
About Incorporating JavaScript into an Application
14
Adding Navigation
14.1
About Creating Lists as Navigation
14.2
Creating Tabs
14.2.1
About Tabs
14.2.2
About the Tabs Page
14.2.3
Checking for Tab Template Support
14.2.4
Creating a Tab
14.2.5
Editing Tabs
14.2.5.1
Editing Multiple Tabs Simultaneously
14.2.5.2
Managing Standard Tabs
14.2.6
Accessing Tab Reports
14.3
Creating Breadcrumbs
14.3.1
What Are Breadcrumbs?
14.3.2
Creating a Breadcrumb While Creating a Page
14.3.3
Creating a Breadcrumb Manually
14.3.3.1
About Creating a Breadcrumb Manually
14.3.3.2
Creating Breadcrumbs
14.3.3.2.1
Creating Breadcrumbs as Shared Components
14.3.3.2.2
Creating a Breadcrumb Region in Page Designer
14.3.3.2.3
Creating Breadcrumbs from Component View
14.3.3.3
Adding Breadcrumb Entries
14.3.3.4
Adding Breadcrumb Regions
14.3.3.4.1
Adding a Breadcrumb Region in Page Designer
14.3.3.4.2
Adding a Breadcrumb Region in Legacy Component View
14.3.3.5
About Creating Dynamic Breadcrumbs
14.3.4
Editing Breadcrumbs
14.3.5
Reparenting Breadcrumb Entries
14.3.6
Deleting Unused Breadcrumb Entries
14.3.7
Accessing Breadcrumb Reports
14.4
Creating a Navigation Bar Entry
14.4.1
About Navigation Bars
14.4.2
Creating a Navigation Bar Entry
14.4.2.1
Creating a Navigation Bar Entry from Scratch
14.4.2.2
Creating a Navigation Bar Entry for Feedback
14.4.3
Copying a Navigation Bar Entry
14.4.4
Editing a Navigation Bar Entry
14.4.5
Editing Multiple Navigation Bar Entries Simultaneously
14.4.6
Accessing Navigation Bar Entry Reports
14.5
Controlling Navigation Using Branches
14.5.1
Creating a Branch in Page Designer
14.5.2
Creating a Branch in Component View
14.5.3
About Branching Conditionally
15
Managing Computations, Validations, and Processes
15.1
Understanding Page Computations
15.1.1
About Page Computations
15.1.2
Managing Page Computations in Page Designer
15.1.2.1
Creating a Page Computation in Page Designer
15.1.2.2
Editing Page Computation Attributes in Page Designer
15.1.2.3
About Editing the Computation Point and Source
15.1.2.4
About Creating Conditional Computations
15.1.3
Managing Page Computations in Legacy Component View
15.1.3.1
Creating a Page Computation in Component View
15.1.3.2
Editing Page Computation Attributes in Component View
15.1.3.3
About Editing the Computation Point and Source
15.1.3.4
About Creating Conditional Computations
15.1.4
Computation Points and Computation Syntax Example
15.2
Understanding Validations
15.2.1
About Validations
15.2.2
Managing Validations in Page Designer
15.2.2.1
Creating a Validation in Page Designer
15.2.2.2
Editing a Validation in Page Designer
15.2.3
Managing Validations in Legacy Component View
15.2.3.1
Creating a Validation for a Page Item
15.2.3.2
Creating a Validation for an Entire Page
15.2.3.3
Creating a Validation for a Tabular Form Column
15.2.3.4
Creating a Validation for a Tabular Form Row
15.2.3.5
Editing a Validation in Component View
15.2.4
About Determining When Validations Execute
15.2.5
About Defining How Validation Error Messages Display
15.2.6
Processing Validations Conditionally
15.2.7
About Altering the Go to Error Link
15.2.8
What Happens When a Validation Fails?
15.3
Understanding Page Processes
15.3.1
About Page Processes
15.3.2
Managing Page Processes in Page Designer
15.3.2.1
Creating Page Processes in Page Designer
15.3.2.2
Editing Page Process Attributes in Page Designer
15.3.2.3
Controlling When a Page Process Executes in Page Designer
15.3.2.4
Creating Page Process Success and Error Messages in Page Designer
15.3.2.5
Making a Page Process Conditional in Page Designer
15.3.3
Managing Page Processes in Legacy Component View
15.3.3.1
Creating Page Processes in Component View
15.3.3.1.1
Creating a Page Process
15.3.3.1.2
Creating a Tabular Form Page Process
15.3.3.2
Editing Page Process Attributes in Component View
15.3.3.3
Controlling When a Page Process Executes
15.3.3.4
Creating Page Process Success and Error Messages
15.3.3.5
Making a Page Process Conditional
15.4
About Branches
15.5
Understanding Application Processes
15.5.1
On Demand Application Processes
15.5.2
About Application Processes that Execute On New Instance
15.5.3
About Running an On Demand Process from a Page Request
15.5.4
Application Process Example
15.5.5
Creating an Application Process
15.5.6
Editing Application Process Attributes
15.5.7
Creating Application Process Error Messages
15.5.8
Viewing the Application Processes History Report
15.6
Understanding Application Computations
15.6.1
About Application Computations
15.6.2
About Application Computations that Execute On New Instance
15.6.3
Creating an Application Computation
15.6.4
Accessing the Application Computation History Report
15.7
Using the Attribute Dictionary
15.7.1
About the Attribute Dictionary
15.7.2
Accessing the Manage Attribute Dictionary
16
Managing Shared Components
16.1
Working with Shared Components
16.1.1
About the Advantages of Using Shared Components
16.1.2
Accessing the Shared Components Page
16.1.3
About the Shared Components Icon
16.1.4
Shared Components Page
16.1.4.1
Application Logic
16.1.4.2
Security
16.1.4.3
Other Components
16.1.4.4
Navigation
16.1.4.5
User Interface
16.1.4.6
Files
16.1.4.7
Data References
16.1.4.8
Reports
16.1.4.9
Globalization
16.1.4.10
Tasks Region
16.2
Managing Component Settings
16.2.1
Configuring Component Settings
16.2.2
Integrating with Google Calendar
16.2.3
Configuring Color Picker Display
16.2.4
Configuring Interactive Report Action Menu Structure
16.2.5
Dynamically Adding Sliders to Regions
16.2.6
Configuring Switch Defaults
16.2.7
Viewing the Component Settings History Report
16.3
Managing Static Application Files
16.3.1
Specifying the Location of Static Application Files
16.3.2
Uploading Static Application Files
16.3.3
Viewing the Static Application File Report
16.3.4
Referencing Static Application Files
16.3.5
Downloading Static Application Files
16.3.5.1
Downloading a Static Application File
16.3.5.2
Downloading All Static Application Files in a Zip
16.3.6
Deleting Static Application Files
16.3.6.1
Deleting a Static Application File
16.3.6.2
Deleting All Static Application Files
16.4
Managing Static Workspace Files
16.4.1
Uploading Static Workspace Files
16.4.2
Viewing Static Workspace File Report
16.4.3
About Referencing Static Workspace Files
16.4.4
Downloading Static Workspace Files
16.4.4.1
Downloading a Static Workspace File
16.4.4.2
Downloading All Static Workspace Files in a Zip
16.4.5
Deleting Static Workspace Files
16.4.5.1
Deleting a Static Workspace File
16.4.5.2
Deleting All Static Workspace Files
16.5
Managing Application-Level Items
16.5.1
Creating an Application-Level Item
16.5.2
Viewing Application Item Usage
16.5.3
Editing Application-Level Item Attributes
16.5.4
About Creating an Application-Level Item that Functions as a Global Variable
16.6
Creating Lists of Values at the Application Level
16.6.1
What is a List of Values?
16.6.2
Creating a Named LOV at the Application Level
16.6.3
About Static LOVs
16.6.4
Editing an Existing LOV
16.6.4.1
Editing a LOV
16.6.4.2
Editing LOVs in Bulk
16.6.5
About Referencing Session State Within an LOV
16.6.6
Accessing LOV Reports
16.7
Creating Lists
16.7.1
About Creating Lists
16.7.2
About Navigation Menus
16.7.3
Creating Static Lists
16.7.3.1
About the Process of Creating a Static List
16.7.3.2
Creating a Static List from Scratch
16.7.3.3
About Adding Entries and Sublists to a Static List
16.7.3.4
Adding Entries or Sublists from Scratch
16.7.3.5
Copying Static List Entries Between Lists
16.7.3.6
Reparenting Static List Entries
16.7.3.7
Managing Orphaned Static List Entries
16.7.3.8
Resequencing Static List Entries
16.7.4
Creating Dynamic Lists
16.7.4.1
About the Process of Creating a Dynamic List
16.7.4.2
Understanding Dynamic List Syntax
16.7.4.3
Creating a Dynamic List from Scratch
16.7.5
Copying a List
16.7.5.1
Copying a List from the Current Application
16.7.5.2
Copying a List Between Applications
16.7.6
Adding a List to a Page
16.7.7
Editing List Attributes
16.7.8
Accessing List Reports
16.8
Using Shortcuts
16.8.1
What is a Shortcut?
16.8.2
Understanding Shortcut Types
16.8.2.1
Supported Shortcut Types
16.8.2.2
Text with JavaScript Escaped Single Quotes
16.8.2.3
Message
16.8.2.4
Message with JavaScript Escaped Single Quotes
16.8.3
Defining and Referencing Shortcuts
16.8.3.1
Defining a Shortcut from Scratch
16.8.3.2
Copying an Existing Shortcuts
16.8.3.3
Referencing a Shortcut
16.8.4
Editing Existing Shortcuts
16.8.5
Accessing Shortcut Reports
16.9
Managing Report Output
16.9.1
Printing a Report Region by Defining a Report Query
16.9.1.1
About Report Queries
16.9.1.2
Creating a Report Query
16.9.1.3
Editing a Report Query
16.9.1.4
Copying a Report Query
16.9.2
Formatting a Report Region or Report Query Using Report Layouts
16.9.2.1
About Report Layouts
16.9.2.2
About Report Layout Options
16.9.2.3
Creating a Report Layout
16.9.2.4
Editing a Report Layout
16.9.2.5
Copying a Report Layout
17
Managing Application Data
17.1
Creating Applications with Data Loading Capability
17.1.1
About Creating a Data Load Wizard
17.1.2
Creating a Data Load Wizard
17.1.3
Re-creating a Data Load Pages
17.1.4
Editing the Data Load Definition
17.2
About Using Collections
17.3
Implementing Web Services
17.3.1
About Web Services
17.3.2
Creating Web Service References in Oracle Application Express
17.3.2.1
Accessing the Web Service References Page
17.3.2.2
Specifying an Application Proxy Server Address
17.3.3
About Working with SSL Enabled Web Services
17.3.4
Creating Web Service References Based on a WSDL
17.3.4.1
About Creating Web Service References Based on a WSDL
17.3.4.2
Creating a Web Service Reference by Specifying a WSDL Document
17.3.4.3
Testing a Web Service Reference Created from a WSDL
17.3.5
Creating Web Service References Manually
17.3.5.1
About Creating Web Service References Manually
17.3.5.2
Creating a Web Service Reference Manually
17.3.5.3
Testing a Web Service Reference Created Manually
17.3.6
Creating RESTful Web Service References
17.3.6.1
About Creating RESTful Web Service References
17.3.6.2
Creating a RESTful Web Service Reference
17.3.6.3
Testing a REST Web Service Reference
17.3.7
Using the Web Service Reference Repository
17.3.8
Creating an Input Form and Report on a Web Service
17.3.8.1
About the Create Form and Report on Web Service Wizard
17.3.8.2
Creating a Form and Report After Creating a Reference
17.3.8.3
Creating a Form and Report by Adding a New Page
17.3.9
Creating a Form on a Web Service
17.3.9.1
About the Create Form on Web Service Wizard
17.3.9.2
Creating a Form After Creating a Reference
17.3.9.3
Creating a Form by Adding a New Page
17.3.10
How to Invoke a Web Service as a Process
17.3.10.1
Invoking a Web Service as a Process
17.3.10.2
Displaying Web Service Results in a Report
17.3.11
Editing a Web Service Process
17.3.12
Viewing a Web Service Reference History
17.3.13
Exposing a Report Region as a RESTful Web Service
17.3.13.1
About Exposing a Report Region as a RESTful Web Service
17.3.13.2
Enabling RESTful Access to a Report Region
17.3.13.3
About Accessing a RESTful Enabled Report Region from a Web Service Client
17.4
Accessing Data with Database Links
17.4.1
About Database Links
17.4.2
Creating a Database Link
17.4.3
Viewing an Existing Database Link
17.5
About DML Locking
17.5.1
About DML Locking
17.5.2
APEX_DML_LOCK_WAIT_TIME
17.5.3
FSP_DML_LOCK_ROW
18
Extending Application Capabilities
18.1
Sending Email from an Application
18.1.1
About Configuring Email
18.1.1.1
About Enabling Network Services
18.1.1.2
About Configuring Email in a Full Development Environment
18.1.2
About Email Provisioning
18.1.3
About the Mail Queue
18.1.4
About the APEX_MAIL Package
18.2
Implementing Plug-ins
18.2.1
About Plug-ins
18.2.2
Viewing Plug-in Examples
18.2.3
Accessing the Plug-ins Page
18.2.4
Creating a Plug-in
18.2.5
Editing a Plug-in
18.2.6
Adding Custom Attributes to a Plug-in
18.2.7
Uploading Files Associated with a Plug-in
18.2.7.1
Uploading a File to Associate with a Plug-in
18.2.7.2
Automatically Loading CSS and JavaScript Files
18.2.8
Adding Events to a Plug-in
18.2.9
Deleting a Plug-in
18.2.10
Viewing the Plug-in Repository
18.2.11
Importing a Plug-in from the Plug-in Page
18.2.12
Exporting a Plug-in from the Plug-in Page
18.2.13
Resetting the Plug-in Interactive Report
18.2.14
Viewing Plug-in Utilization Page
18.2.15
Viewing Plug-in History
18.3
Understanding jQuery and jQuery UI Support
18.3.1
About Compatibility Issues When Upgrading from Application Express Release 4.X to 5.1
18.3.2
About Available jQuery UI Features
18.3.2.1
About Accessing Other jQuery UI Components
18.3.3
Referencing the jQuery Library in Your JavaScript Code
18.3.3.1
About Managing JavaScript Code in Your Application
18.3.3.2
About Using JavaScript Code in a Plug-In
18.4
Manually Refreshing Oracle Application Express Components
19
Managing Application Security
19.1
Understanding Administrator Security Best Practices
19.1.1
About Oracle Application Express Administrator Roles
19.1.2
About Configuring Oracle REST Data Services with Oracle Application Express
19.1.3
About Configuring Oracle HTTP Server with mod_plsql with Oracle Application Express
19.1.4
About Security Considerations When Using the Embedded PL/SQL Gateway
19.1.5
Managing Instance Security
19.1.5.1
About Creating Login Controls
19.1.5.2
About Enabling Public File Upload
19.1.5.3
About Restricting User Access by IP Address
19.1.5.4
About Specifying an Instance Proxy
19.1.5.5
About Utilizing Secure Sockets Layer
19.1.5.6
About Enabling RESTful Access
19.1.5.7
About Rejoin Sessions
19.1.5.8
About Isolating Workspaces
19.1.5.9
About Utilizing Session Timeout
19.1.5.10
Restricting Password Reuse
19.1.5.11
About Using SQL in Websheets
19.1.5.12
About Enabling RESTful Services
19.1.6
Configuring Instance Settings
19.1.6.1
About Enabling Self Service Workspace Provisioning
19.1.6.2
About Enabling and Configuring Email
19.1.6.3
About Configuring Storage Options
19.1.6.4
About Creating Wallets
19.1.7
About Configuring Workspace Purge Settings
19.1.8
Understanding Workspace Management
19.1.8.1
About Managing Workspace to Schema Assignments
19.1.8.2
About Managing Developers and Users
19.1.8.3
About Managing Component Availability
19.1.9
About Integrating with Oracle BI Publisher
19.1.10
About the Advantages of the Application Express Runtime Environment
19.1.11
Enabling Network Services in Oracle Database 11
g
or Later
19.1.11.1
When and Why Network Services Must be Enabled
19.1.11.2
Granting Connect Privileges Prior to Oracle Database 12
c
19.1.11.3
Granting Connect Privileges in Oracle Database 12
c
19.1.11.4
Troubleshooting an Invalid ACL Error
19.2
Understanding Developer Security Best Practices
19.2.1
About Items of Type Password
19.2.2
Identifying At Risk Password Items
19.2.2.1
Viewing the Security Profiles Report
19.2.2.2
Viewing the Password Items Report
19.2.3
Understanding Cross-Site Scripting Protection
19.2.3.1
What Is Cross Site-scripting Security Breach?
19.2.3.2
Protecting HTML Regions and Other Static Areas
19.2.3.2.1
About Protecting HTML Regions and Other Static Areas
19.2.3.2.2
About Safe Item Display Types
19.2.3.2.3
About the Rules Used to Determine Whether to Escape Values
19.2.3.2.4
About Using Safe Item Types to Hold and Emit HTML Markup
19.2.3.3
About Protecting Dynamic Output
19.2.3.4
About Protecting Report Regions
19.2.3.5
About Protecting Form Items
19.2.3.6
About Restricting Characters Entered on an Item
19.2.4
About Session State and Security
19.2.5
Understanding Session State Protection
19.2.5.1
How Session State Protection Works
19.2.5.2
Enabling Session State Protection
19.2.5.2.1
Enabling Session State Protection from Edit Security Attributes
19.2.5.2.2
Enabling Session State Protection from Session State Protection
19.2.5.3
Configuring Session State Protection
19.2.5.3.1
About Configuring Session State Protection
19.2.5.3.2
Reviewing Existing Session State Protection Settings
19.2.5.3.3
Configuring Session State Protection Using a Wizard
19.2.5.3.4
Configuring Session State Protection for Pages
19.2.5.3.5
Configuring Session State Protection for Page Items
19.2.5.3.6
Configuring Session State Protection for Application Items
19.2.6
About Securing File Uploads
19.3
Controlling Access to Applications, Pages, and Page Components
19.3.1
How the Access Control List Works
19.3.2
Creating an Access Control List
19.3.2.1
Creating an Access Control from the Application Home Page
19.3.2.2
Creating an Access Control While Editing a Page
19.3.3
Selecting an Application Mode and Adding Users
19.3.3.1
Selecting an Application Mode
19.3.3.2
Adding Users to an Access Control List and Selecting Privileges
19.3.3.3
Removing Users from the Access Control List
19.3.4
About Controlling Access for Pages and Page Components
19.4
Establishing User Identity Through Authentication
19.4.1
Understanding Authentication
19.4.1.1
How Authentication Works
19.4.1.2
About Support for Deep Linking
19.4.1.3
About Determining Whether to Include Authentication
19.4.2
Creating an Authentication Scheme
19.4.3
Understanding Preconfigured Authentication Schemes
19.4.3.1
Application Express Accounts
19.4.3.1.1
About Application Express Accounts
19.4.3.1.2
Setting Up Application Express Accounts Authentication
19.4.3.2
Custom Authentication
19.4.3.2.1
About Custom Authentication
19.4.3.2.2
Setting Up Custom Authentication
19.4.3.2.3
About Session Management Security
19.4.3.3
Database Accounts
19.4.3.3.1
About Database Account Credentials
19.4.3.3.2
Setting Up Database Account Credentials
19.4.3.4
HTTP Header Variable
19.4.3.4.1
About HTTP Header Variable
19.4.3.4.2
Setting Up HTTP Header Variable
19.4.3.5
LDAP Directory Verification
19.4.3.5.1
About LDAP Directory Verification
19.4.3.5.2
Setting Up LDAP Directory Verification
19.4.3.6
No Authentication (using DAD)
19.4.3.6.1
About DAD Credentials Verification
19.4.3.6.2
Setting Up DAD Credentials Verification
19.4.3.7
Open Door Credentials
19.4.3.7.1
About Door Credentials
19.4.3.7.2
Setting Up Open Door Credentials
19.4.3.8
Oracle Application Server Single Sign-On Server
19.4.3.8.1
About Application Server Single Sign-On Server
19.4.3.8.2
Setting Up Oracle Application Server Single Sign-On
19.4.4
Managing Existing Authentication Schemes
19.4.5
Viewing the Authentication Scheme Associated with an Application
19.4.6
Changing the Authentication Scheme Associated with an Application
19.4.7
Creating a Login Page
19.4.8
Viewing Authentication Scheme Reports
19.5
Providing Security Through Authorization
19.5.1
How Authorization Schemes Work
19.5.2
Creating and Editing an Authorization Scheme
19.5.2.1
About Authorization Scheme Types
19.5.2.2
Creating an Authorization Scheme
19.5.2.3
Editing Attributes of an Existing Authorization Scheme
19.5.2.4
Changing the Evaluation Point Attribute
19.5.2.5
About Resetting Authorization Scheme State
19.5.3
Attaching an Authorization Scheme to an Application, Page, or Components
19.5.3.1
Attaching an Authorization Scheme to an Application
19.5.3.2
Attaching an Authorization Scheme to a Page
19.5.3.3
Attaching an Authorization Scheme to a Control or Component
19.5.4
Viewing Authorization Reports
20
Managing Application Globalization
20.1
Understanding Application Translation and Globalization Support
20.1.1
About the Translation Process
20.1.2
About Language Identification
20.1.3
About the Rules for Translating Database Applications
20.1.4
How Translated Applications Are Rendered
20.1.5
Making Application Attributes Translatable
20.1.5.1
About Shortcuts that Support Translatable Messages
20.1.5.2
About Messages
20.1.5.3
About Dynamic Translation Text Strings
20.1.5.4
About Translating Region Titles
20.1.5.4.1
Marking a Region as Not Translatable in Page Designer
20.1.5.4.2
Marking a Region as Not Translatable in Legacy Component View
20.1.5.5
About Translating Templates
20.2
Specifying the Primary Language for an Application
20.3
Using Format Masks for Items
20.3.1
About Apply Format Masks to Items
20.3.2
Example of Editing Item Attributes
20.4
About Translating Applications for Multibyte Languages
20.5
Understanding the Translation Process
20.5.1
Step 1: Map the Target Language
20.5.2
Step 2: Seed and Download to a Translation File
20.5.2.1
Seeding Translatable Text
20.5.2.2
Downloading an XLIFF File
20.5.2.2.1
About the XLIFF Export Page
20.5.2.2.2
Downloading a XLIFF file for an Application
20.5.2.2.3
Downloading an XLIFF File for an Application Page
20.5.2.2.4
About Including XLIFF Target Elements
20.5.3
Step 3: Translate the XLIFF File
20.5.4
Step 4: Upload and Apply a Translated XLIFF Document
20.5.4.1
Uploading a Translated XLIFF Document
20.5.4.2
Applying an Uploaded XLIFF Document
20.5.4.3
Deleting an Uploaded XLIFF Document
20.5.5
Step 5: Publish the Application
20.5.6
Manually Editing a Translation
20.6
Translating Messages
20.6.1
About Translating Messages
20.6.2
Translating Messages Used in PL/SQL Procedures
20.6.2.1
About Translating Messages Used in PL/SQL Procedures
20.6.2.2
Defining a Translation Message
20.6.3
Interactive Grid Messages Requiring Translation
20.6.4
Translating Messages Used Internally by Oracle Application Express
20.6.4.1
Creating Text Messages
20.6.4.2
Editing Text Messages
20.6.4.3
Internal Messages Requiring Translation
20.6.4.4
Interactive Report Messages Requiring Translation
20.7
Translating Data That Supports List of Values
20.7.1
Defining a Dynamic Translation
20.8
Understanding Supported Globalization Codes
20.8.1
Oracle Application Express Globalization Codes
21
Managing Application Performance
21.1
About Best Practices to Improve Performance
21.2
Identifying Performance Issues
21.2.1
About Troubleshooting Slow Running Applications
21.2.2
Diagnosing Performance Issues
21.2.3
About Debugging Problematic SQL Queries
21.2.4
About Addressing Slow Queries
21.3
Utilizing Logs and Reports
21.3.1
How to Manage Log Files
21.3.2
Viewing the Application Dashboard Report
21.3.3
Workspace Activity Reports
21.3.4
Instance Activity Reports
21.4
About Utilizing Database Reporting
21.5
About Database Parameters that Impact Performance
21.6
About Limiting Resources
21.7
About Uploading Static Files to Your Web Server
21.8
Creating Custom Activity Reports Using APEX_ACTIVITY_LOG
21.8.1
Enabling Logging for an Application
21.8.2
APEX_ACTIVITY_LOG
21.8.3
APEX_ACTIVITY_LOG Sample Query
22
Debugging an Application
22.1
Running Advisor to Check Application Integrity
22.1.1
About Oracle Application Express Advisor
22.1.2
Running Advisor on an Entire Application
22.1.3
Running Advisor on a Single Page
22.2
Reviewing Session State
22.3
About Monitoring Application and Page Resource Use
22.4
Enabling SQL Tracing and Using TKPROF
22.5
Utilizing Debug Mode
22.5.1
About Debug Mode
22.5.2
Enabling and Disabling Debug Mode for an Application
22.5.3
Running an Application in Debug Mode
22.5.4
Viewing Debug Reports in Development Mode
22.5.5
About Using f?p Syntax to Access Debug Mode
22.5.6
Viewing Debug Reports from a Running Application
22.5.7
Viewing Debug Reports
22.6
About Removing Controls and Components to Isolate a Problem
23
Deploying an Application
23.1
About Suggested Environments
23.2
System Development Life Cycle Methodologies to Consider
23.2.1
About Iterative Vs Planned Development
23.2.2
About the Advantages of Creating Prototypes
23.2.3
Waterfall
23.2.4
Spiral
23.2.5
Rapid Application Development
23.3
Understanding the Deployment Process
23.3.1
About Moving an Application to Another Instance
23.3.2
Deployment Options to Consider
23.3.3
About Whether to Copy a Workspace
23.3.4
About Whether to Copy a Database
23.3.5
About the Application ID
23.4
How to Move an Application to Another Instance
23.4.1
About Managing Database Objects
23.5
How to Create a Custom Packaged Application
23.5.1
How Creating a Custom Packaged Application Simplifies Deployment
23.5.2
Creating a Custom Packaged Application
23.5.2.1
Accessing the Supporting Objects Page
23.5.2.2
Supporting Objects Page
23.5.2.2.1
Installation
23.5.2.2.2
Upgrade
23.5.2.2.3
Deinstallation
23.5.3
Adding an Access Control List to a Custom Packaged Application
23.5.4
Installing Supporting Objects
23.5.5
Deleting Supporting Objects Scripts, Messages, and Installation Options
23.5.6
Upgrading a Custom Packaged Application
23.5.6.1
Defining an Upgrade Script
23.5.6.2
Upgrading a Custom Packaged Application
23.5.7
Deinstalling Supporting Objects
23.5.8
Viewing an Install Summary
23.6
Exporting an Application and Application Components
23.6.1
About the Export Process
23.6.2
About The Export Page
23.6.3
Exporting an Application
23.6.4
Exporting Application Components
23.6.5
Exporting a Workspace
23.6.6
Exporting a Page in an Application
23.6.7
Exporting a Websheet
23.6.8
About Exporting Static Files
23.6.9
Exporting Themes
23.6.10
Exporting Plug-ins
23.6.11
Exporting User Interface Defaults
23.6.11.1
About Exporting User Interface Defaults
23.6.11.2
Exporting User Interface Defaults from the Export Page
23.6.11.3
Exporting User Interface Defaults from the User Interface Defaults Page
23.6.12
Exporting Team Development Feedback
23.6.13
Exporting Script Files from the Script Repository
23.7
Importing Export Files
23.7.1
Importing an Application, Page or Component Export
23.7.2
About Importing Application Groups
23.7.3
Importing a Websheet
23.7.4
Importing Plug-ins
23.7.5
Importing Themes
23.7.6
Importing User Interface Defaults
23.7.7
Importing Team Development Feedback
23.8
Installing Export Files
23.8.1
About Installing Export Files
23.8.2
Accessing the Export Repository
23.8.3
Installing an Application Export from the Export Repository
23.8.4
Installing Other Files from the Export Repository
23.8.5
Deleting Files from the Export Repository
23.8.6
Installing Export Files from SQL*Plus
23.8.7
Using SQL*Plus to Install Export Files
23.9
About Publishing the Database Application URL
23.10
About Publishing the Websheet Application URL
23.11
Using Build Options to Control Configuration
23.11.1
Creating Build Options
23.11.2
Managing Build Options
23.11.3
Selecting a Build Option
23.11.4
Exporting Build Options or Build Option Status
23.11.5
Viewing the Build Option Utilization Report
24
Managing Application Legacy Components
24.1
Managing Pages in Legacy Component View
24.1.1
Legacy Component View Window
24.1.2
Switching from Page Designer to Legacy Component View
24.1.3
Understanding Legacy Component View UI Elements
24.1.3.1
Component View Toolbar
24.1.3.2
Component View Navigation Bar
24.1.3.3
Page Rendering
24.1.3.4
Page Processing
24.1.3.5
Shared Components
24.1.4
Using Legacy Component View
24.1.4.1
Viewing a Page in Legacy Component View
24.1.4.2
Edit All, Copy, and Create Icons
24.1.4.3
Creating a Page Control in Legacy Component View
24.1.5
Accessing Page Attributes in Legacy Component View
24.1.5.1
Editing Page Attributes in Component View
24.1.5.2
Page Attributes in Component View
24.1.5.2.1
Name
24.1.5.2.2
Display Attributes
24.1.5.2.3
JavaScript
24.1.5.2.4
CSS
24.1.5.2.5
Dialog
24.1.5.2.6
HTML Header
24.1.5.2.7
Header and Footer
24.1.5.2.8
Read Only
24.1.5.2.9
Security
24.1.5.2.10
Duplicate Submission
24.1.5.2.11
Server Cache
24.1.5.2.12
Configuration
24.1.5.2.13
Error Handling
24.1.5.2.14
Help
24.1.5.2.15
Comments
24.1.5.3
Incorporating JavaScript Using Component View
24.1.5.4
Configuring Rejoin Sessions in Component View
24.1.5.5
Configuring Dialog Attributes in Component View
24.1.6
Running a Page in Legacy Component View
24.1.7
Runtime Developer Toolbar
24.1.8
Copying a Database Application Page in Legacy Component View
24.1.9
Deleting Pages in Legacy Component View
24.1.9.1
Deleting a Page in Component View
24.1.9.2
Deleting a Page While Editing Page Attributes
24.1.9.3
Deleting Multiple Pages
24.1.9.4
Deleting a Range of Pages
24.2
Managing Legacy Charts
24.2.1
About Chart Types
24.2.1.1
About HTML5 Charts
24.2.1.2
About Flash Charts
24.2.2
Creating SQL Queries for Charts
24.2.2.1
Standard Chart Syntax
24.2.2.2
Dial Chart Syntax (Flash and HTML5)
24.2.2.3
Multiple Series Syntax (Flash and HTML5)
24.2.2.4
Range Chart Syntax (Flash and HTML5)
24.2.2.5
Scatter Chart Syntax (Flash and HTML5)
24.2.2.6
Candlestick Chart Syntax (Flash and HTML5)
24.2.2.7
Gantt Chart Syntax (Flash Only)
24.2.3
Adding a Legacy Chart to a New Page
24.2.4
Managing Charts in Page Designer
24.2.4.1
Adding a Chart in Page Designer
24.2.4.2
Editing Chart Attributes in Page Designer
24.2.4.3
Switching an HTML5 Chart to a Flash Chart
24.2.4.4
Enabling Asynchronous Updates
24.2.4.4.1
Enabling the Asynchronous Update Attribute
24.2.4.4.2
Creating a Refresh Dynamic Action in Page Designer
24.2.5
Managing Charts in Legacy Component View
24.2.5.1
Adding a Chart in Component View
24.2.5.2
Switching an HTML5 Chart to a Flash Chart
24.2.5.3
Editing Chart Attributes in Component View
24.2.5.4
Enabling Asynchronous Updates
24.2.5.4.1
Enabling the Asynchronous Update Attribute
24.2.5.4.2
Creating a Refresh Dynamic Action
24.2.6
Understanding SVG Chart Support
24.2.6.1
Upgrading SVG Charts to HTML5
24.2.6.1.1
About SVG Chart Upgrade Restrictions
24.2.6.1.2
Upgrading an SVG Chart to HTML5
24.2.6.1.3
Upgrading all SVG Charts in an Application to HTML5
24.2.6.2
Understanding SVG Chart Cascading Style Sheet Classes
24.2.6.3
Referencing a Custom SVG Chart Cascading Style Sheet
24.2.6.4
Specifying Custom CSS Styles Inline for SVG Charts
24.2.6.5
Displaying SVG Charts in Other Languages
24.2.7
Understanding HTML Chart Support
24.2.7.1
Upgrading an HTML Chart to HTML5
24.2.7.2
Upgrading All HTML Charts to HTML5
24.2.8
About Saving Flash Charts
24.2.9
Using Custom XML with Flash and HTML5 Charts
24.3
Creating a Legacy Master Detail Form
24.4
Managing Legacy Tabular Forms
24.4.1
About Creating Tabular Forms
24.4.2
About Running a Tabular Form
24.4.3
How Tabular Forms Work
24.4.4
Creating a Legacy Tabular Form
24.4.5
Synchronizing Tabular Form Column Order with Region Source
24.5
Managing Legacy Calendars
24.5.1
Creating a Legacy Classic Calendar
24.5.2
Managing Calendars in Legacy Component View
24.5.2.1
Editing Calendar Attributes in Component View
24.5.2.2
Editing an Existing Calendar to Include Add and Edit Functionality
24.5.2.3
Enabling the Dragging and Dropping of Data In an Existing Legacy Calendar
24.5.3
About Supported Calendar Substitution Strings in Legacy Calendars
24.6
Viewing Legacy Components in Gallery
A
About Item Types
A.1
Available Item Types
B
Oracle Application Express Limits
B.1
Component Limits
C
Available Conditions
C.1
Conditions
C.2
Conditions Available in
App Builder
D
About Granted Privileges
D.1
About Granting Privileges to Database Users
D.2
Understanding Privileges Granted to PUBLIC
D.2.1
Packages
D.2.2
Procedures
D.2.3
Functions
D.2.4
Tables
D.2.5
Views
D.2.6
Sequences
D.2.7
Types
Index
Scripting on this page enhances content navigation, but does not change the content in any way.