Minimal requirements

Flows for APEX minimal requirements are:

  • Oracle database: 12.2 or higher
  • Oracle APEX: 20.1 or higher

Installation with the packaged application

  1. Download the latest version of the packaged app here.
  2. Log in into your Oracle APEX workspace and click on the “Import” cards. Packaged App start installation
  3. 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. Packaged App select file to import
  4. 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”. Packaged App summary before install
  5. 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. Packaged App Supporting Objects Installation
  6. 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.

  1. Get the full distribution content by cloning the repository or downloading the release source code: zip or tar.gz.
  2. Connect to you Oracle schema with SQLcl, make sure you are located into the distribution folder.
  3. Run the installation script, it will create the database objects and import the application.
    SQL> @src/install_all_scratch.sql
    
  4. 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
    
  5. 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
    >> ====================================
    

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.