Table of Contents
- Title and Copyright Information
- Preface
- 1 Changes in Release 20.2 for Oracle Application Express App Builder User’s Guide
-
2
Quick Start
- 2.1 About Accessing Your Development Environment
- 2.2 Understanding Oracle Application Express
- 2.3 Understanding the Workspace Home Page
- 2.4 Understanding App Builder
- 2.5 Changing Your Profile or Password
- 2.6 Editing User Preferences and Enabling Dark Mode
- 2.7 Using Oracle Application Express Documentation
-
3
App Builder Concepts
- 3.1 Understanding Database Applications
- 3.2 Running an Application or Page
- 3.3 How Does Page Processing and Page Rendering Work?
- 3.4 About Enabling Support for Bookmarks
- 3.5 Understanding Session State Management
- 3.6 Viewing Session State
- 3.7 Understanding URL Syntax
- 3.8 Managing Session State Values
-
3.9
Using Substitution Strings
- 3.9.1 About Using Substitution Strings
- 3.9.2 Controlling Output Escaping in Substitution Strings
- 3.9.3 About Determining Substitution String Usage within Templates
-
3.9.4
Using Built-in Substitution Strings
- 3.9.4.1 APEX$ROW_NUM
- 3.9.4.2 APEX$ROW_SELECTOR
- 3.9.4.3 APEX$ROW_STATUS
- 3.9.4.4 APP_ID
- 3.9.4.5 APP_ALIAS
- 3.9.4.6 APP_AJAX_X01, ... APP_AJAX_X10
- 3.9.4.7 APP_BUILDER_SESSION
- 3.9.4.8 APP_DATE_TIME_FORMAT
- 3.9.4.9 APP_IMAGES
- 3.9.4.10 APP_NLS_DATE_FORMAT
- 3.9.4.11 APP_NLS_TIMESTAMP_FORMAT
- 3.9.4.12 APP_NLS_TIMESTAMP_TZ_FORMAT
- 3.9.4.13 APP_PAGE_ALIAS
- 3.9.4.14 APP_PAGE_ID
- 3.9.4.15 APP_REGION_ID
- 3.9.4.16 APP_REGION_STATIC_ID
- 3.9.4.17 APP_REQUEST_DATA_HASH
- 3.9.4.18 APP_SESSION
- 3.9.4.19 APP_SESSION_VISIBLE
- 3.9.4.20 APP_TITLE
- 3.9.4.21 APP_UNIQUE_PAGE_ID
- 3.9.4.22 APP_USER
- 3.9.4.23 AUTHENTICATED_URL_PREFIX
- 3.9.4.24 BROWSER_LANGUAGE
- 3.9.4.25 CURRENT_PARENT_TAB_TEXT
- 3.9.4.26 DEBUG
- 3.9.4.27 HOME_LINK
- 3.9.4.28 IMAGE_PREFIX
- 3.9.4.29 JET_BASE_DIRECTORY
- 3.9.4.30 JET_CSS_DIRECTORY
- 3.9.4.31 JET_JS_DIRECTORY
- 3.9.4.32 LOGIN_URL
- 3.9.4.33 LOGOUT_URL
- 3.9.4.34 APP_TEXT$Message_Name, APP_TEXT$Message_Name$Lang
- 3.9.4.35 PRINTER_FRIENDLY
- 3.9.4.36 PROXY_SERVER
- 3.9.4.37 PUBLIC_URL_PREFIX
- 3.9.4.38 REQUEST
- 3.9.4.39 Using REQUEST
- 3.9.4.40 SCHEMA OWNER
- 3.9.4.41 SQLERRM
- 3.9.4.42 SYSDATE_YYYYMMDD
- 3.9.4.43 THEME_DB_IMAGES
- 3.9.4.44 THEME_IMAGES
- 3.9.4.45 WORKSPACE_IMAGES
- 3.9.4.46 WORKSPACE_ID
- 3.10 Using Template Directives
-
4
Utilizing the App Gallery
- 4.1 About App Gallery
-
4.2
Managing Productivity and Sample Apps in a Full Development Environment
- 4.2.1 Accessing the App Gallery Page
- 4.2.2 Installing a Productivity and Sample App
- 4.2.3 Running a Productivity and Sample App
- 4.2.4 Removing a Productivity and Sample App
- 4.2.5 Changing Authentication for an Installed Productivity and Sample App
- 4.2.6 Unlocking an Installed Productivity Application
- 4.2.7 Updating a Productivity and Sample App
-
4.3
Understanding Sample Database Application
- 4.3.1 Installing and Running Sample Database Application
- 4.3.2 Reviewing Sample Database Application
- 4.3.3 Modifying Sample Database Application
- 4.4 Utilizing App Administration
- 4.5 Using a Productivity and Sample Apps Only Workspace
-
5
Managing Team Development
- 5.1 Getting Started with Team Development
-
5.2
Creating and Updating
Issues
- 5.2.1 Issues Page
- 5.2.2 Creating an Issue
- 5.2.3 Updating Multiple Issues at Once
-
5.2.4
Updating an Issue
- 5.2.4.1 Issue Details Page
- 5.2.4.2 Updating the Issue Title
- 5.2.4.3 Updating the Issue Description
- 5.2.4.4 Managing Comments
- 5.2.4.5 Setting Assignees
- 5.2.4.6 Setting Labels
- 5.2.4.7 Setting Milestones
- 5.2.4.8 Associating an Issue with an App and Page
- 5.2.4.9 Marking an Issue as Duplicate
- 5.2.4.10 Closing an Issue
- 5.2.4.11 Managing Deleted Issues
- 5.3 Viewing Your User Profile
- 5.4 Managing Labels
- 5.5 Managing Milestones
- 5.6 Managing Templates
- 5.7 Using Team Development Utilities
-
5.8
Managing Feedback
- 5.8.1 About Feedback
- 5.8.2 Adding Feedback Using the Create Application Wizard
- 5.8.3 Adding Feedback Using the Create Page Wizard
- 5.8.4 Submitting Feedback Within a Running Application
- 5.8.5 Reviewing Feedback Within an Application
- 5.8.6 Configuring Feedback to Support Attachments
- 5.8.7 Tracking Feedback
-
6
Creating Database Applications
- 6.1 About the Create Application Wizard
- 6.2 Creating a Database Application Based on a Table or Query
- 6.3 Understanding Page Types, Features, and Settings
- 6.4 Creating a Database Application from a File
- 6.5 Using Application Blueprints
- 6.6 Copying a Database Application
- 6.7 Creating Applications for Mobile Devices
- 6.8 Deleting an Application
-
6.9
Managing Application Attributes
- 6.9.1 Editing the Application Definition
- 6.9.2 Configuring Security Attributes
-
6.9.3
Configuring Globalization Attributes
- 6.9.3.1 Accessing the Globalization Page
-
6.9.3.2
Globalization Page
- 6.9.3.2.1 Application Primary Language
- 6.9.3.2.2 Application Language Derived From
- 6.9.3.2.3 Document Direction
- 6.9.3.2.4 Application Date Format
- 6.9.3.2.5 Application Date Time Format
- 6.9.3.2.6 Application Timestamp Format
- 6.9.3.2.7 Application Timestamp Time Zone Format
- 6.9.3.2.8 Character Value Comparison
- 6.9.3.2.9 Character Value Comparison Behavior
- 6.9.3.2.10 Automatic Time Zone
- 6.9.3.2.11 Automatic CSV Encoding
- 6.9.4 Editing User Interface Attributes
- 6.10 Adding Developer Comments
- 6.11 Using the Find Icon
- 6.12 Adding Database Application Comments
- 6.13 Managing Application Groups
-
6.14
Using Application Utilities
- 6.14.1 Accessing Application Utilities
- 6.14.2 Application Utilities Page
- 6.14.3 Viewing the Application Dashboard
- 6.14.4 Upgrading an Application to Include New Components
- 6.14.5 Viewing the Recently Updated Pages Report
- 6.14.6 Viewing the Change History Report
- 6.14.7 Accessing Application Express Views
- 6.14.8 Managing Application Backups
- 6.14.9 Using the Embedded Code Utility
- 6.14.10 Accessing Page Specific Utilities
- 6.14.11 Accessing Cross Page Utilities
- 6.14.12 Using Interactive Report Utilities
- 6.15 Using Workspace Utilities
-
7
Managing Pages in a Database Application
- 7.1 About Creating New Pages
- 7.2 Adding a New Page to an Application
- 7.3 Understanding Page Types in the Create Page Wizard
-
7.4
Creating Dialog Pages
- 7.4.1 About Supported Dialogs
- 7.4.2 Using a Dialog Page Template
- 7.4.3 Defining a Dialog Page in Page Designer
- 7.4.4 Generating a Cancel Dialog Dynamic Action on the Dialog Page
- 7.4.5 Generating a Close Dialog Page Process on the Dialog Page
- 7.4.6 About Branching with Dialog Pages
- 7.4.7 Handling Refresh Actions on Parent Page
- 7.5 About Copying Database Application Pages
- 7.6 About Deleting Database Application Pages
- 7.7 Creating Page Groups
- 7.8 Locking and Unlocking a Page
-
8
Editing Pages in Page Designer
- 8.1 About Page Designer
- 8.2 Understanding Page Designer UI Elements
-
8.3
Using Page Designer
- 8.3.1 Viewing a Page in Page Designer
- 8.3.2 Searching for Pages
- 8.3.3 Dragging and Dropping Tabs Between Panes
- 8.3.4 Switching Between Three Pane and Two Pane Mode
- 8.3.5 Accessing Property Editor
- 8.3.6 Adding a Region, Item, or Button by Dragging and Dropping
- 8.3.7 About Adding Components Using Gallery Context Menus
- 8.3.8 Adding a Region, Item, or Button from the Rendering Tab
- 8.3.9 Adding a Region, Item, or Button from the Component View Tab
- 8.3.10 Copying a Region, Item, or Button
- 8.3.11 Creating Pre-Rendering Branches, Computations, and Processes
- 8.3.12 Creating Page Submission Branches, Validations, Computations, and Processes
- 8.4 Managing Page Attributes
- 8.5 Running a Page from Page Designer
- 8.6 Runtime Developer Toolbar
- 8.7 Copying a Database Application Page
- 8.8 Deleting Pages
-
9
Developing Reports
- 9.1 Creating a Report Using the Create Application Wizard
- 9.2 Creating a Report Using the Create Page Wizard
- 9.3 Creating a Report by Dragging and Dropping from the Gallery
- 9.4 Managing Cards
-
9.5
Managing Faceted Search
- 9.5.1 Example Faceted Search
- 9.5.2 About Creating Facet Search Pages
- 9.5.3 Creating Faceted Search Using the Create Application Wizard
- 9.5.4 Creating Faceted Search Using the Create Page Wizard
- 9.5.5 Creating a Faceted Search Manually
-
9.5.6
Editing a Faceted Search Page
- 9.5.6.1 Editing a Faceted Search
- 9.5.6.2 Understanding a Faceted Search Page
- 9.5.6.3 Editing Faceted Search Region Attributes
- 9.5.6.4 Editing Facet Attributes
- 9.5.6.5 Adding a New Facet
- 9.5.6.6 Creating Facet Groups
- 9.5.6.7 Configuring Single Facet Charts
- 9.5.6.8 Editing the Static List of Values for a Range Facet
-
9.6
Managing Interactive Grids
- 9.6.1 Example Interactive Grid
- 9.6.2 Creating an Interactive Grid Using the Create Application Wizard
- 9.6.3 Creating Master Detail from an Existing Interactive Grid
- 9.6.4 Managing Interactive Grid Region Attributes
-
9.6.5
Managing Interactive Grid Attributes
- 9.6.5.1 Editing Interactive Grid Attributes
- 9.6.5.2 Making an Existing Interactive Grid Editable
- 9.6.5.3 Controlling Interactive Grid Pagination
- 9.6.5.4 Customizing the Interactive Grid Toolbar
- 9.6.5.5 Enabling Users to Save Interactive Grid Public Reports
- 9.6.5.6 Enabling Flashback and Charts
- 9.6.5.7 Configuring Interactive Grid Download Formats
- 9.6.5.8 Enabling Icon View in an Interactive Grid
- 9.6.5.9 Enabling Detail View in an Interactive Grid
- 9.6.6 Managing Interactive Grid Column Attributes
- 9.6.7 About Customizing Interactive Grids in a Running Application
-
9.6.8
Saving Interactive Grid Reports
- 9.6.8.1 How the User Type Effects Available Save Options
- 9.6.8.2 About Configuration Dependencies When Saving Interactive Grid Reports
- 9.6.8.3 Saving a Private Interactive Grid Report
- 9.6.8.4 Saving a Public Interactive Grid Report
- 9.6.8.5 Saving or Renaming a Primary Interactive Grid Report
- 9.6.8.6 Saving an Alternative Interactive Grid Report
- 9.6.8.7 Renaming a Saved Interactive Grid Report
- 9.6.8.8 Deleting a Saved Interactive Grid Report
- 9.6.8.9 Resetting a Saved Interactive Grid Report
-
9.6.9
Linking to Interactive Grid Reports
- 9.6.9.1 Interactive Grid Request Syntax
- 9.6.9.2 Interactive Grid Name and Value Syntax
- 9.6.9.3 Interactive Grid ClearCache Syntax
- 9.6.9.4 Restrictions When Linking to Interactive Grid Reports
- 9.6.9.5 Valid Interactive Grid Linking Examples
- 9.6.9.6 Invalid Interactive Grid Linking Examples
- 9.6.9.7 Linking to Shared Interactive Grid Reports
-
9.7
Managing Interactive Reports
- 9.7.1 Example Interactive Report
- 9.7.2 Creating an Interactive Report Using the Create Application Wizard
- 9.7.3 Managing Interactive Report Region Attributes
-
9.7.4
Managing Interactive Report Attributes
- 9.7.4.1 Editing Interactive Report Attributes
- 9.7.4.2 Managing Link Columns
- 9.7.4.3 Customizing the Interactive Report Search Bar
- 9.7.4.4 Customizing the Interactive Report Actions Menu
- 9.7.4.5 Configuring Interactive Report Actions Menu Download Options
- 9.7.4.6 Controlling Interactive Report Pagination
- 9.7.4.7 Enabling Icon View
- 9.7.4.8 Enabling Detail View
- 9.7.4.9 Configuring Advanced Attributes for Interactive Reports
-
9.7.5
Managing Interactive Report Column Attributes
- 9.7.5.1 Editing Interactive Report Column Attributes
- 9.7.5.2 Creating a Column Link in an Interactive Report
- 9.7.5.3 Defining a Column as a List of Values in an Interactive Report
- 9.7.5.4 Formatting Columns in an Interactive Report
- 9.7.5.5 About Filtering on Conditional Links in Interactive Report Columns
-
9.7.6
Customizing Interactive Reports in a Running Application
- 9.7.6.1 About the Search Bar
- 9.7.6.2 About the Actions Menu
- 9.7.6.3 Using Interactive Report Filters
-
9.7.6.4
Saving Interactive Reports
- 9.7.6.4.1 About the User Type and Available Save Options
- 9.7.6.4.2 About Configuration Dependencies When Saving Interactive Reports
- 9.7.6.4.3 Saving a Public or Private Interactive Report
- 9.7.6.4.4 Saving a Default Interactive Report
- 9.7.6.4.5 Renaming a Public or Private Interactive Report
- 9.7.6.4.6 Deleting a Public or Private Interactive Report
- 9.7.6.4.7 About Exporting Interactive Reports
-
9.7.7
Linking to Interactive Reports
- 9.7.7.1 Interactive Report Request Syntax
- 9.7.7.2 Interactive Report Name and Value Syntax
- 9.7.7.3 Interactive Report ClearCache Syntax
- 9.7.7.4 Restrictions When Linking to Interactive Reports
- 9.7.7.5 Valid Interactive Report Linking Examples
- 9.7.7.6 Invalid Interactive Report Linking Examples
- 9.7.7.7 Linking to Shared Interactive Reports
-
9.8
Managing Classic Reports
- 9.8.1 Example Classic Report
- 9.8.2 Creating a Classic Report Using the Create Application Wizard
- 9.8.3 Managing Classic Report Region Attributes
- 9.8.4 Managing Classic Report Attributes
-
9.8.5
Managing Classic Report Column Attributes
- 9.8.5.1 Altering Classic Report Column Layout
- 9.8.5.2 Enabling Column Sorting in a Classic Report
- 9.8.5.3 Creating a Column Link in a Classic Report
- 9.8.5.4 Defining an Updatable Column in a Classic Report
- 9.8.5.5 Defining a Column as a List of Values in a Classic Report
- 9.8.5.6 Controlling When Classic Report Columns Display
- 9.8.5.7 Adding a Download Link to a Classic Report
-
9.9
Printing Report Regions
- 9.9.1 About Report Printing
- 9.9.2 About Printing Reports to PDF
- 9.9.3 Configuring Report Printing at the Application-Level
- 9.9.4 About Classic Report Printing Methods
- 9.9.5 Configuring Classic Report Print Attributes
- 9.9.6 Configuring Interactive Report Regions for Printing
- 9.9.7 About Report Queries
- 9.9.8 About Report Layouts
- 9.10 Understanding BLOB Support in Forms and Reports
-
10
Developing Forms
- 10.1 Understanding Form Types
- 10.2 Creating a Form
- 10.3 Configuring Lost Update Detection
- 10.4 About Making an Interactive Grid Editable
-
10.5
Creating Master Detail Forms
- 10.5.1 About Master Detail Forms
- 10.5.2 Creating a Master Detail Form Using the Create Application Wizard
- 10.5.3 Creating a Stacked Master Detail Using the Create Page Wizard
- 10.5.4 Creating a Side by Side Master Detail Using the Create Page Wizard
- 10.5.5 Creating a Drill Down Master Detail Using the Create Page Wizard
- 10.6 Validating User Input in Forms
- 10.7 Understanding BLOB Support in Forms
-
11
Managing Database Application Components
- 11.1 Understanding Oracle JET Integration with Oracle Application Express
- 11.2 Switching from AnyChart to JET Chart
-
11.3
Creating Calendars
- 11.3.1 About Supported Calendars
- 11.3.2 Sample Calendar
- 11.3.3 Adding a Calendar to a New Page Using a Local Database
- 11.3.4 Adding a Calendar on a New Page Using External Data Sources
- 11.3.5 Creating a Calendar in Page Designer
- 11.3.6 Managing Calendar Attributes
- 11.3.7 About Dynamic Action Support for Calendar
- 11.4 Creating Charts
- 11.5 Creating Help for Your Application
-
12
Using Themes and Theme Styles
- 12.1 Using Themes
-
12.2
Managing Themes and Subscriptions
- 12.2.1 Managing Theme Subscriptions
- 12.2.2 Accessing New Themes
-
12.2.3
Editing Themes
- 12.2.3.1 Editing a Theme
-
12.2.3.2
Theme Attributes
- 12.2.3.2.1 Name
- 12.2.3.2.2 Theme Subscription
- 12.2.3.2.3 JavaScript and Cascading Style Sheets
- 12.2.3.2.4 Component Defaults
- 12.2.3.2.5 Region Defaults
- 12.2.3.2.6 Dialog Defaults
- 12.2.3.2.7 Transition Defaults
- 12.2.3.2.8 Global Templates Options
- 12.2.3.2.9 Icons
- 12.2.3.2.10 Image
- 12.2.3.2.11 Styles
- 12.2.3.2.12 Files
- 12.2.4 Switching Themes
- 12.2.5 Changing a Theme Identification Number
- 12.2.6 Copying a Theme
- 12.2.7 Deleting a Theme
- 12.2.8 Creating a Master Theme Application
- 12.2.9 Managing Workspace Themes
- 12.2.10 Managing Instance Themes
- 12.2.11 About Exporting and Importing Themes
- 12.2.12 Viewing Theme Reports
-
12.3
Creating Custom Themes
- 12.3.1 About Cascading Style Sheets
- 12.3.2 About Calling the JavaScript File from the Page Template
- 12.3.3 About Using Escaping Syntax in Substitution Strings
- 12.3.4 Selecting a Default Page Template
- 12.3.5 Creating a New Template
- 12.3.6 Using Template Options
- 12.3.7 Viewing Template Reports
-
12.3.8
Managing Templates
- 12.3.8.1 Viewing Templates on the Templates Page
- 12.3.8.2 Viewing Templates Associated with a Specific Page
- 12.3.8.3 Replacing Templates
- 12.3.8.4 Replacing All Templates within an Application
- 12.3.8.5 Viewing Region Position Utilization by Page Template
- 12.3.8.6 Unsubscribing to Templates
- 12.3.8.7 Publishing Templates
- 12.3.9 Breadcrumb Templates
- 12.3.10 Button Templates
- 12.3.11 Legacy Calendar Templates
- 12.3.12 Label Templates
- 12.3.13 List Templates
- 12.3.14 Page Templates
- 12.3.15 Popup LOV Templates
- 12.3.16 Region Templates
- 12.3.17 Report Templates
- 12.4 Using Custom Cascading Style Sheets
-
13
Controlling Page Layout
- 13.1 About Page Layout in Oracle Application Express
- 13.2 Optimizing a Page for Printing
- 13.3 Creating a Global Page to Display Components on Every Page
-
13.4
Managing Regions
- 13.4.1 About Regions
- 13.4.2 Creating a Region
-
13.4.3
Editing Regions
- 13.4.3.1 Editing Region Attributes
- 13.4.3.2 Controlling Region Positioning
- 13.4.3.3 Specifying a Region Header and Footer
- 13.4.3.4 Utilizing Region Caching in Page Designer
- 13.4.3.5 Enabling Users to Customize a Page
- 13.4.3.6 Specifying a Static Region ID
- 13.4.3.7 Adding a Region Image
- 13.4.3.8 Creating a Region Display Selector
- 13.4.4 Copying a Region
- 13.4.5 Deleting Regions
- 13.5 About Incorporating Content from Other Web Sites
- 13.6 About Managing Images
- 13.7 Rendering HTML Using Custom PL/SQL
-
14
Managing Database Application Controls
-
14.1
Managing Page-Level Items
- 14.1.1 Understanding Page-Level Items
- 14.1.2 Viewing Page-Level Items
- 14.1.3 Creating Page-Level Items
-
14.1.4
Editing Page-Level Items
- 14.1.4.1 Editing Page Item Attributes in the Property Editor
- 14.1.4.2 Defining Default Values for Page Items
- 14.1.4.3 Configuring Page Item Security
- 14.1.4.4 Changing an Existing Item to Use Quick Picks
- 14.1.4.5 Displaying Conditional Page Items
- 14.1.4.6 Displaying Read Only Page Items
- 14.1.4.7 Applying a Format Mask to an Item
- 14.1.4.8 Configuring Item Attributes to Warn Users of Unsaved Changes
- 14.1.4.9 Controlling How Page Items Write Session State
- 14.1.4.10 Viewing Item Utilities
- 14.2 Managing Dynamic Actions
-
14.3
Managing Buttons
- 14.3.1 What Actions Can a Button Perform?
- 14.3.2 Creating a Button
- 14.3.3 Editing a Button
- 14.3.4 Displaying a Button Conditionally
- 14.3.5 Configuring Button Attributes to Warn Users of Unsaved Changes
- 14.3.6 About Calling JavaScript from a Button
- 14.3.7 About the Relationship Between Button Names and REQUEST
- 14.3.8 About Branching with Buttons
- 14.4 Managing Trees
- 14.5 About Incorporating JavaScript into an Application
-
14.1
Managing Page-Level Items
-
15
Adding Navigation
- 15.1 About Using Lists as Navigation
- 15.2 Creating Breadcrumbs
- 15.3 Controlling Navigation Using Branches
- 15.4 Managing Tabs
-
15.5
Managing a Classic Navigation Bar
- 15.5.1 About Classic Navigation Bar Entries
- 15.5.2 Creating a Classic Navigation Bar Entry
- 15.5.3 Copying a Classic Navigation Bar Entry
- 15.5.4 Editing a Classic Navigation Bar Entry
- 15.5.5 Editing Multiple Classic Navigation Bar Entries Simultaneously
- 15.5.6 Accessing Classic Navigation Bar Entry Reports
-
16
Managing Computations, Validations, and Processes
- 16.1 Understanding Page Computations
-
16.2
Understanding Validations
- 16.2.1 About Validations
- 16.2.2 What Happens When a Validation Fails?
- 16.2.3 Creating a Validation
- 16.2.4 Editing a Validation
- 16.2.5 About Determining When Validations Execute
- 16.2.6 About Defining How Validation Error Messages Display
- 16.2.7 Processing Validations Conditionally
- 16.2.8 About Altering the Go to Error Link
- 16.3 Understanding Page Processes
-
16.4
Understanding Application Processes
- 16.4.1 On Demand Application Processes
- 16.4.2 About Application Processes that Execute On New Instance
- 16.4.3 About Running an On Demand Process from a Page Request
- 16.4.4 Example: Application Process
- 16.4.5 Creating an Application Process
- 16.4.6 Editing Application Process Attributes
- 16.4.7 Creating Application Process Error Messages
- 16.4.8 Viewing the Application Processes History Report
- 16.5 About Branches
- 16.6 Understanding Application Computations
- 16.7 Using the Attribute Dictionary
-
17
Managing Shared Components
- 17.1 Accessing the Shared Components Page
- 17.2 Shared Components Page
- 17.3 Managing Automations
- 17.4 Managing Application Settings
- 17.5 Creating Lists of Values at the Application-Level
-
17.6
Managing Component Settings
- 17.6.1 Configuring Component Settings
- 17.6.2 Integrating with Google Calendar
- 17.6.3 Configuring Color Picker Display
- 17.6.4 Configuring Interactive Report Action Menu Structure
- 17.6.5 Dynamically Adding Sliders to Regions
- 17.6.6 Configuring Switch Defaults
- 17.6.7 Configuring Rich Text Editor Responsiveness
- 17.6.8 Viewing the Component Settings History Report
- 17.7 Using Shortcuts
- 17.8 Managing Email Templates
- 17.9 Managing Static Application Files
- 17.10 Managing Static Workspace Files
- 17.11 Managing Application-Level Items
-
17.12
Creating Lists
- 17.12.1 About Static and Dynamic Lists
-
17.12.2
Creating Static Lists
- 17.12.2.1 About the Process of Creating a Static List
- 17.12.2.2 Creating a Static List from Scratch
- 17.12.2.3 About Adding Entries and Sublists to a Static List
- 17.12.2.4 Adding Entries or Sublists from Scratch
- 17.12.2.5 Copying Static List Entries Between Lists
- 17.12.2.6 Reparenting Static List Entries
- 17.12.2.7 Managing Orphaned Static List Entries
- 17.12.2.8 Resequencing Static List Entries
- 17.12.3 Creating Dynamic Lists
- 17.12.4 Copying a List
- 17.12.5 Adding a List to a Page
- 17.12.6 Editing List Attributes
- 17.12.7 Accessing List Reports
- 17.12.8 Managing Navigation Menus
- 17.12.9 Managing Navigation Bar Lists
- 17.13 Managing Report Output
-
18
Managing Application Data
- 18.1 Creating Applications with Data Loading Capability
- 18.2 About Using Collections
-
18.3
Managing REST Enabled SQL References
- 18.3.1 About REST Enabled SQL Service References
- 18.3.2 Before You Begin: REST Enabled SQL Service Requirements
- 18.3.3 Creating a REST Enabled SQL Service Reference
- 18.3.4 Example: Creating a REST Enabled SQL Service Reference
- 18.3.5 Editing a REST Enabled SQL Service Reference
- 18.3.6 Deleting a REST Enabled SQL Service Reference
- 18.3.7 Creating or Updating Components to Use a REST Enabled SQL
-
18.4
Managing REST Data Sources
- 18.4.1 About REST Data Sources
- 18.4.2 Creating a REST Data Source
- 18.4.3 Editing or Deleting a REST Data Source
- 18.4.4 Copying a REST Data Source
- 18.4.5 Managing Data Synchronization
- 18.4.6 Viewing REST Data Source Utilization
- 18.4.7 Viewing REST Data Sources History
- 18.5 Managing Remote Servers
- 18.6 Managing Web Credentials
- 18.7 Accessing Data with Database Links
- 18.8 About DML Locking
-
19
Extending Application Capabilities
- 19.1 Sending Email from an Application
-
19.2
Implementing Plug-ins
- 19.2.1 About Plug-ins
- 19.2.2 Accessing the Plug-ins Page
- 19.2.3 Creating a Plug-in
- 19.2.4 Editing a Plug-in
- 19.2.5 Adding Custom Attributes to a Plug-in
- 19.2.6 Uploading Files Associated with a Plug-in
- 19.2.7 Adding Events to a Plug-in
- 19.2.8 Deleting a Plug-in
- 19.2.9 Viewing the Plug-in Repository
- 19.2.10 Exporting a Plug-in from the Plug-in Page
- 19.2.11 Importing a Plug-in from the Plug-in Page
- 19.2.12 Resetting the Plug-in Interactive Report
- 19.2.13 Viewing Plug-in Utilization Page
- 19.2.14 Viewing Plug-in History
- 19.3 Understanding jQuery and jQuery UI Support
- 19.4 Manually Refreshing Oracle Application Express Components
-
20
Managing Application Security
-
20.1
Understanding Administrator Security Best Practices
- 20.1.1 About Oracle Application Express Administrator Roles
- 20.1.2 Web Listener Security Considerations
-
20.1.3
Managing Instance Security
- 20.1.3.1 About Creating Login Controls
- 20.1.3.2 About Enabling Public File Upload
- 20.1.3.3 About Restricting User Access by IP Address
- 20.1.3.4 About Specifying an Instance Proxy
- 20.1.3.5 About Utilizing Secure Sockets Layer
- 20.1.3.6 About Enabling RESTful Access
- 20.1.3.7 About Rejoin Sessions
- 20.1.3.8 About Isolating Workspaces
- 20.1.3.9 About Utilizing Session Timeout
- 20.1.3.10 Restricting Password Reuse
- 20.1.3.11 About Using SQL in Websheets
- 20.1.3.12 About Enabling RESTful Services
- 20.1.4 Configuring Instance Settings
- 20.1.5 About Configuring Workspace Purge Settings
- 20.1.6 Understanding Workspace Management
- 20.1.7 About Integrating with Oracle BI Publisher
- 20.1.8 About the Advantages of the Application Express Runtime Environment
- 20.1.9 Enabling Network Services in Oracle Database 11g or Later
-
20.2
Understanding Developer Security Best Practices
- 20.2.1 About Items of Type Password
- 20.2.2 Identifying At Risk Password Items
- 20.2.3 Understanding Cross-Site Scripting Protection
- 20.2.4 About Session State and Security
-
20.2.5
Preventing URL Tampering
- 20.2.5.1 How Session State Protection Works
- 20.2.5.2 Enabling Session State Protection
-
20.2.5.3
Configuring Session State Protection
- 20.2.5.3.1 About Configuring Session State Protection
- 20.2.5.3.2 Reviewing Existing Session State Protection Settings
- 20.2.5.3.3 Configuring Session State Protection Using a Wizard
- 20.2.5.3.4 Configuring Session State Protection for a Page
- 20.2.5.3.5 Configuring Session State Protection for Page Items
- 20.2.5.3.6 Configuring Session State Protection for Application Items
- 20.2.6 About Securing File Uploads
-
20.3
Controlling Access to Applications, Pages, and Page Components
- 20.3.1 Understanding Access Control
- 20.3.2 Creating an Access Control Using the Create Application Wizard
- 20.3.3 Creating an Access Control Using the Create Page Wizard
- 20.3.4 Managing User Access
- 20.3.5 Configuring Access Control
- 20.3.6 About Controlling Access for Pages and Page Components
- 20.3.7 About Removing an Access Control Created with a Wizard
- 20.3.8 Managing Roles and User Assignments
-
20.4
Establishing User Identity Through Authentication
- 20.4.1 Understanding Authentication
- 20.4.2 Creating an Authentication Scheme
-
20.4.3
Understanding Preconfigured Authentication Schemes
- 20.4.3.1 Application Express Accounts
- 20.4.3.2 Custom Authentication
- 20.4.3.3 Database Accounts
- 20.4.3.4 HTTP Header Variable
- 20.4.3.5 LDAP Directory
- 20.4.3.6 No Authentication (using DAD)
- 20.4.3.7 Open Door Credentials
- 20.4.3.8 Oracle Application Server Single Sign-On Server
- 20.4.3.9 Social Sign-In
- 20.4.4 Configuring an Existing Authentication Scheme
- 20.4.5 Viewing the Authentication Scheme Associated with an Application
- 20.4.6 Changing the Authentication Scheme Associated with an Application
- 20.4.7 Creating a Login Page
- 20.4.8 Viewing Authentication Scheme Reports
- 20.5 Providing Security Through Authorization
-
20.1
Understanding Administrator Security Best Practices
-
21
Managing Application Globalization
- 21.1 Understanding Application Translation and Globalization Support
- 21.2 Specifying the Primary Language for an Application
- 21.3 About Apply Format Masks to Items
- 21.4 About Translating Applications for Multibyte Languages
- 21.5 Understanding the Translation Process
- 21.6 Translating Messages
- 21.7 Translating Data That Supports List of Values
- 21.8 Understanding Supported Globalization Codes
-
22
Managing Application Performance
- 22.1 About Best Practices to Improve Performance
- 22.2 Identifying Performance Issues
- 22.3 Utilizing Logs and Reports
- 22.4 About Utilizing Database Reporting
- 22.5 About Database Parameters that Impact Performance
- 22.6 About Limiting Resources
- 22.7 About Uploading Static Files to Your Web Server
- 22.8 Creating Custom Activity Reports Using APEX_ACTIVITY_LOG
-
23
Debugging an Application
- 23.1 Running Advisor to Check Application Integrity
- 23.2 Reviewing Session State
- 23.3 About Monitoring Application and Page Resource Use
- 23.4 Enabling SQL Tracing and Using TKPROF
-
23.5
Utilizing Debug Mode
- 23.5.1 About Debug Mode
- 23.5.2 Enabling and Disabling Debug Mode for an Application
- 23.5.3 Running an Application in Debug Mode
- 23.5.4 Viewing Debug Reports in Development Mode
- 23.5.5 About Using f?p Syntax to Access Debug Mode
- 23.5.6 Viewing Debug Reports from a Running Application
- 23.5.7 Viewing Debug Reports
- 23.6 About Removing Controls and Components to Isolate a Problem
-
24
Deploying an Application
- 24.1 About Suggested Environments
- 24.2 System Development Life Cycle Methodologies to Consider
- 24.3 Understanding the Deployment Process
-
24.4
How to Create a Custom Application
- 24.4.1 How Creating a Custom Application Simplifies Deployment
- 24.4.2 Creating a Custom Application
- 24.4.3 Installing Supporting Objects
- 24.4.4 Deleting Supporting Objects Scripts, Messages, and Installation Options
- 24.4.5 Upgrading a Custom Application
- 24.4.6 Deinstalling Supporting Objects
- 24.4.7 Viewing an Install Summary
- 24.5 Using Build Options to Control Configuration
- 24.6 About Publishing the Database Application URL
- 24.7 About Publishing the Websheet Application URL
-
24.8
Exporting an Application and Application Components
- 24.8.1 About the Export Process
- 24.8.2 Splitting Export Files into Separate Scripts
- 24.8.3 About Exporting Static Files
- 24.8.4 Exporting a Workspace
- 24.8.5 Exporting an Application
- 24.8.6 Exporting an Application Page
- 24.8.7 Exporting Application Components
- 24.8.8 Exporting a Legacy Websheet
- 24.8.9 Exporting Themes
- 24.8.10 Exporting Plug-ins
- 24.8.11 Exporting User Interface Defaults
- 24.8.12 Exporting Team Development Feedback
- 24.8.13 Exporting Script Files from the Script Repository
- 24.9 Importing Export Files
- 24.10 Installing Export Files
- 24.11 Understanding One-click Remote Application Deployment
-
25
Managing Application Legacy Components
- 25.1 Viewing Legacy Components in the Gallery
- 25.2 Managing Legacy Calendars
-
25.3
Managing Legacy Charts
- 25.3.1 About Chart Legacy Types
-
25.3.2
Creating SQL Queries for Legacy Charts
- 25.3.2.1 Legacy Chart Syntax
- 25.3.2.2 Dial Chart Syntax (Flash and HTML5)
- 25.3.2.3 Legacy Multiple Series Syntax (Flash and HTML5)
- 25.3.2.4 Legacy Range Chart Syntax (Flash and HTML5)
- 25.3.2.5 Legacy Scatter Chart Syntax (Flash and HTML5)
- 25.3.2.6 Legacy Candlestick Chart Syntax (Flash and HTML5)
- 25.3.2.7 Legacy Gantt Chart Syntax (Flash Only)
- 25.3.3 Adding a Legacy Chart to a New Page
- 25.3.4 Adding a Legacy Chart in Page Designer
- 25.3.5 Editing Legacy Charts
- 25.3.6 About Saving Flash Charts
- 25.3.7 Using Custom XML with Flash and HTML5 Charts
- 25.4 Creating Legacy Maps
- 25.5 Managing Legacy Map Charts
- 25.6 Creating a Legacy Master Detail Form
- 25.7 Managing Legacy Tabular Forms
-
25.8
Managing Legacy Web Services
- 25.8.1 About Web Services
- 25.8.2 Creating Web Service References
- 25.8.3 About Working with SSL Enabled Web Services
- 25.8.4 Creating Web Service References Based on a WSDL
- 25.8.5 Creating Web Service References Manually
- 25.8.6 Creating RESTful Web Service References
- 25.8.7 Using the Web Service Reference Repository
- 25.8.8 Creating an Input Form and Report on a Web Service
- 25.8.9 Creating a Form on a Web Service
- 25.8.10 Creating a Report on a Web Service
- 25.8.11 How to Invoke a Web Service as a Process
- 25.8.12 Viewing a Web Service Reference History
-
25.9
Managing Legacy Websheet Applications
- 25.9.1 About Legacy Websheet Applications
- 25.9.2 Running a Legacy Websheet
- 25.9.3 Creating a Legacy Websheet Application
- 25.9.4 Copying a Legacy Websheet Page
- 25.9.5 Editing Legacy Websheet Details
- 25.9.6 Understanding Legacy Websheet Properties
- 25.9.7 Deleting a Legacy Websheet Application
- 25.9.8 Viewing the Legacy Websheet Dashboard
- 25.9.9 Monitoring Legacy Websheet Activity
- 25.9.10 Controlling Legacy Websheet Access
- A About Item Types
- B Oracle Application Express Limits
- C Directory Structure When Splitting Export Files into Separate Scripts
- D Available Conditions
- E About Granted Privileges
- Index