Go With The Flow

February 15, 2022 | 5 minute read
Text Size 100%:

Have you ever wondered if it’s possible to create a business process application?

What about a low code business process application?

Well, wonder no more with the Flows for APEX project.

To showcase the integration of a flow into an APEX application, the good people from MT-AG have created a tutorial on how to create a basic application that uses Business Process Mapping Notation (BPMN).

There is a tutorial for Flows for APEX, but there is no documentation on how to install it.

So we'll review the install procedure below.

Download the FlowsForAPEX app

First up we need to download the FlowsForAPEX app from the official website.

Once the file is downloaded, unzip it.

The file of interest to us in the next step will be FLOWSFORAPEX_APEX201_984339_UTF8_V21.1.sql

Install the FlowsForAPEX app inside Oracle APEX

Login to your Oracle APEX workspace. We will use the APEX Service in the Oracle cloud, but you can potentially use any APEX instance.

Choose Import.

Then select the file: FlowsforAPEX_v21.1\Flows for APEX v21.1\Applications\FLOWSFORAPEX_APEX201_984339_UTF8_V21.1.sql

Keep the defaults, and click on Next.

When the import is successful, click on Next again.

Again keep the defaults, and click on Install Application.

The next step is to install the supporting objects for the application.

Keep the defaults and click on Next.

Once complete, from here the FlowsForAPEX is ready to be run.

Now choose Run Application.

Login to the workspace.

View the tutorials

After login, you will be presented with the application dashboard.

In the top left corner is the hamburger menu, so click on that then select Flow Management.

Now what you will see are all the tutorials that are available.

The full list is:

  • Tutorial 0 — Getting Started.
  • Tutorial 1 — The Gateway Tutorial — how to have conditional task routing.
  • Tutorial 2 — Parallel Gateways — how to create sections of your process that execute in parallel.
  • Tutorial 3 — Inclusive Gateways — but not always all of the parallel sections.
  • Tutorial 3A — Using Variable Expressions to set Process Variables from your Model.
  • Tutorial 4 — Tasks Get your Work Done — How to call APEX pages, scripts, and send emails in your process.
  • Tutorial 5 — Sub Processes — Encapsulating part of your process into a sub Process.
  • Tutorial 6 — Errors and Escalations — How to handle things needing help or going wrong in your process.
  • Tutorial 7 — It’s about Time — Adding timers to create reminders, process closing flows, process timeouts, etc.
  • Tutorial 8 — Lanes and Reservations — modeling who does what.
  • Tutorial 9 — The Full Monty.

Select the hamburger menu for the first tutorial, and Show Details.

Now you can see the first tutorial: Tutorial 0 — Getting Started

Review all the tutorials.

Then the last tutorial showcases all the features on the same page.

Flows for APEX is a 100% open source project from MT-AG.

And as we discovered, it’s 100% awesome too!

Join the conversation!

If you’re curious about the goings-on of Oracle Developers in their natural habitat, come join us on our public Slack channel! We don’t mind being your fish bowl 🐠

Also, if you're at all interested in APEX, you'll also appreciate everything that's offered in an OCI Free Tier account.

Paul Guerin


Previous Post

Using Mongo APIs with Micronaut Data to Persist and Query Data with Autonomous DB

Todd Sharp | 9 min read

Next Post


Getting Started With Ruby (and Ruby on Rails) on OCI

Tim Clegg | 13 min read