Skip to Main Content

Sample Workflow, Approvals, and Tasks

Demonstration of Workflow, Approvals, and Tasks capabilities in Oracle APEX.

About This App

This application lets users manage changes to an employee's salary, job, or bank account, provision a laptop for an employee, and manage employee self-appraisals. All use cases involve human tasks requiring an action by an appropriate individual, some of which require an approval or rejection. The sample highlights the key features of the Oracle APEX Workflow, Approvals, and Tasks capabilities.

Any user can request the change of an employee's salary, job, or bank account, but users BO, JANE, PAT, and STEVE in the OPERATIONS department (40) handle approval and administration of the Salary Change, Job Change, Bank Account Change, and Laptop Approval tasks. The bank account request task is unique in that the requestor is also allowed to approve the request. For self-appraisals, the employee being requested to evaluate themselves is the initial assignee of that action task.

For simplicity, the sample uses a custom authentication scheme so you can easily login as any employee in the fictitious company and quickly switch from one user to another. Of course, your real-world application will require each user to authenticate with their own password to access the system. The workflow, approvals, and tasks functionality works the same way, regardless of the authentication scheme in use.

See More Information for background on workflow, approvals, and tasks features and how the sample uses them.