Deploy the application to the database. This operation requires one ore more exported SQL files, ithese files can be either specified by using the APEX SQL Files (FDAPEX_SQL_FILES) or the plugin will deploy the ".sql" files in the artifacts folder.
This plugin supports deploying the same APEX application to the same database. This requires setting the Offset.
- If the application has never been deployed and you do not currently have an offset, the plugin can generate the offset, just select Use APEX Offset (FDAPEX_USE_OFFSET). , make sure you note the offset value used and set the property APEX Offset value (FDAPEX_OFFSET) for the next deployment.
- If you know the Offset, select Use APEX Offset (FDAPEX_USE_OFFSET) and set the property APEX Offset value (FDAPEX_OFFSET).
You will also need to set the application id and change the alias.
Environment/Instance Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
Oracle Database Home | FDAPEX_ORACLE_DB_HOME | Yes | Oracle Database Home for example : /u01/app/oracle/product/11.2.0/dbhome_1 |
| Oracle Database User | FDORA_USER | Yes | The username that will be used to connect to the target Oracle Database. |
| Oracle Database Password | FDORA_PASSWORD | Yes | The password for Oracle Database User. |
Project Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
APEX Workspace Name | FDAPEX_WORKSPACE_NAME | No | The name of the workspace to deploy the application to. |
| APEX Application Id | FDAPEX_APPLICATION_ID | No | Identifying number of application. |
| APEX Application Name | FDAPEX_APPLICATION_NAME | No | The name of the application to deploy. |
| APEX SQL Files | 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 |
| 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 | Detemines if the plugin will attempt to set the Offset. |
| APEX Oracle SID | FDAPEX_ORACLE_SID | Yes | The SID of the database that will be deployed to. |
| Database Schema | FDAPEX_DB_SCHEMA | No | Used to set the parsing (owner) schema of the APEX application. |
| APEX Application Alias | FDAPEX_ALIAS | No | APEX alphanumeric identifier unique within a workspace and page |
Inputs
| Input Name | Input Code | Required | Description |
|---|---|---|---|
Outputs
Output Name | Required | Description |
|---|---|---|
Artifacts
This operation consumes artifacts from the artifacts repository.
Endpoint Selection
This operation will select all available endpoints associated to the environment/instance.
Endpoint Execution
This operation will execute on any one of the selected endpoints and will be random in the determination of which one.
Special Considerations
This operation