Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Dive into Workflow and Task definition in Oracle APEX

Name: Dive into Workflow and Task definition in Oracle APEX
Rating: 4.9 (21 reviews)

A Practical Guide to Workflow and Task Definitions in Oracle APEX [ English subtitles ]

Highest Rated

Created byAli Saleh Ali

Last updated 7/2026

Arabic

Arabic [Auto],English

What you'll learn

Principles of workflow automation and design in Oracle APEX.
Integrating approvals, notifications, and conditional processing.
Creating and visualizing workflows using Oracle APEX tools.
Automate your business process and logic using APEX Workflow
Define workflow activities, variables, parameters,additional data, and connections to get requirementssiness reqirments .
Start a new workflow through a Page Process
Monitor the progress of workflows you have initiated
Understand The complete Development Lifecycle of Workflows
Debugging into Faulted Workflows and retry Workflows as a Workflow Owner from the Workflow Console
Suspending a Workflow, Updating Variables and Resuming a Workflow as a Workflow Administrator
How to define tasks and objectives effectively within Oracle APEX.
Use the automation of user processes or the intervention of the application core to perform some independent tasks.

Course content

18 sections • 161 lectures • 8h 53m total length

Intro about Business Process , Business Process Managment and Workflow7:30

Create Task definition2:57
Understand Task Definition attributes ( setting )2:47
Understand Task Definition attributes ( Deadline )2:13
Understand Task Definition attributes ( Participants )5:21
Understand Task Definition attributes ( Parameters )1:59
Understand Task Definition attributes ( Actions )2:12
Create Task Instance ( Get Primary Key Value)4:14
Create Task Instance ( create Page to call task instance)3:22
Create ( Initiated by Me ) Page2:28
Create Task Detail Page3:37
Create ( My Tasks ) Page4:58
Create ( Admin Tasks ) Page3:05
Create full cycle for Task instance5:09
Dive into unified task list Reports8:45
Dive into Task Detail Page ( Part 1 )7:00
Dive into Task Detail Page ( Part 2 )5:07
Create Action Task defination13:14
Task Operation to Event Mapping and Task States5:30

Sample Approval Example ( Part 1 ) Create Task defination10:50
Sample Approval Example ( Part 2 ) Create Page to call task9:43
Sample Approval Example ( Part 3 ) Create Task Reports7:12
Sample Approval Example ( Part 4 ) understand participants Roles10:18
Sample Approval Example ( Part 5 ) Add more complexity8:35
Sample Approval Example ( Part 6 ) Claim,Release and Delegate7:41
Sample Approval Example ( Part 7 ) cancel,request information6:20

API Intro1:56
ADD_TASK_COMMENT & ADD_TASK_POTENTIAL_OWNER5:26
ADD_TO_HISTORY2:19
Approve, Reject and Complete Task5:29
Cancel & Cliam Task3:33
Create Task3:15
DELEGATE_TASK2:23
RELEASE_TASK2:17
Get LOV of priority ,state and Delegates3:41
GET_TASK_HISTORY2:09
GET_TASK_PARAMETER_VALUE2:17
GET_TASK_PRIORITIES2:13
GET_TASKS3:25
IS_ALLOWED3:58
IS_BUSINESS_ADMIN & IS_OF_PARTICIPANT_TYPE3:49
REMOVE_POTENTIAL_OWNER2:31
RENEW_TASK1:51
REQUEST_MORE_INFORMATION1:34
SUBMIT_INFORMATION1:17
Sets the priority , due date and updates the values of the parameter(s)3:07
Task definition Views1:04
Task Definitions Resourses0:09

Workflow intro2:56
Simple Workflow Example ( Part 1 ) understand scenario1:52
Simple workflow example (Part 2 ) Create Workflow3:35
Simple workflow example (Part 3 ) start Workflow instance3:21
Simple workflow example (Part 4 ) Create Workflow with Details Primary Key7:22
Simple workflow example (Part 5 ) using [ Switch ] Activity4:07
Simple workflow example (Part 6 ) using [ Send E-Mail ] Activity2:18
Simple workflow example (Part 7 ) using [ Wait ] Activity2:33
Simple workflow example (Part 8 ) using [ Human Task ] Activity8:31

Identify Business Steps4:01
Create Doctor Appointment Application and add tables and Package3:08
Create Workflow for Doctor Appointment [ first step ]4:59
Doctor Appointments intro1:26
Create Appointment Request Task definition2:17
Create Invoice Request Task definition1:55
Create Feedback Request Task definition1:18
workflow design ( Part 1 )7:48
workflow design ( Part 2 )5:00
workflow design ( Part 3 )7:12
workflow design ( Part 4 )2:42
workflow design ( Part 5 )4:35
workflow design ( Part 6 ) Review Full Scenario1:04
Creating the Patient Tasks Page & Doctor Tasks Page1:40
Creating the Patient Tasks Page
Our application has 2 entry points for Patients.
First, to confirm an invoice request. Second, to provide feedback.
For this we need to create a Unified Task List for Patients to act on.

Creating the Doctor Tasks Page
Our application has 1 entry point for Doctors.
Doctors need to log in to approve or reject appointment requests.
For this we will create a Doctor Tasks page.
This will also be a Unified Task List page for Doctors to act on the tasks assigned to them.
Modifying Task Details Pages for each Task definition1:47
Our Application has 3 Task Definitions -
Appointment Request.
Invoice Request.
Feedback Request.
For each of them we had generated a Task Details page.
we will rename the Pages so that they appear more meaningful in the Application.
Updating the Feedbacks Page4:05
Patient Appointments And Feedbacks.
We will create a View Only page where a patient to view their appointments and feedbacks they have left so far.
View the Patient Appointments And Feedbacks Page2:30
Create Page to Monitor Appointment Workflows0:39
Running the Doctor Appointments (Full Scenario )7:08
Running the Doctor Appointments ! Application and test full scenairo
Creating the New Appointments Page5:27
create the Page which will be used by the Hospital Staff to Submit a New Appointment.
Other Scenarios to try0:44
You may try the following usecases and observe the difference in the workflows.

Requirements

Oracle APEX Bigneer level

Description

In our course

We will Dive into

Workflow
Task definition
Automation

in Oracle APEX

We will learn

Automations are a sequential set of actions, triggered by query results that monitor data and then perform the appropriate action.

Human Tasks in APEX are items that need to be actioned by people,

Approval Tasks, for tasks that can be approved or rejected. The user who owns the task evaluates the information in the task, and then either Approves or Rejects the task. A task that asks a manager to approve or deny a laptop request for an employee is an approval task.
Action Tasks, for tasks that need to be actioned. The user who owns the task performs the action requested in the task, and then Completes the task. A task that asks an employee to fill in a self-evaluation is an action task.
Implementing Multi-Approvals in Oracle APEX

Automate your business process and logic using APEX Workflow
Define workflow activities, variables, parameters,additional data, and connections to suit your business logic.
Start a new workflow through a Page Process
Monitor the progress of workflows you have initiated

The complete Development Lifecycle of Workflows
Workflow Versions in states 'In Development', 'Active' and 'Inactive' and the meaning of it
Activating a Workflow Version for production
Running a Workflow in 'In Development' state from App Builder
Debugging into Faulted Workflows and retry Workflows as a Workflow Owner from the Workflow Console
Suspending a Workflow, Updating Variables and Resuming a Workflow as a Workflow Administrator
Multi Level Expense Approval using APEX Workflow
APEX Workflow Dashboard, Diagram and Debugging
Archiving human tasks and workflows

Who this course is for:

for Oracle APEX Developer

Dive into Workflow and Task definition in Oracle APEX

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 8min

Dive into Task Definition18 lectures • 1hr 24min

Sample Approval Application Using ( Task defination )7 lectures • 1hr 1min

Multi-level Approval ( using Task defination )7 lectures • 31min

APEX Human Task (API)22 lectures • 1hr

Automations7 lectures • 15min

Automation API8 lectures • 17min

first look at the workflow9 lectures • 37min

Dive into Workflow Definition Page7 lectures • 17min

Process Management using APEX Workflow for [ Doctor Appointments Application ]21 lectures • 1hr 11min

Requirements

Description

Who this course is for: