List of Figures
- 1-1 App Builder Landing Page for a DEMOAPEX Workspace on apex.oracle.com
- 1-2 Examples of APEX Apps on Mobile and Desktop
- 1-3 Using AI Coding Agent in VS Code to Fix Problem Highlighted in APEXlang File
- 1-4 Generating Scaffolded App with AI Produced Blueprints to Converge Requirements
- 1-5 APEX Community Discussion Forum, Built Using APEX
- 1-6 APEX World Community Site for News, Component Exchange, and More
- 1-7 Statistics for Large Internal APEX Instance
- 1-8 Browsing Other Learning Resources
- 2-1 Maintaining Database Objects in Object Browser
- 2-2 Two Tables with Primary Keys and Foreign Key
- 2-3 Experimenting with SQL in SQL Commands
- 2-4 APEX Assistant Helps Write SQL
- 2-5 Choosing Sample Data as a Data Source in the Create Page Wizard
- 2-6 Changing the Type of Sample Data in Page Designer
- 2-7 Loading an Excel Spreadsheet into a New Table in Data Workshop
- 2-8 Iteratively Designing a New Data Model with Quick SQL
- 2-9 Explaining the Data Model to APEX Assistant
- 2-10 Reviewing the Quick SQL Data Model Diagram
- 3-1 App Builder's Home Page Lists All the Applications in Your Workspace
- 3-2 Creating a New Application from the App Builder Home Page
- 3-3 Create an App by Assigning a Name, or Use a Wizard for More Options
- 3-4 Application Landing Page Shows a List of Pages the App Contains
- 3-5 Toggle Between a List and Icon View of Your Application's Pages
- 3-6 Create Page Wizard
- 3-7 Rendering, Dynamic Actions, Processing, and Page Shared Components Tabs
- 3-8 Using Property Editor with Rendering and Layout Tabs
- 3-9 Working with Properties of Multiple Selected Components
- 3-10 Searching the Property Editor to Find a Setting
- 3-11 Pinning a Property Editor Search to Work on Multiple Components
- 3-12 Define Triggered Actions on Buttons and Menus in the Rendering Tab
- 3-13 Dynamic Action Tabs Shows Event Handlers and Actions
- 3-14 Processing Tab Shows Page Submit Validation and Processing
- 3-15 Find and Navigate to Anything Anywhere on Your Page
- 3-16 Help Tab Shows Detailed Information About Selected Setting
- 3-17 Blank Page with Slots Based on Page Template
- 3-18 Region Palette in Page Designer
- 3-19 Dragging and Dropping Regions from the Palette into Page Slots
- 3-20 Search Page for Patients in APEX Page Designer
- 3-21 Page Items Palette in Page Designer
- 3-22 Adding a Sort By Item and Search Facets in APEX Page Designer
- 3-23 Running Patients Search Page to See Map Not Refreshing Yet
- 3-24 Dynamic Actions Add Interactive Behavior
- 3-25 Map Reflects Filtered Result and Auto-Centers and Zooms
- 3-26 Customizing the Theme Style with Theme Roller
- 3-27 Universal Theme Components Reference
- 3-28 Calendar Reference
- 3-29 Map Region Reference in "Vita Dark" Theme Style
- 3-30 Browser Display of Simple HTML and CSS Example
- 3-31 Columns of an Interactive Report Region in Page Designer
- 3-32 Synchronizing Columns After Altering a Region's Data Source
- 3-33 Commenting Out a Report Region Column
- 3-34 Form Region Page Items
- 3-35 Form Region Source and Region Layout Properties
- 3-36 Flexible Layout of Form Region Page Items at Runtime
- 3-37 Single Selection List Items
- 3-38 Single- or Multi-Selection List Items
- 3-39 Multi-Selection List Items
- 3-40 Text with Autocomplete Page Item
- 3-41 Query by Example Select One Page Item with Null Display Value
- 3-42 Defining a List of Values with Static Values
- 3-43 Converting Locally-Defined List of Values to Shared
- 3-44 Department Page Item as Cascading Parent Item for Employees List
- 3-45 Dividing Horizontal Space Evenly Using a 12 Column Grid
- 3-46 Automatic Column Spanning Using Only "Start New Row"
- 3-47 Component Tree Dictates Layout Order
- 3-48 Automatic Column Spanning at Runtime
- 3-49 Manually Specifying Column Span
- 3-50 Effect of Manually Specifying Column Spanning at Runtime
- 3-51 Layout Responds Automatically to Narrower Screen
- 3-52 Registration Page on a Mobile Device with Even Narrower Screen
- 3-53 The Same Grid of Columns and Rows Operates at Page Level
- 3-54 Disabling "Start New Row" for Map Region
- 3-55 Disabling "Start New Row" for Map Region
- 3-56 Universal Theme Page Templates
- 3-57 Standard Region Template Options in the Universal Theme Reference App
- 3-58 Three Query by Example Page Items Using Optional Item Template
- 3-59 Same Page Using Optional - Above Item Template
- 3-60 Items With Floating Item Template Stretch to Fill Column Span
- 3-61 Department's Required Item Template Displays Visual Marker and Inline Text
- 3-62 Regions Can Contain Other Regions and Items
- 3-63 Responsive APEX Web Page With Nested Regions
- 3-64 Tapping to Install an APEX as a Native App on iPhone
- 3-65 Full Screen iPhone App Experience with APEX Progressive Web App
- 3-66 APEX To Go Mobile Sample App on iPhone
- 4-1 Using
{loop/}Directive to Format Tags as Chips - 4-2 Template Directives in Universal Theme Reference App as PWA
- 4-3 Help Tab Provides Content-Sensitive Assistance
- 4-4 Numeric Range Using Two Number Field Page Items
- 4-5 Expected Validation Error Treating Numeric Items as Numbers
- 4-6 Date Range Using Two Date Picker Page Items
- 4-7 Expected Validation Error Treating Date Items as Dates
- 5-1 Classic Report Region Showing Employees Data with Pagination
- 5-2 Filtered, Highlighted, Grouped Employees with Computed and Aggregate Fields
- 5-3 Content Row Region with Pagination and Action Menu Entries
- 5-4 Content Row Configured for Multiple Row Selection
- 5-5 Employees Shown in a Cards Region
- 5-6 Cards with Media and an Action Button Configured
- 5-7 Native Chart Types to Choose From for a Chart Region
- 5-8 Sum of Employees Salaries and Commissions by Department
- 5-9 Stacked Bar Chart in Page Designer
- 5-10 Stacked Bar Chart Now Showing Joined Department Names
- 5-11 Five Different Types of Map Layer in the Create Page Wizard
- 5-12 Maps Showing Employees Addresses
- 5-13 Point Layer and Heat Map Layer on a Map
- 5-14 Showing the Office and Employees Distance Away
- 5-15 EMP_MEETINGS Table Records for EMP to EMP Scheduled Events
- 5-16 Four Meetings in Employee KING's Schedule with Dynamic Action on Select List
- 5-17 Configuring Create Link to Pass Start and End Date
- 5-18 Events Showing Purpose and Meeting With Employee Name
- 5-19 Employee KING's Week of Meetings
- 5-20 Minimal Settings for a Working Tree Region
- 5-21 Basic Tree Region Showing EMP Management Hierarchy
- 5-22 Configuring Dynamic Action Step to Set Selected Node Id Into Hidden Page Item
- 5-23 Employee Hierarchy with Icons Based on Job
- 5-24 Exploring Parent/Child Data in a Tree
- 5-25 VT220-Style Chart of Employee Salaries Using Dynamic Content Region
- 5-26 Dynamic Content Region Using a Page Item Value
- 6-1 Faceted Search in the Left Column Filtering Classic Report in the Body
- 6-2 Search Facets in Page Designer
- 6-3 Specifying Range Facet Interval Low and High Values
- 6-4 Results Include Rows Matching Any Choice in Multi-Select Facets
- 6-5 Comparing Facet Value Distribution with Pie or Bar Chart
- 6-6 Applying Filters from the Add Filter Dialog
- 6-7 Finding Text Across Columns with the Search Facet
- 6-8 Row Count and Filter "Chips" Over Classic Report
- 6-9 Compact Smart Filters Region is a Single Search Field
- 6-10 Defining Multiple Filters in Page Designer
- 6-11 Filter Display Names and Icons Appear in Search Dropdown
- 6-12 Selecting One or More Options from a Filter
- 6-13 One Filter Used, Other Filters Remain Available
- 6-14 Applying Multiple Filters Using a Smart Filters Region
- 6-15 Typing Text to Search Across Columns or Find Filters
- 6-16 Suggestion Chips For Initial Filter to Apply
- 6-17 Smart Filters Region in the Navigation Bar
- 6-18 Mapping Search Configuration Columns to Standard Slots
- 6-19 Defining a Search Configuration's Link Target Page
- 6-20 Configuring a Search Region with Search Configurations
- 6-21 Finding and Drilling Down on Search Results
- 6-22 Consulting Help Tab for Search Region Result Row Template
- 6-23 Consulting Help Tab for Search Region Result Row Template
- 6-24 Show Smart Filtered Cards Region Data in Chart and Map
- 6-25 Custom Label Representing the Null Value in a Select List
- 6-26 Warn on Unsaved Changes for Query by Example Confuses Users
- 7-1 Reusing a Template Component Three Different Ways
- 7-2 Custom Attributes in the Settings Section
- 7-3 Configuring Slot Behavior in a Template Component
- 7-4 Using a Template Component's Slots in Page Designer
- 7-5 Template Component Positions and Styles Composed Buttons and Regions
- 7-6 Different Usage of Content with Action Buttons Template Component
- 7-7 Templates Involved to Format a Multiple (Report) Component
- 7-8 Report Group Attributes in the Property Editor
- 7-9 Template Component Without and With Grouped Data
- 7-10 Normal and Grouped Data with Pagination
- 7-11 Row Selection Settings on Template Component Available as Multiple (Report)
- 7-12 Single & Multiple Selection Showing Entity Title
- 7-13 Processing Zero, One, and Multiple Selected Rows
- 7-14 Attributes of Different Scopes in Grouped Name/Value Pairs Component
- 7-15 Defining Menu and Submenu Options in an Action Position
- 7-16 End User Choosing a Template Component Row Action
- 7-17 Files List for a Template Component
- 7-18 Additional EMP Tables Tracking Training Course Progress
- 7-19 Employee Training Status Using Interactive Report
- 7-20 Kanban Board Mockup Showing Employee Training Status
- 7-21 Kanban Board Plug-in on apex.world
- 7-22 Importing a Plug-in Into Your Application
- 7-23 Defining Kanban Board Status Columns and Icons
- 7-24 Configuring the Kanban Region's SQL Query
- 7-25 Kanban Board Region Plug-in Shows Employee Training Status
- 8-1 Navigation Menu Lets Users Initiate Business Functionality
- 8-2 Navigation Bar List for Application Options and Logout
- 8-3 Three Step Wizard for Onboarding an Employee
- 8-4 Wizard Container on Each Page Shows Steps in a Flow
- 8-5 Defining the Wizard Steps in the Create Wizard Dialog
- 8-6 Wizard List Region Shows List of Pages as "Train" Stops
- 8-7 List Shared Component Defining Wizard Step Pages and Titles
- 8-8 Branches Connect Three Pages in Onboard New Employee Flow
- 8-9 Page Renders to Browser, then User Submits Page for Processing
- 8-10 Execute Code Page Process to Insert New Employee
- 8-11 Configuring Invoke API Process to Call Package Business Logic
- 8-12 Configuring Parameter Values for Invoke API
- 8-13 AJAX Requests and Redirects Complement Render, Submit, and Branch
- 8-14 Data Model for Employees Having One or More Dependents
- 8-15 Four-Level Drill Down Page Flow for Employees and Dependents
- 8-16 Editing Breadcrumbs Shared Component to Reflect Navigation Hierarchy
- 8-17 Manage Employees Page Redirects to Employee Form Page for Edit
- 8-18 Drilling Down on Employee to See Their Dependents
- 8-19 Viewing Employee SMITH's Dependents and Drilling Down Again
- 8-20 Viewing SMITH's Dependent Janie: Breadcrumb Shows Path "Home"
- 8-21 Modal Dialog Form Page Called from a List Page
- 8-22 Modal Drawer Slides Out from the Start or End of the Window
- 8-23 Automatic Session State Management
- 8-24 Clearing Session State in Link Target Settings
- 8-25 Clear Cache Setting in Button Target Dialog
- 8-26 Using Clear Session State Page Process
- 8-27 App Computation Sets the Value of App Item After Authentication
- 8-28 Browsing Page Item Session State for Page 44
- 8-29 Browsing Application Items and Other Kinds of Session State
- 8-30 Create Page Wizard Choices for List and Edit Pages on the EMP Table
- 8-31 Configuring Breadcrumb, Navigation Menu Entry, and Icon
- 8-32 Navigation Menu Entry for Newly Created List Page
- 8-33 New Interactive Report Page Showing Employees
- 8-34 Interactive Report and Form Modal Drawer Pages in Action
- 8-35 Examining Wizard-Configured Link Column Settings
- 8-36 Form Initialization Page Process Retrieves Row by Primary Key
- 8-37 Form Region Using EMP Table as Data Source
- 8-38 Form Initialization Page Process Requires a Primary Key
- 8-39 All Form Region Page Items Use "Memory Only" Storage
- 8-40 List Page's (Create) Button Passes No Parameters to Edit Page
- 8-41 Declarative Form DML Handling with Native Page Process
- 8-42 Wizard-Created Form Page Delete Button
- 8-43 Wizard-Created Modal Form Page Cancel Button
- 8-44 Wizard-configured Close Dialog Page Process
- 8-45 Dynamic Action Event Handler for the Close Dialog Event
- 8-46 Dynamic Action Step to Refresh the Interactive Report
- 9-1 User Can Insert, Update, and Delete Multiple Rows Then Save All the Changes
- 9-2 Grid Offers Scrolling Pagination with Fetch on Demand
- 9-3 Date Picker is One of Many Item Types Available for Grid Column Editing
- 9-4 Grid Columns Can Use List-Driven Items for Data Entry
- 9-5 Actions Menu Presents the Grid Features You Enable for Users
- 9-6 Scrolling Through Large Dataset, Interactive Grid Fetches More Data On Demand
- 9-7 Updating a Grid Cell Using a Popup LOV
- 9-8 SVG
viewBoxArea Used by Percent Dot on Bar Template Component Graphics - 9-9 Visualizing Salaries as a Dot on a Bar Using a Template Component
- 9-10 Editing Shopping Cart Items in a Collection with Interactive Grid
- 9-11 Configuring Custom Grid PL/SQL to Save Cart Data to Collection
- 9-12 Custom When No Rows Found Message Improves Usability
- 9-13 Calling Helper Function to Refresh Grid Row on Dialog Close
- 9-14 Storing Primary Key Being Edited in a Hidden Item with a Computation
- 9-15 Configuring Item Values to Return to Calling Page on Dialog Close
- 9-16 Clearing the Edited Primary Key on Delete
- 10-1 Create Page Wizard Offers Three Master/Detail Patterns
- 10-2 Edit Multiple Master Rows and Respective Detail Rows, Then Save
- 10-3 Enter New Master Row with New Detail Rows as Part of Other Changes
- 10-4 Configuring the Master Region of a Detail Grid
- 10-5 Master Column
- 10-6 Side by Side Master/Detail Lets Users Search and See Details for Master Rows
- 10-7 Breakdown of Side by Side Page Template Slots and Regions in Them
- 10-8 Configuring an Alternative Classic Report Template
- 10-9 Find Media List Report Template
- 10-10 Study Row Template Substitutions
- 10-11 Configuring Value Attribute Pairs Classic Report Template
- 10-12 Editing the Selected Master Row in a Modal Drawer
- 10-13 Creating a New Detail Row for the Currently Selected Master
- 10-14 Master Detail in IR
- 10-15 Master/Detail Edit Page Lets User Maintain Master and Details Together
- 10-16 Editing Master and Detail Before Saving or Navigating Previous or Next
- 10-17 Defaulting Employee Department Foreign Key to Current Department Value
- 10-18 Configuring Form Navigation Items on Initialization Page Process
- 10-19 Execute Code Process with Editable Region Set Runs Once per Modified Grid Row
- 10-20 Creating a New Master Row and Multiple New Details at Once
- 11-1 Deliver User Experience Tailored to Each User's Functional Role
- 11-2 Deciding if a Page is Public or Requires Authentication
- 11-3 Oracle APEX Accounts Provide Default Authentication Scheme
- 11-4 Workspace Administrators Manage APEX User Accounts
- 11-5 Workspace Administrators Manage Users from Accounts List Page
- 11-6 Configuring Roles and Role Assignments
- 11-7 Configuring Authorization Scheme Rules Using Role Membership
- 11-8 Detail of Authorization Scheme Rule Based on Role Membership
- 11-9 Applying Authorization Scheme to Navigation Menu Entries
- 11-10 Applying Authorization Scheme to a Page
- 11-11 Non HR Representatives See Error Navigating to Unauthorized Page
- 11-12 Applying Authorization Scheme to Columns
- 11-13 Applying Authorization Scheme to a Button
- 11-14 Applying Authorization Scheme to an Edit Link Column
- 11-15 End Users Experience and Features Adjust Automatically to their Role
- 11-16 Regular Employees Don't See Certain Columns, Create Button, or Edit Link
- 11-17 HR Representatives See Pay Columns, Create Button, and Edit Link
- 11-18 Only HR Representatives Can Use Salary Review Page
- 11-19 Two Additional Authorization Schemes Using PL/SQL and SQL
- 11-20 Using SQL to Define Authorization Scheme Rule for Managers
- 11-21 Using PL/SQL Expression to Combine Other Authorization Schemes
- 11-22 Change Salary Review to Use View with Data Security Policy
- 11-23 Make Sal and Comm Columns Read Only Unless User is HR Representative
- 11-24 Adjust Authorization Scheme to Let Managers and HR Reps Access
- 11-25 Adjust Menu Entry Authorization Scheme for Managers and HR Reps
- 11-26 Now Managers Like Jones See the Salary Review Page
- 11-27 Data Security Ensures Jones Sees Only Own Staff Members
- 11-28 Domain Users in Identity Cloud Service
- 11-29 Domain Groups in Identity Cloud Service
- 11-30 Domain Group Assignments in Identity Cloud Service
- 11-31 Domain Integrated App for Use by Woods HR APEX Application
- 11-32 Configuring Domain Integrated App OAuth Client
- 11-33 Web Credential for Use with IDCS Social Sign-in Authentication
- 11-34 Configuring Social Sign-in Authentication Scheme for IDCS
- 11-35 Configuring Post-Authentication Procedure to Enable Groups
- 11-36 Changing App to Source Groups from Custom Code
- 11-37 Changing Authorization Schemes to Use Custom Type for Dynamic Groups
- 11-38 Making Social Sign-in Authentication Scheme the Current One
- 11-39 Users Now Login to Woods HR Using OCI IAM Sign In
- 12-1 Typing a Request in Natural Language into the Interactive Report Search Field
- 12-2 Applied Report Features Appear as Chips, and Assistant Button Opens Chat Area
- 12-3 User Can Refine Results By Continuing the Conversation in the Chat Area
- 12-4 Interactive Report Features Like Highlighting Get Configured Using Natural Language
- 12-5 Charting and Pivoting Data Are Also Available Just by Asking
- 12-6 Hide or Show Columns and Add Break Groups with a Prompt
- 12-7 Context You Add Helps Assistant Turn "the 80s" and "won an Oscar" into Filters
- 12-8 The Assistant Prompts the User for Clarification When Necessary
- 12-9 Report Context Helps Search with AI Assistant Better Understand User Requests
- 12-10 Column Context
- 12-11 Defining a Retrieve Data On-Demand Tool with Optional Parameters
- 12-12 Writing the SQL Query to Implement a Retrieve Data Tool
- 12-13 Defining an Execute Server-side Code On-Demand Tool with Required Parameters
- 12-14 Writing the PL/SQL Code to Implement an Execute Server-side Code Tool
- 12-15 Using the HR Assistant AI Agent in an AI Assistant Chatbot
- 12-16 Once
get_employee_infoReturnsEMPNO, Assistant Completes Task Directly - 12-17 Lifecycle of a Request Involving an AI Agent
- 12-18 Showing an AI Assistant Dialog Using a Trigger Action on a Button
- 12-19 Entering Patient Discharge Instructions
- 12-20 Preparing Discharge Letter Using AI Agent
- 12-21 Activities Standard Search Configuration on Activities Table Columns
- 12-22 Lucy's Choice of Words Produces No Matching Activities
- 12-23 Adding a VECTOR Column to an Existing Table in Object Browser
- 12-24 Creating a Vector Provider Based on a Database-Resident ONNX Model
- 12-25 Defining a Vector Search Type Search Configuration on the Activities Table
- 12-26 Configuring a Search Region to Use a Vector-Aware Search Configuration
- 12-27 Lucy Now Finds Meaningful Results, Even When Words Differ
- 12-28 Trying Another Search, Temporarily Studying Vector Distance of Results
- 12-29 Applying Best Score Proximity Cutoff to Search Configuration Results in a Content Row
- 12-30 Lucy Now Sees Only the Most Relevant Results
- 12-31 Searching by Meaning, Lucy Finds Exactly What She's Looking For
- 12-32 Multiple Activities Land Inside the Best Score Proximity Cutoff
- 13-1 Referencing a REST-Enabled SQL Service in Workspace Utilities
- 13-2 Providing Credentials for REST-Enabled SQL Service
- 13-3 Confirmation of Successfully Authenticated REST-Enabled SQL Connection
- 13-4 Using a Table in a Remote Database with REST-Enabled SQL
- 13-5 Defining a New REST Data Source Using Its Endpoint URL
- 13-6 Service Endpoint URL Base URL Comes from Remote Server Definition
- 13-7 Preview of Data Rows Returned from REST Data Source
- 13-8 Inspecting REST API Response: items Array and Nested links Array
- 13-9 Data Profile Columns Discovered Automatically by the Wizard
- 13-10 Adjusting the HIREDATE Data Profile Column's Data Type
- 13-11 Configuring a REST Data Source's Pagination Strategy
- 13-12 Interactive Report Using a REST Data Source
- 13-13 Paging Through REST Data 5 Rows at a Time in an Interactive Report
- 13-14 Fetch Rows GET Operation for Discovered Simple HTTP REST Data Source
- 13-15 Complete Set of Operations to Support All Database Actions
- 13-16 Fetch Single Row Operation to Retrieve a Single Row by Primary Key
- 13-17 Ensuring the Primary Key Column is Enabled
- 13-18 Request Body Template in the PUT / Update Row Operation
- 13-19 Calling a REST Data Source Operation with Invoke API Page Process
- 13-20 Configuring REST Data Source Parameter Using a Page Item
- 13-21 Configuring Invoke API Page Process Parameters
- 13-22 REST Data Source with an Operation Used by Invoke API
- 13-23 REST Data Source Operation for Invoke API
- 13-24 Fetch Rows GET Operation to Retrieve One Employee by PK
- 13-25 Data Profile for Employee by PK (Simple HTTP) REST Data Source
- 13-26 Data Profile for Single Book Create REST API Response Payload
- 13-27 Data Profile Column Configuration for Estimated Delivery Date
- 13-28 POST Operation for Single Book Create REST API
- 13-29 Resulting REST Data Source for Simple Book Order
- 13-30 Interactive Report Based on Fusion Apps Sales Opportunities REST Data Source
- 13-31 Enable Debug Tracing to Diagnose HTTP 400 Error from REST Data Source
- 13-32 Identifying Most Recent Debug Trace and Drilling Down for Details
- 13-33 Quickly Navigating to an Error on the Debug Trace Timeline
- 13-34 Examining First Error and the Preceding REST API Call
- 13-35 Disabling Sorting on Assignment Mode Column
- 13-36 Problem Fixed: Users Can No Longer Choose the Non-Sortable Column
- 14-1 Application Page for Editing an Action Item and Assigned Team Members
- 14-2 Simple Schema for Action Items and Team Members Assigned to Them
- 14-3 Open Source Ticketing System Needs to Integrate with Your Action Item App
- 14-4 ORDS "v0" Module with Templates and Handlers for Action Items API
- 14-5 Opening SQL Developer Web from the App Builder
- 14-6 Navigating to View and Define REST Services in SQL Developer Web
- 14-7 Navigating to View and Define REST Modules in SQL Developer Web
- 14-8 Navigating to View and Configure a Module's Templates in SQL Developer Web
- 14-9 Navigating to View and Configure a Template's Handlers in SQL Developer Web
- 14-10 Listing Handlers for a Template in SQL Developer Web
- 14-11 Defining a Collection Query GET Handler for /v0/actionitems Template
- 14-12 Testing ORDS GET Handler on the Command Line with curl
- 14-13 Formatting Output of curl Using jq Command Line Utility
- 14-14 Using Postman to Access Your New Action Items REST API
- 14-15 Defining an Collection Item GET Handler for /v0/actionitems/:id Template
- 14-16 Shared Component Text Messages Define Translatable Error Messages
- 14-17 Editing an Action Item and Assigned Team Members in a Page
- 14-18 Working with Action Items and Team Members Using Postman
- 14-19 ORDS "v1" Module with Templates and Handlers for Action Items API
- 14-20 An ORDS Template Handler Can Use PL/SQL for Complete Control
- 14-21 Defining a Custom Parameter for an ORDS Handler
- 14-22 Each ORDS Handler Call an ACTION_ITEMS_API_REST Procedure
- 14-23 Layered Package Design for Sharing Business Logic with a Page
- 14-24 Leo Updates the Title of the New Action Item
- 14-25 AutoREST-Enabling the ACTION_ITEMS_DV Duality View in SQL Developer Web
- 14-26 Configuring Object Alias for AutoREST-Enabled Duality View
- 14-27 Browsing AutoREST-Enabled Objects in SQL Developer Web
- 14-28 ORDS "v2" Module for Action Items API Using JSON Relational Duality View
- 14-29 Each ORDS Handler Call an ACTION_ITEMS_API_REST Procedure
- 14-30 Layered Package Design for Sharing Business Logic with a Page
- 14-31 Defining a Privilege in SQL Developer Web REST Designer
- 14-32 Granting the Action Items Privilege to External Application Integration Role
- 14-33 Store Client Secret Securely, then Share Securely with External App Team
- 14-34 ORDS OAuth Client Used to Authenticate External System Integration
- 15-1 Configuring Geocoded Address Page Item
- 15-2 Viewing KING's Existing Address in a Map Tooltip
- 15-3 Geocoded Address Displays Existing Address On Page Load
- 15-4 User Confirms Correct Address
- 15-5 Geocoded Address Map Updates to Show New Address
- 15-6 Extracting Longitude and Latitude from Geocoded Address
- 15-7 Disabling Value Protected on Hidden Item Set by Dynamic Actions
- 15-8 Clicking Refreshes on Return from Dialog to Show KING's Updated Address
- 15-9 Linking to Another Page from a Map Point
- 15-10 Map Refreshes on Return from Dialog to Show KING's Updated Address
- 15-11 Configuring a Dialog Close Dynamic Action Event Handler
- 15-12 Subtracting Height of Fixed Page Elements from Viewport Height
- 15-13 Determining the Element or Class to Target with a CSS Rule
- 15-14 Adding Inline CSS Rule to a Page
- 15-15 Vertical Stretch in Action on a Map Region in a Normal Page
- 15-16 Relative CSS rem Unit Works Correctly at Any Zoom Percent
- 15-17 Vertical Stretching May Need to Account for Fixed Content Above and Below
- 15-18 Vertical Stretch in Action in a Model Drawer for a Geocoded Address Map
- 15-19 Adding CSS-Hidden Field to Stop Enter Key from Submitting Page
- 15-20 Triggering Address Geocoding Using the Enter Key
- 15-21 Showing ENAME in Modal Dialog Provides Useful Context
- 15-22 First Unsuccessful Attempt to Include Context Info in Dialog Title
- 15-23 The &P60_ENAME. in Dialog Title Comes Up Empty
- 15-24 List Page Shows Reference Path for a Static Application Files
- 15-25 Including Static App File Reference in Application JavaScript File URLs
- 15-26 Configuring a Translatable Text Message for Use in JavaScript
- 15-27 Configuring Match Mode for Server-side Geocoding
- 16-1 Break Room and Open Positions Referrals Pages in Woods HR App
- 16-2 Break Room Page Lets Employees Share Photos with Colleagues
- 16-3 Employees Submit Candidate CVs for Open Job Positions
- 16-4 Additional Tables to Support Woods HR Photos and CVs
- 16-5 Views Present Two "Interfaces" on Breakroom Photos Table
- 16-6 Shared Component Application Items List
- 16-7 Computing an Application Item's Value After Login
- 16-8 Using an Application Item to Default the Posting Employee ID
- 16-9 Configuring Source Properties for an Upload Image Item
- 16-10 Configuring Form DML Page Process
- 16-11 Configuring Properties That Control Image Upload Behavior
- 16-12 Defining a CSS Stylesheet in Static Application Files
- 16-13 Including a CSS Style Sheet in Every Page of Your App
- 16-14 Upload Image Page Item with Custom Preview Icon Size
- 16-15 User Sees Large Image Preview Before Clicking Upload
- 16-16 Cards Page Refreshes on Dialog Close to Show Latest Photo
- 16-17 Configuring Card Media Attributes to Display BLOB Column Image
- 16-18 Configuring Card Item Media from a CLOB Image Column
- 16-19 Configuring Display Image Form Page Item for Image BLOB
- 16-20 Previewing an Image from a BLOB Column in a Form Region
- 16-21 Configuring Display Image BLOB Column in Classic Report
- 16-22 Custom-Sized Images in a Classic Report
- 16-23 Configuring BLOB Image Column in an Interactive Report
- 16-24 BLOB Images in an Interactive Report
- 16-25 Configuring BLOB Image in a Content Row
- 16-26 Content Row with BLOB Image in the Avatar Image Slot
- 16-27 Setting Up Search Configuration to Use a BLOB Image Column
- 16-28 Including BLOB Column Image in Search Page Results
- 16-29 Configuring HTML IMAGE tag to Display Only
- 16-30 Displaying BLOB Image Using Image URL via GET_BLOB_FILE_SRC
- 16-31 Form Image Item GET_BLOB_FILE_SRC References for BLOB Metadata
- 16-32 Pre-Rendering Invoke API Process to Download an Image
- 16-33 Configuring Break Room Image ID Parameter Value
- 16-34 Inline BLOB Images in an Interactive Grid Using Image-Serving Page
- 16-35 Passing Checksum-Protected Hidden Page Item for Image ID
- 16-36 Default Page Access Protection Setting Requires Checksum for URL Arguments
- 16-37 End Users Notice No Changes Using Checksum-Protected Image URLs
- 16-38 Clever Users See Error When Manually Modifying an Image URL
- 16-39 Using Computed Image URL in a Static Content Image Template
- 16-40 Selecting an Open Job Card with Existing Referrals
- 16-41 Selecting an Open Job with No Referrals Yet
- 16-42 Full Card Action Sets Select Job Referral Count and ID
- 16-43 Using True or False Dynamic Action Steps to Adjust the User Experience
- 16-44 Triggered Action Generates Dialog URL Before Opening It Using JavaScript
- 16-45 Calling JavaScript Helper Function to Open Dialog
- 16-46 "Always" Source Defaulting the Drawer Model URL Template
- 16-47 Computation Defaulting the Drawer Model URL Template
- 16-48 Opening Modal Drawer Passing Dynamic Values in URL Template
- 16-49 Adjusting Page Access Protection to Unrestricted to Accept Dynamic Parameters
- 16-50 Adjusting Session State Protection to Unrestricted to Accept Dynamic Parameters
- 16-51 Configuring File Upload Page Item
- 16-52 Ensure Automatic DML Page Process Targets the Form
- 16-53 Ensure Automatic DML Page Process Targets the Form
- 16-54 Database Action on Submitting Button Informs Automatic DML Process
- 16-55 Configuring File Upload Page Item Display Behavior
- 16-56 Submitting a New Job Referral Candidate's CV
- 16-57 Uploading a File to a BLOB Column
- 16-58 Previewing Newly Uploaded Job Referral Candidate's CV
- 16-59 Simple Template Component to More Easily View PDFs Inline
- 16-60 Pre-Rendering Invoke API Process to Download a PDF
- 16-61 Configuring Break Room Referral ID Parameter Value
- 16-62 Sourcing the PDF_URL in the Region's Query
- 16-63 Configuring PDF URL
- 16-64 Candidate Picker Select List Refreshes PDF Viewer Template Component
- 16-65 Encountering an Error Due to "Embed in Frames" = Deny
- 16-66 Allowing Embedded Frame Only from the Same Domain
- 16-67 Downloading a Single File with the Native Dynamic Action
- 16-68 Downloading Multiple Files in a ZIP Archive with the Native Dynamic Action
- 16-69 Add Break Room Photos Page with Multiple Files Image Upload
- 16-70 Preview of Multiple Images Ready to Upload
- 16-71 Entering Titles for Multiple Posted Photos with Validation
- 16-72 Both New Photos with Titles Show Up Immediately in Break Room Photo Gallery
- 16-73 View Adds Titles to Temp Files by Joining with UPLOADED_PHOTOS Collection
- 16-74 Using an Execution Chain to Group Conditional Logic
- 16-75 Calling Page Button Target Link Sets P17_CLEAR = Y to Clear Collection
- 16-76 Invoke API Child Process Calls Procedure to Clear the Collection
- 16-77 Upload Button Triggers Invoke API to Add Image Names to Collection
- 16-78 Conditional Close Dialog Leaves User on Page After Image Upload to Set Titles
- 16-79 Collection Rows Determine if Image Upload or Titles Grid Displays
- 16-80 Image Preview Grid Allows Update and Delete, with No Toolbar
- 16-81 Saving Grid Edits Into Collection Using PL/SQL Code Target Type
- 16-82 Invoke API Calls Package Procedure to Save Temporary Photos
- 16-83 When Done Processing Temporary Images, Clear the Collection
- 16-84 Object Bucket Has a Namespace Used in REST APIs
- 16-85 Defining OCI Native Authentication Web Credential
- 16-86 Defining Object Buckets REST Data Source
- 16-87 Testing Object Buckets REST Data Source
- 16-88 Data Profile for Object Buckets REST Data Source
- 16-89 Defining Bucket Objects REST Data Source
- 16-90 Browsing and Selecting Bucket Files with a Content Row Region
- 16-91 Content Row Region Uses Bucket Objects REST Data Source
- 16-92 Configuring What Appears in Each Content Row Slot
- 16-93 Data Profile Columns for Bucket Objects REST Data Source
- 16-94 Use Application Definition Substitutions for Global Constants
- 16-95 Referencing Global Constants as Items
- 16-96 Configuring Avatar Image URL, Selection Behavior, and Pagination
- 16-97 Use a Private Object Bucket Unless It Stores Public Web Site Assets
- 16-98 Get File PAR Operation Has Base URL for Creating Pre-Authenticated Request
- 16-99 Strategy to Use PAR URLs to Serve Object Bucket Images Directly
- 17-1 External Data in an Excel Spreadsheet
- 17-2 Creating a Data Load Definition for an Excel Spreadsheet
- 17-3 Mapping Source Columns from External Data to Target Columns
- 17-4 Reviewing Data Load Definition Results By Previewing Data
- 17-5 Excel Spreadsheet Has Employee Names in Mixed Case
- 17-6 Renaming ENAME to ORIG_ENAME Data Profile Column
- 17-7 Adding a SQL Expression Data Profile Column for ENAME
- 17-8 Creating a Data Load Page for an Existing Data Load Definition
- 17-9 Data Loading Page File Drop Zone
- 17-10 Preview of Excel Spreadsheet Data to Load
- 17-11 Success Message Confirms Number of Rows Loaded
- 17-12 Loaded Employees as HR Rep Susan in Employee Directory
- 17-13 File Upload Item in Data Loading Page
- 17-14 Dynamic Action Immediately Submits File Upload
- 17-15 After Submit Computation Populates Uploaded File Name
- 17-16 Validating Allowed File Types on Submit
- 17-17 Selecting Worksheet to Load When Multiple Ones Exist
- 17-18 Previewing the Data to Load with APEX_DATA_PARSER.PARSE
- 17-19 Ensuring Preview Sorts by Line Number
- 17-20 Configuring Native Data Load Page Process
- 17-21 Creating a Data Load Definition for an Example JSON File
- 17-22 Configuring File Upload Item to Allow Multiple Files
- 17-23 Calling Custom Data Load File Processing with Invoke API Page Process
- 17-24 Computing a Custom Success Message with Conditional Text
- 17-25 Selecting Four Different Kinds of Files at Once for Employee Data Loading
- 17-26 Success Message Confirms Eight Employees Loaded from Four Files
- 18-1 Woods HR App's Employee Excellent Page for HR Reps
- 18-2 Viewing Progress of Longer-Running Award Review
- 18-3 Execution Chains Let You Organize Page Processing Logic into an Outline
- 18-4 Child Processes Execute in Sequence Order in an Execution Chain
- 18-5 Nest Execution Chains to Form an Outline
- 18-6 Sending Email with a Native Page Process
- 18-7 Setting Execution Chain to Run in the Background
- 18-8 Returning Function Result into Hidden Page Item
- 18-9 Checking Whether Candidate Employee Qualified for Excellence Award
- 18-10 Emailing Employee Excellence Award Certificate to Recipient
- 18-11 JONES Receives Her Employee Excellence Award Certificate
- 18-12 Sending Push Notification to Excellence Award Recipient
- 18-13 Serializing Background Process Job on Context Value
- 18-14 Background Process Error if Context Value Already Being Processed
- 18-15 Views Providing Progress of Background Processes
- 18-16 Displaying Progress Percentage as a Inline Bar Graph
- 18-17 Stretching Last Classic Report Column
- 18-18 Stretching Classic Report's Last Column Using CSS Class
- 18-19 Clamping Status Message Text to a Single Line
- 18-20 Ellipsis Displays when Text Length Exceeds Clamped Number of Lines
- 18-21 Enqueued Background Jobs Wait Their Turn to Execute
- 18-22 Inspecting Background Executions for the Current Session
- 18-23 Viewing Failed Background Execution Jobs
- 18-24 Identifying the Debug Trace Log for the Background Job
- 18-25 Jumping to First Error in the Debug Trace Timeline
- 18-26 Investigating Details of a Background Job in FAILED State
- 18-27 Drilling Down into an Active Session for a User
- 18-28 Reviewing Background Executions for Specific User Session
- 18-29 Viewing Session State for a Background Process Work Session
- 19-1 Martin Gets an Email That She's the Lucky Winner of a Raise
- 19-2 Saturday Employee Lottery Automation Source Query
- 19-3 Additional Code Execution Section Defines an Inline Initialization Procedure
- 19-4 Five Actions in the Saturday Employee Lottery Automation
- 19-5 Configuring Email Template and Placeholder Values for a Send E-Mail Action
- 19-6 Configuring the Automation Scheduler Expression with Interval Builder
- 19-7 Syntax for DBMS_SCHEDULER Calendar Expressions
- 19-8 Running an Automation from the List Page
- 19-9 Viewing the Automation Execution Log List
- 19-10 Inspecting Automation Execution Log Messages
- 20-1 Multiple Success Messages Get Concatenated
- 20-2 Messages Can Include HTML Markup
- 20-3 First Page Process Error Halts Processing and Displays Message
- 20-4 All Failed Validation Error Messages Display on Submit
- 20-5 Error Message Displays When Expression Evaluates to False
- 20-6 Validation Signals Failure by Returning the Error Text
- 20-7 Enabling Auto-Dismissal of Success Messages After Five Seconds
- 20-8 Dynamic Action Eagerly Calls CHECK_EMPNO Validation Function
- 20-9 Conditionally Displaying an Error Message if One Was Returned
- 20-10 Validation Performs Same Check on Page Submit
- 20-11 Eagerly Displaying a Page-Level Error Message Before User Submits
- 20-12 Aggregate SQL Checks Can Veto the Transaction Using ADD_ERROR
- 20-13 Showing Eager Field-Level Error Messages Before Submitting the Page
- 20-14 Clearing Field-Level Errors Before Checking Changed Employee ID
- 20-15 Validating the Employee ID on the Server
- 20-16 Conditionally Showing Error Message Returned by Server-side Check
- 20-17 Reusing the Same Recipe to Eagerly Validate Department ID
- 20-18 By Default, Users See Constraint Violation Error Name
- 20-19 By Default, Users See Internal Errors
- 20-20 Configuring a Page's Error Handling Function
- 20-21 Error Handling Function Shows Custom Error for Constraint Violation
- 20-22 Error Handling Function Shows Simplified Database Exception Message
- 20-23 Error Handling Functions Show Custom Message for Uncommon Internal Error
- 20-24 Error Handling Function Logged Uncommon Internal Error for Review
- 20-25 Viewing Logged Error Details for Uncommon Internal Error
- 20-26 Sending Email with a Native Page Process Without a Template
- 20-27 Template Has Static ID for API Use and Can Use Template Directives
- 20-28 Defining an Email Template with Placeholders
- 20-29 Configuring Email Template and Placeholder Values for Send-Email Action
- 20-30 Enabling Push Notifications in Your Application
- 20-31 Generating Key Pair Credential for Signing Push Notifications
- 20-32 Adding Push Notification Settings Pages to Your App
- 20-33 Lucy Uses App's Settings to Opt-In to Notifications
- 20-34 Users Send Push Notification with Random Laughable Line
- 20-35 Delivering a Push Notification with Native Page Process
- 20-36 Lucy Receives the Notification and Laughs
- 21-1 Configuring App to Use Instance Settings for Remote Printing
- 21-2 Glimpse of the Oracle Document Generator Instance Settings
- 21-3 Using Microsoft Excel to Create Report Layout
- 21-4 Defining Report Layout for Excel Document Template
- 21-5 Configuring Report Query Data for Tenure Report
- 21-6 Configuring Report Source Data Loop to Match Layout Tags
- 21-7 Using CSS Class to Vertically Center Button with Page Items in the Same Row
- 21-8 Setting Application Item to Selected Department Number
- 21-9 Printing Tenure Report Using Report Query
- 21-10 HR Rep Susan Prints Tenure Report for Research Department
- 21-11 Tenure Report PDF Result for Research Department
- 21-12 Microsoft Word Layout Document for Employee Directory
- 21-13 Specifying Layout Data Loop Name to Match Layout Tags
- 21-14 Configuring Interactive Report PDF Printing to Use Custom Layout
- 21-15 Employee Directory Interactive Report PDF Print Uses Custom Layout
- 21-16 PDF Download from Employee Directory Interactive Report
- 22-1 Employee Directory Page with an Interactive Report in Primary Language
- 22-2 Employee Details Form Page for HR Representatives Only in Primary Language
- 22-3 Enabling Application Translation in Globalization Settings
- 22-4 Adding the First Translation Language
- 22-5 Primary Language and First Translated Language Created and Synchronized
- 22-6 Page Title Changed to Reference Translatable Text Message by Name
- 22-7 All Translatable Text Undergoes Same Transformation
- 22-8 Identical Text References the Same Translatable Text Message
- 22-9 Exporting all Text Messages for a Language to an XLIFF File
- 22-10 Importing Translated Strings from XLIFF File
- 22-11 Configuring How Your App Determines the Current User's Language
- 22-12 User's Italian Browser Language Preference Drives App Language
- 22-13 Navigation Menu and Employee Directory Use Italian Translations
- 22-14 Employee Details Modal Drawer Uses Consistent Italian Translations
- 22-15 Creating New Text Message in Primary Language
- 22-16 Enabling Text Messages Picker
- 22-17 Choosing Message in Text Message Picker Opened with the Globe Button
- 22-18 Picked Text Message Included with Proper Substitution Syntax
- 22-19 Adding New Translatable Text Inline on a Page
- 22-20 Synchronizing Text Messages Creates All New Messages Required
- 22-21 Accessing the Text Messages Grid Edit for Bulk Changes
- 22-22 Filtered Grid Edit is Handy for Bulk Translation
- 22-23 Manually Entered and Synchronized Messages Show for Italian Users
- 22-24 Converting Application Text to Text Messages
- 23-1 Using Environment Banners for DEV, TEST, and PROD
- 24-1 Creating a Small Employees Application Using the Create App Wizard
- 24-2 Choosing APEXlang Format for Your Application Export in App Builder
- 24-3 Importing an Application in APEXlang Format in App Builder
- 24-4 Previewing the Application to Import and Choosing an Application ID
- 24-5 Enabling Workspace Parsing Schema for ORDS REST Services if Needed
- 24-6 Modified Employees Page in Page Designer
- 24-7 Exporting Employees App (104) in APEXlang from SQL Developer
- 24-8 Previewing SQLcl Command to Export App 104 in APEXlang Format to a Parent Directory
- 24-9 Using APEXlang Code Completion While Editing an .apx File
- 24-10 VS Code Problems Panel Shows APEXlang Validation Errors Proactively
- 24-11 Clicking the “Play” Button to Import Your APEXlang Application to App Builder
- 24-12 Confirmation of a Successful APEXlang Application Import in VS Code
- 24-13 Verifying the Results of Importing the Latest Application Version from VS Code
- 24-14 Accessing an APEXlang View of the Current Page in Page Designer
- 24-15 Reviewing the APEXlang Representation of the Current Page in Page Designer
- 24-16 Reviewing APEXlang Diffs When Comparing Working Copy with Main App
- 25-1 Activities Palette Shows Available Types You Can Drag onto Diagram
- 25-2 Dragging an Activity from the Palette and Dropping onto the Canvas
- 25-3 Naming a New Activity in the Property Editor
- 25-4 Reattach a Connection by Dragging its Arrowhead or Starting Dot
- 25-5 Connection Anchor Dots Determine Line Slope
- 25-6 Reposition Anchor Dots in Source or Target Activities to Change Slope
- 25-7 Drag Handles on Horizontal and Vertical Segments of Selected Connection
- 25-8 Adding a New Connection Between Activities
- 25-9 Select a Line Then Single Click to Add an Elbow Dot
- 25-10 Repositioning an Elbow Dot with Drag and Drop
- 25-11 Add Additional Elbow Dots and Reposition Them to Create Any Routing
- 25-12 Adding a Next Activity From a Current One
- 25-13 Next Activity and Connection Appear on the Diagram
- 25-14 Configuring Properties on Connection Originating from a Switch
- 25-15 Using Content Menu to Add a New Activity Between Existing Ones
- 25-16 Dragging and Dropping a New Activity Between Existing Ones
- 25-17 Selecting and Moving a Group of Activities
- 25-18 Selecting a Set of Activities with a Shift+Drag Rectangle
- 25-19 Connection Arrow Tips Obscured by Activity Shapes
- 25-20 Use "Bring to Front" to Stack Connection Arrows On Top of Activity Shapes
- 25-21 Clicking Error Indicator to Review Pending Issues
- 25-22 Workflow Delivers Tasks to Potential Owners' Task List "Inbox"
- 25-23 Choosing an Action Task or Approval Task at Create Time
- 25-24 Approval Tasks Show Quick Action Buttons in the Task List
- 25-25 Action Tasks Have a (Complete) Button in Task Details Page
- 25-26 Configuring Task Participants
- 25-27 Task Instance Lifecycle: States and Actions that Change State
- 25-28 Updatable Action Task Definition Parameters Model User-Supplied Data
- 25-29 Disable Visible Flag to Hide a Parameter from the Task Details Page
- 25-30 Configuring Task Potential Owners Using a Parameter Value
- 25-31 Configuring a Human Task - Create Activity to Use a Task Definition
- 25-32 Passing the Value of a Workflow Parameter to a Task Definition Parameter
- 25-33 Retrieving Task Parameter Values into Workflow Variables
- 25-34 Lucy Initiates a Workflow and Sees It In Her "Requested Tasks" Page
- 25-35 Creating a Task Details Page for a Task
- 25-36 Task Details Page URL Appears After You Create or Assign a Page
- 25-37 Leo Sees Task Assigned to Him in His "My Tasks" Page
- 25-38 Leo Asks for More Information to Clarify the Task
- 25-39 Leo Enters His More Information Question
- 25-40 Lucy Sees the Task Shows Up in Her "My Tasks" Page
- 25-41 Lucy Clarifies and Submits the Additional Information
- 25-42 Leo Enters Parameter Values
- 25-43 Leo Completes the Task
- 25-44 Lucy Reviews Completed Workflow in Her "Initiated Workflows" Page
- 25-45 Lucy Sees Request Completed in Her "Requested Tasks" Page
- 25-46 Lucy Reviews Task Details to See Numbers Leo Supplied
- 25-47 Commenting Out Regions and Adding Page Items to Enter Additional Data
- 25-48 Automatic Field Types and Required Fields Validation
- 25-49 Making Items Read Only Unless User is Assigned Owner
- 25-50 Loading Task Parameter Values Into Page Items Before Page Render
- 25-51 Configuring a Custom Validator for Page Items in Task Details Page
- 25-52 Validation Error if User Enters Same Number Twice
- 25-53 Saving Task Parameter Values
- 25-54 Participants for Purchase Office Supplies Task Definition
- 25-55 Parameters for Purchase Office Supplies Task Definition
- 25-56 Actions Source Query Retrieves Computed Title and Potential Owner Emails
- 25-57 Email Template Used to Send New Task Notification
- 25-58 Email Body HTML in the Template for New Task Notification
- 25-59 Create Action on Purchase Office Supplies Task Definition
- 25-60 Send E-Mail Action on Task Create Event
- 25-61 Enabling Deep Linking so User's Click Can Directly Link to Page
- 25-62 Send E-Mail Activity Includes Page Link from Additional Data Query
- 25-63 Configuring the Value of APP_EMAIL Substitution
- 25-64 Send Push Notification Uses Link from Additional Data Query
- 25-65 Wait Activity
user_provide_two_valuesHas No Timeout Type - 25-66 Receiving the Notification Email and Clicking the Link
- 25-67 Page Collecting Two Values from the Notified User
- 25-68 Page Collecting Values from the User
- 25-69 Page Process Calls CONTINUE_ACTIVITY, Passing Data in Parameter Map
- 25-70 Inspecting the Details of the Completed Workflow
- 25-71 Configuring Workflow Participants
- 25-72 Title Appears in Console Page Listing Workflow Instances
- 25-73 Workflow Detail Page Displays Status of Selected Instance
- 25-74 Woods Clinic New Patient Procedure Inquiry Form
- 25-75 After Registering a Procedure Inquiry, a New Patient Awaits a Response
- 25-76 Workflow Version Starts in Development Mode Until You Activate It
- 25-77 Getting Started on a Patient Onboarding Workflow
- 25-78 Referencing Patient Columns by Name in the Workflow Title
- 25-79 Woods Clinic Patient Onboarding Workflow in App Builder
- 25-80 Geocoding New Patient Address in Registration Page
- 25-81 Invoking a PL/SQL Package API to Evaluate Service Range
- 25-82 Configuring Patient ID as Value of P_PATIENT_ID PL/SQL Parameter
- 25-83 Configuring a Switch Activity to Decide Based on a Workflow Variable
- 25-84 Assigning Outcome Condition to Connection Originating from a Switch
- 25-85 Configuring an Oracle Machine Learning AutoML Experiment
- 25-86 Inspecting the Algorithm "Leader Board" Results of the Experiment
- 25-87 Winning Neural Network Model for Woods Clinic Patient Onboarding
- 25-88 Two Combinations of Invoke API and Switch Using Machine Learning
- 25-89 Linking to a Workflow Diagram Page to Visualize Progress
- 25-90 Visualizing Onboarding Progress of New Patient Danny Deng
- 25-91 Task Definition Subject Uses Column Values from the Actions Source Table
- 25-92 Using Human Task Create Activity to Wait for Approval
- 25-93 Unified Task List Showing Patient Onboarding Approval Tasks for DAVID
- 25-94 Anya Ableton's Procedure Request Was Rejected for Being Too Risky
- 25-95 Configuring Send Email Activity and Email Template Placeholders
- 25-96 Native Activities for Alerting Users with Email or Push Notifications
- 25-97 Rejection Email Template with Two Placeholders
- 25-98 Referencing Additional Data Columns in an Activity
- 25-99 Anya Ableton Rejection Email from Woods Clinic Patient Onboarding Workflow
- 25-100 Cristina Cordero's Request Was Auto-Approved and Is Now Waiting
- 25-101 Provision Account Invoke API Activity Creates User Account
- 25-102 Cristina Cordero Receives Her New Account Credentials
- 25-103 Cristina Cordero's Request Was Auto-Approved and Is Now Waiting
- 25-104 Configuring an Activity to Wait Indefinitely
- 25-105 Patient Portal for Cristina Cordero on First Login
- 25-106 Cristina Cordero Completes Registration - Date of Birth
- 25-107 Cristina Cordero Completes Registration - Proof of Insurance
- 25-108 After Completing Registration, New Patients Portal Dashboard Options Change
- 25-109 Verifying Cristina Cordero's Patient Onboarding is Completed
- 25-110 Patient Procedures Table in the Woods Clinic Data Model
- 25-111 Patient's Medical Procedure Statuses Define its Lifecycle
- 25-112 Kanban Board Shows Users How Procedures Progress Through Their Lifecycle
- 25-113 Procedure Lifecycle Workflow Coordinates Application Logic
- 25-114 On David's Last Login, He Ticked the Remember Me Checkbox
- 25-115 David Launches Woods Clinic APEX App from His Dock
- 25-116 Home Page for Woods Clinic App Launched as a Native App
- 25-117 Navigating to Scheduling Page from a Different Screen
- 25-118 David Schedules Danny Deng's Procedure
- 25-119 Scheduled Medical Procedures Appear on the Calendar
- 25-120 Office Staff See Danny Deng's Procedure Scheduled on Kanban Board
- 25-121 Checking a Workflow from Pending Procedures List
- 25-122 Confirming Danny Deng Was Notified of Appointment
- 25-123 Danny Deng Gets Email with His Appointment Information
- 25-124 Discharging the Patient and Completing the Procedure
- 25-125 Entering Patient Discharge Instructions
- 25-126 Preparing Discharge Letter Using Generative AI
- 25-127 Invoice Prepared After Procedure Completed
- 25-128 Report Query Provides JSON Data for Pixel-Perfect PDF Report Layout
- 25-129 Report Source Configures SQL Query and Data Loop Name
- 25-130 Studying Report Query JSON and Testing Query in VS Code
- 25-131 Report Layout Provides Word Document Template for Invoice
- 25-132 Microsoft Word Document Defines Pixel-Perfect PDF Layout
- 25-133 Opening the Prepared Invoice Details
- 25-134 Reviewing Pixel-Perfect PDF Invoice
- 25-135 Entering Insurance Reimbursement Amount
- 25-136 Regenerating Final Invoice After Entering Insurance Payment
- 25-137 Reviewing Dashboard While Invoice Regenerates in Background
- 25-138 Execution Chain Simplifies Regenerating Invoice in the Background
- 25-139 Reviewing Regenerated Invoice Before Sending to Patient
- 25-140 David Marks Danny Deng's Invoice as Ready to Send to Patient
- 25-141 Danny Deng's Procedure Lifecycle Workflow Shows Invoice Emailed
- 25-142 Progress of Danny Deng's Procedure on Kanban Board
- 25-143 Danny Deng Receives Invoice for His Medical Procedure
- 25-144 David Marks Danny Deng's Medical Procedure Invoice as Paid
- 25-145 Kanban No Longer Shows Danny Deng's Procedure After Invoice is Paid
- 25-146 David Confirms Danny Deng's Medical Procedure is Paid
- 25-147 David Confirms Danny Deng's Procedure Lifecycle is Done
- 25-148 Strategy for Using Workflow to Orchestrate Patient Procedure Lifecycle
- 25-149 Lifecycle Events Handler Automation – Settings
- 25-150 Lifecycle Events Handler Automation – Source
- 25-151 Lifecycle Events Handler Automation – Actions
- 25-152 Lifecycle Events Handler Automation – Action Execution
- 25-153 Development Toolbar Appears When Running in Development Mode
- 25-154 Your Availability Setting Can Disable the Developer Toolbar
- 25-155 Enabling Info-Level Debug Tracing with the Developer Toolbar
- 25-156 Enabling Debug Tracing for Background Workflow Execution
- 25-157 Disabling Page Filter to View Recent Workflow Debug Requests
- 25-158 Examining Debug Exception Call Stack in Debug Viewer
- 25-159 APEX Dictionary Views Related to Workflow Instances
- 25-160 APEX Dictionary Views Related to Task Instances
- 25-161 Activating an In Development Workflow
- 25-162 Workflow Versions Accumulate Over Time