Oracle APEX Application

The Oracle APEX Application blueprint will create the topology, workflows, source control repository connection, and project for managing the build and deployment of an APEX application.

Install SQLcl client on FlexDeploy server, which is just a zip file that can be extracted in folder like c:\installs or /u01, in which case SQLcl Home will be c:\installs\sqlcl or /u01/sqlcl. You can decide to use a different server if you like but that would require small adjustments once you run through this blueprint.

The Development environment is both the build environment and the single target environment mapped to for deployment.
The build instance instance is also used for deployment.
The build workflow, Build APEX, is created/linked and bound to APEX projects creating using this blueprint.
The deploy workflow, Deploy APEX, is created once and bound to all APEX projects created using this blueprint.
The instance is created based on the Parsing Schema.

Blueprint Properties

Property Name	Required	Description	How its used
Application Name	Yes	The APEX application name as configured in App Builder	FlexDeploy project is named using this value FlexDeploy project property is configured to this value
Application Description	No	A description for the application	FlexDeploy project's description is set to this value
Parsing Schema	Yes	The parsing (owner) schema for the application	FlexDeploy application name is configured to this value FlexDeploy project property is configured to this value FlexDeploy instance is created using this value
Workspace Name	Yes	The workspace the application belongs to	FlexDeploy instance is created using this value FlexDeploy project is mapped to this instance

Build

There are two options for building an Oracle APEX application. You can download the source files from the APEX App Builder, or source the files from a source control repository such as Git or Subversion.

Build Properties

There are no Build Properties for this blueprint, whether building from App Builder or an SCM Repository.

A single Development endpoint is created and linked to all Oracle APEX projects for the instance (Parsing Schema).

Which endpoint?

The endpoint can be any server which contains the Oracle JDBC driver and the SQLcl client.

Deploy

All APEX applications are deployed using FlexDeploy's Oracle APEX Plugin. As such, the only and default deploy option is Deploy APEX.

Deploy Properties

Property Name	Required	Description	How its used
SQLcl Home	No	Directory where SQLcl is installed on the endpoint	FlexDeploy environment instance property is configured to this value
APEX User	Yes	APEX user to import and export applications with. Use system or APEX_<xxxx>.	FlexDeploy environment instance property is configured to this value
APEX Password	Yes	The password for APEX User.	FlexDeploy environment instance property is configured to this value
Oracle Database URL	Yes	The JDBC connect string for the Oracle Database hosting the application.	FlexDeploy environment instance property is configured to this value

Which endpoint?

The endpoint can be any server which contains SQLcl client. Blueprint will default to execution on LOCALHOST which is FlexDeploy server itself, you can decide to change that if necessary.