Flows for APEX
Niels de Bruijn
25-AUG-2020
About us
Oracle
Platinum Partner
Microsoft
Gold Partner
280
Employees
Privately-Owned
Corporation
Top Company for
Trainees &
Students
Cross-Industry
Non-Proprietary
Head Office
Ratingen
Branch Offices
Frankfurt am Main
Cologne
Dortmund
Munich
Founded
1994
33 Mio. Euro
Revenue in 2018
>100 Clients
Your Partner for Digital Change
Individual IT Solutions from a Single Source
About me
§ Niels de Bruijn, Business Unit Manager Low-Code @ MT AG
§ Dutch guy, born in 1977, married, three daughters, living in Ratingen
§ Responsible for all Low-Code activity in the company
§ Knowledge Portal: apex.mt-ag.com
§ Track record with APEX since its inception
§ Oracle APEX 18 Developer Certified Professional
§ DOAG e.V. - Director Development Community & Conference Chair for APEX Connect
Flows for APEX
Model and run process flows all within Oracle Application Express (APEX)
Features
§ For APEX developers that need process flows in their apps
§ Packaged App for APEX 20.1+
§ PL/SQL API
§ Supports BPMN 2.0 (utilizes bpmn.io)
§ Region Plugin for existing APEX apps
§ Open source (MIT license)
Use Cases
• Approval processes
• Requirements Engineering
• Documentation purposes
Demystifying
Flows for
APEX
Editing and saving a flow
• BPMN 2.0 generates XML on the client
• XML is stored in table flow_diagrams utilizing an APEX collection
• XML is parsed and stored in tables flow_connections, flow_objects
and flow_object_attributes
Demystifying
Flows for
APEX
Creating a process instance and navigate around
• Use the PL/SQL API flow_api_pkg with its methods:
•
flow_create
•
flow_start
•
flow_next_step
•
flow_next_branch
•
flow_reset
•
flow_delete
Demystifying
Flows for
APEX
Display a flow in your existing app
§ Install Flows for APEX in your workspace
§ Install the region plugin BPMN viewer
§ Set the plugin attributes
§ Run the page
The team behind Flows for APEX
Like to come aboard? See https://github.com/mt-ag/apex-flowsforapex
Introducing our core team of passionate APEX developers:
Ric