Flows for APEX minimal requirements are:
- Oracle database: 19c or higher
- For RDBMS 19.3 to 19.10, you must either upgrade to a more current patch release 19.11 or later, or download and apply patch.31843028 from Oracle Support. This fix is included in 22.214.171.124.210420DBRU onwards.
- Oracle APEX: 20.1 or higher.
- Using User Task of type “APEX Approvals” requires APEX 22.1 or higher.
Installation with the packaged application
- Download the latest version of the packaged app here.
- Log in into your Oracle APEX workspace and click on the “Import” cards.
- On the import page, choose the previously downloaded SQL file, make sure that the option “Database Application, Page or Component Export” is selected and click on the “Next” button. A new page should confirm that the file have been correctly imported. Click on the “Next” button.
- The next wizard page is a summary of the installation that will be done. Make sure the selected options are correct and click on “Install Application”.
- After installation, you will be asked if you want to install the Supporting Objects. Enable the switch and click on “Next”. A confirmation page will be loaded, confirm the installation by clicking on the “Install” button.
- After installation, you can click on the “Run Application” button to log into the Flows for APEX application and start building flows.
Installation with SQLcl
For Windows users, please make sure to set NLS_LANG value correctly by running
set NLS_LANG=AMERICAN_AMERICA.UTF8 before using SQLcl.
- Get the full distribution content by cloning the repository or downloading the release source code: zip or tar.gz.
- Connect to you Oracle schema with SQLcl, make sure you are located into the distribution folder.
- Run the installation script, it will create the database objects and import the application.
- Provide the Workspace Name, Parsing Schema, Application Alias and Application Name.
>> Please enter needed Variables Enter Workspace Name: [FLOWS4APEX] FLOWS4APEX Enter Parsing Schema: [FLOWS4APEX] FLOWS4APEX Enter Application Alias: [FLOWS4APEX] FLOWS4APEX Enter Application Name: [Flows for APEX] Flows for APEX
- At the end of the installation, you should see the confirmation that the product have been correctly installed. You can connect to your Oracle APEX builder and run the Flows for APEX application.
>> Finished Installation of Flows4APEX >> ====================================
Post Installation Tasks
Post Installation Task 1: Additional step to use timers
Grant create job
Your schema need to have the privilege “create job” to use the timers feature of Flows for APEX. As SYS, you have to run the following command:
grant create job to <my_workspace_schema>;
Create timers job
We provide a SQL script in the distribution to enable the timer feature. Run enable_timers.sql (app_dist/Applications/Enable_Timers) in your schema with SQLcl or using the SQL Workshop in the APEX builder.
Post Installation Task 2: Configuration
Set Workspace and Default App and User Info
- Start the Flows for APEX Application.
- Open the Congiguration page from the menu bar on the right hand side of the top of the screen.
- Set the default Workspace Name
- Set a default application ID and a default username. The App ID and Username must exist in the specified workspace. These parameters are used to create an APEX session when a Flows for APEX task is started from outside of APEX, for example in a process following a timer event. You can adjust these parameters or remove them before your application goes production if you want.