Installation Documentation
Flows for APEX Enterrise Edition v25.1 has a single installation process (unlike v24.1, where the Ask Flo AI was optional).
Pre-Requisites
-
You need a working Flows for APEX v25.1 Community Edition installation before you start - the Enterprise Edition instals on top of the Community Edition.
-
If you have an existing Flows for APEX 24.1 or earlier installation, upgrade and migrate this to Flows for APEX v25.1 Community Edition first using the instructions here.
-
If you are installing a new system, start by installing Flows for APEX Community Edition v24.1. You can do this by importing the Flows for APEX Community Edition app and installing its supporting objects.
-
-
You should have Timers set up and working. (Unlike v24.1, these are now set up for you as part of the Community Edition installation - so this should already be the case)
-
APEX Version. Installation requires Oracle APEX v24.1 or later.
-
Database: Installation requires Oracle Database 19c or later.
-
Privileges: The Flows for APEX Schema requires the following privileges, grants, and roles:
Type Required System Privileges CREATE TABLE
CREATE PROCEDURE
CREATE SEQUENCE
CREATE VIEW
CREATE JOB
CREATE. TYPESystem Roles AQ_ADMINISTRATOR_ROLE
AQ_USER_ROLESystem Packages execute privilege on DBMS_AQ These are checked by the Installer before the Enterprise Edition can be installed.
-
To run the AI feature, you need to set up a Workspace-level Generative AI service for Flows for APEX, using OpenAI with the
gpt-4omodel with a static ID defined in APEX asF4A_AI_SERVICE. For detailed instructions, see below. -
If you are not using / not able to use the AI features, the 25.1 Community Edition APEX app installation should have already created a dummy AI service for you named
F4A_AI_SERVICEthat just links toexample.comand is non-functional. This is sufficient. You can edit this definition later (in Application Builder > Workspace Options), once you are ready to use AI.
Then follow one of these two paths to install a new environment or migrate an existing one.
New Enterprise Edition install.
You will need:
- to be running Oracle APEX 24.1 or later.
- to be running Oracle database 19c or later.
- have a running Flows for APEX 25.1 Community Edition installation.
- to have the required privileges (see above).
You then install the Enterprise Edition on-top of the Community Edition. The installation sets up Oracle Advanced Queueing, installs some missing PL/SQL package bodies and SQL views, recompiles everything, and gives you an Enterprise Edition system. To do this:
- Download the Enterprise Edition package from the link given to you by Flowquest.
- Unzip the release into a folder on your computer.
- Change Directory to the folder containing the unzipped files.
- Using SQLcl, connect to the database as the Flows for APEX schema owner.
- Run the file
install_all_ee.sql. This should- suspend the timer job
- create Oracle AQ objects
- Upgrade your schema by adding views and packages required for Enterprise Edition.
- Recompile all of the Flows for APEX packages
- Add your licence information to the Flows for APEX configurations
- Restart your timer job.
- Flows for APEX Enterprise Edition should now be running.
Existing Enterprise Edition v24.1 User migrating to v25.1
You will need:
- to be running Oracle APEX 24.1 or later.
- to be running Oracle database 19c or later.
- to have the required privileges on the Flows for APEX Schema. (Note new privileges required for 25.1)
The migration path in overview is:
-
Prevent access to the system by users.
-
Disable Timers.
-
Backup your System.
-
Follow. the instructions to migrate a Community Edition v24.1 installation to a CE v25.1 one. This will temporarily make your system a v25.1 Community Edition.
-
Install Enterprise Edition v25.1 on-top of the Community Edition. The installation sets up Oracle Advanced Queueing, installs some missing PL/SQL package bodies and SQL views, recompiles everything, and gives you an Enterprise Edition system. To do this:
-
Download the Enterprise Edition package from the link given to you by Flowquest.
-
Unzip the release into a folder on your computer.
-
Change Directory to the folder containing the unzipped files.
-
Using SQLcl, connect to the database as the Flows for APEX schema owner.
-
Run the file
install_all_ee.sql. This should- suspend the timer job
- create Oracle AQ objects
- Upgrade your schema by adding views and packages required for Enterprise Edition.
- Recompile all of the Flows for APEX package.
- Add your licence information to the Flows for APEX configurations
- Restart your timer job.
-
-
Flows for APEX Enterprise Edition should now be running.
Set up your APEX Workspace-level GenAI Service for Flows for APEX.
To set Up Your Workspace-level Flows for APEX API service in APEX.
-
Open APEX, go into the Application Builder, and select Workspace Utilities
-
Select Generative AI

-
Either edit the Generative AI service named “Flows for APEX AI Service”, with a static ID of “F4A_AI_SERVICE”, or create one if it doesn’t already exist..
You will need to get an API Key from openai.com if you don’t already have one stored in your workspace credentials.
.