Deploys an Oracle APEX application (produced by a build workflow using the buildAPEX plugin operation) to a target database. This operation manages deployment of builds produced by both the Full Deployment and Partial Deployment models.
...
Property Name | Property Code | Required | Description | |||
|---|---|---|---|---|---|---|
| Oracle Database SQLcl Home | FDAPEXFD_ORACLE_DBSQLCL_HOME | Yes | Oracle Database Home for example : | Oracle Database User | FDORA* | Folder where SQLcl is installed. |
| APEX User | FDAPEX_USER | Yes | The username that will be used to connect to the target Oracle Database. | Oracle Database Password | FDORA* | Provide database user APEX_xxxxx or owner (parsing schema) of the application for export and import operations. You can use system user as well. |
| APEX Password | FDAPEX_PASSWORD | Yes* | The password Password for Oracle Database APEX User. | |||
| APEX Oracle SIDDatabase URL | FDAPEXFDORA_ORACLE_SIDURL | Yes | The SID of the database that will be deployed to. | |||
| Oracle TNS_ADMIN | FDORA_TNS_ADMIN | No | Value for TNS_ADMIN environment variable if ora files are in non standard location. Example - /u01/app/oracle/product/11.2.0/dbhome_1/network/admin | |||
| Apex Source Script | FDAPEX_SOURCE_SCRIPT | No | Use this script to configure any environment variables required for executing the sqlplus client. | |||
| * | JDBC URL for Oracle database. For example:
|
Project Properties
Property Name | Property Code | Required | Description | ||
|---|---|---|---|---|---|
APEX Workspace Name | FDAPEX_WORKSPACE_NAME | NoYes | The name of the workspace to deploy the application to. Provide uppercase name. Required if application id not provided. | ||
| APEX Application Id | FDAPEX_APPLICATION_ID | No | Identifying number of application. If not specified, workspace name and application name must be provided. | ||
| APEX Application Name | FDAPEX_APPLICATION_NAME | No | The name of the application to deploy. Required if application id not provided. | ||
| APEX SQL FilesApplication Alias | FDAPEX_SQL_FILES | No | Comma separated list of SQL files to be executed during deployment, they will be executed based on the order in the list. If the SQL files are not provided, the plugin will execute all SQL files in the artifacts folder. The path is relative to the temp folder or can be fully qualified. This list should NOT contain spaces.ALIAS | No | APEX alphanumeric identifier unique within a workspace and page. If alias is not provided APEX Application Id will be used |
| APEX Offset value | FDAPEX_OFFSET | No | The offset value during application import. This value is used to ensure that the metadata for the Application Express application definition does not collide with other metadata on the instance. | ||
| Use APEX Offset | FDAPEX_USE_OFFSET | No | Determines if the plugin will attempt to set the Offset. | ||
| Database Schema | FDAPEX_DB_SCHEMA | No | Used to set the parsing (owner) schema of the APEX application. Provide uppercase schema name. | ||
| APEX Application Alias | FDAPEX_ALIAS | No | APEX alphanumeric identifier unique within a workspace and page. If alias is not provided APEX Application Id will be used |
Inputs
| Input Name | Input Code | Required | Description |
|---|---|---|---|
...