Oracle Apex: Mastering Process, Tasks Approvals And Workflow

Mastering Oracle APEX Process, Tasks approvals and Workflow with Release 24.x with Demonstration and case study

What you'll learn

Latest Functionality of Oracle APEX - Process, Task approval, Workflows

Hands On demonstration with appropriate example application

Leave Approval Application

Multiple level expenses approval application involving workflow embedded with approvals and Process

Requirements

Basic knowledge and understanding of Oracle APEX functionalities with SQL & PLSQL

Description

            Oracle APEX 23.2 introduced the new Workflow Designer, which works with the existing Task Definitions to create workflows and automate business processes.In recent time, any application development requires appropriate workflow & approvals to be integrated, so as to not only understand the business process but also to ensure there is sufficient check and balances are in the systems. This is ensure multiple stakeholders are involved in decision making.Workflow and task approval are now integral part of any modern day ERP system. But with custom developed application, on need to integrate it with 3rd party workflow flow tools or custom developed workflow. But, these 3rd party application has its own challenge in integration and custom developed application has limitation.Oracle ERP application extensively runs of Workflow and approval since release 12 - early 2000s. Considering this, Oracle has now taken a step further to introduce workflow & task definition in Oracle APEX as a native Oracle Product.Note: This is a intermediate level course which extensively focuses on Oracle APEX new features listed below  Page process and dependency.Task Definition - approvals.WorkflowIntegrating them in application.  This course does not cover all other basic features & functionality of Oracle APEX, except for the above feature & functionalityFollowing are the topic of coverage of this course:Oracle APEX environment Options Getting Access to Oracle Cloud Infrastructure – as Free tier. Provisioning Oracle Autonomous Database on Oracle Cloud infrastructure.Provisioning and access Oracle APEX on Oracle autonomous DB on cloud.What is a workflow ?Workflow in Oracle APEXWhat is Process dependency?Building up process dependency in Oracle APEX and demonstration.Oracle APEX task definition & approval.Leave approval application build using task definition / approval.Hands On demonstration of Leave application program.Building up simple Oracle APEX workflow application.Involving task approval in the workflow.Building up simple Oracle APEX workflow application.Involving task approval in the workflow.Case Study :Multi level expense approval with process, task approvals, workflow.Exploring a build in sample application with task approval and workflow for employee.Happy Learning!.

Overview

Section 1: Introduction

Lecture 1 Topics of Course Coverage

Section 2: Oracle APEX Environment Options

Lecture 2 Oracle APEX Environment Options

Section 3: Getting Access to Oracle Cloud Infrastructure

Lecture 3 Getting Access to Oracle Cloud Infrastructure - Part 1

Lecture 4 Getting Access to Oracle Cloud Infrastructure - Part 2

Section 4: Provisioning Oracle Cloud autonomous Database

Lecture 5 Provisioning Oracle Cloud autonomous Database

Section 5: provisioning and connecting to Oracle APEX environment on OCI

Lecture 6 Provisioning and connecting to Oracle APEX environment on OCI

Section 6: Learning Basic functionality of Oracle APEX

Lecture 7 Learning Basic functionality of Oracle APEX

Section 7: What is a Workflow?

Lecture 8 What is a workflow?

Section 8: Workflow in Oracle APEX

Lecture 9 Workflow in Oracle APEX

Section 9: What is Process Dependency?

Lecture 10 What is Process Dependency

Lecture 11 Building Process Dependency

Lecture 12 Demonstration of Process Dependency With Oracle APEX

Section 10: Task Definition & Task approval in Oracle APEX

Lecture 13 Task Definition & Task Approval in Oracle APEX - Example Leave Approval

Lecture 14 Creation of Leave Request form and associate process task link

Lecture 15 Demonstration of Leave Approval program with Oracle APEX

Section 11: Quiz 1

Section 12: Oracle APEX - Workflow demonstration with simple example

Lecture 16 Simple Workflow creation

Lecture 17 Simple form, Process and calling workflow

Lecture 18 Simple Workflow demonstration

Lecture 19 Including an approval task in workflow

Lecture 20 Defining approval Task

Lecture 21 Approval Page Creation

Lecture 22 Demonstration of Workflow with associated approval

Section 13: Case study - Multi level expense approval with process, task approvals, workflow

Lecture 23 Case study - Requirement overview

Lecture 24 Case study - Solution - Step 1: Creation of table & blank application

Lecture 25 Case study - Solution - Step 2: Task Definition - Approval Task

Lecture 26 Case study - Solution- Step 3: Workflow creation - Part 1

Lecture 27 Case study - Solution - Step 3: Workflow creation - Part 2

Lecture 28 Case study -Solution - Step 4: Entry form and page process linking workflow

Lecture 29 Case study -Solution - Step 5: Creation of Approval & workflow monitoring pages

Lecture 30 Case study - Solution - Testing and execution of the the Build

Section 14: Quiz 2

Section 15: Installing & exploring sample Tasks and workflow application from APEX Gallery

Lecture 31 Data set and Sample application gallery with Oracle APEX

Lecture 32 Demonstration and exploring the Sample Application - Tasks approval & workflow

Section 16: Concluding remarks

Lecture 33 Concluding remarks

Oracle Application Developers in Oracle APEX,Oracle APEX developers who wish to understand knowledge of Process, Task and Workflow