Scan test Run Oracle ApexSec ApexDBWorkspaceScan test and it returns only pass percentage in the FlexDeploy UI.
Environment/Instance Properties
| Property Name | Property Code | Required | Description |
|---|---|---|---|
| APEXSEC Jar file path | FDAPEXSEC_SCANNER_JAR | Yes | ApexSec Scanner Jar with complete path (example C:\\ApexScanner\\apexScanner.jar) |
| APEX URL NameFDAPEX_URLDatabase Host | FDAPEXSEC_APEX_DB_HOST | Yes | Apex Database Host Name for DBWorkspace |
| APEX Database Port | FDAPEXSEC_APEX_DB_PORT | Yes | Apex URL Name Database Port Number for DBWorkspace (e.g http://[host]:[port]/apex1521) |
| APEX User Name | FDAPEX_USER | Yes | 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 | Password for APEX User. |
| APEX Database Host | FDAPEXSEC_APEX_DB_HOST | Yes | Apex Database Host Name for DBWorkspace |
| APEX Database Port | FDAPEXSEC_APEX_DB_PORT | Yes | Apex Database Port Number for DBWorkspace (e.g 1521) |
Project Properties
| Property Name | Property Code | Required | Description | Workspace Name | FDAPEX_WORKSPACE_NAME | Yes|
|---|---|---|---|---|---|---|
| APEX Workspace Name. Provide uppercase name. | ||||||
| Application ID | FDAPEX_APPLICATION_ID | No | APEX Application ID | |||
| APEX SID | FDAPEXSEC_APEX_DB_SID | Yes | Apex SID (e.g apx03) | |||
| APEX SQL File Name | FDAPEXSEC_SQL_FILE | Yes | The path to the Apex SQL file. If relative, it is assumed to be in the FD_ARTIFACTS_DIR.Application ID | FDAPEX_APPLICATION_ID | No | APEX Application ID |
Inputs
| Input Name | Input Code | Required | Description | |||
|---|---|---|---|---|---|---|
| APEX URL NameFDAPEX_URLDatabase Host | FDAPEXSEC_APEX_DB_HOST | No | Apex Database Host Name for DBWorkspace | |||
| APEX Database Port | FDAPEXSEC_APEX_DB_PORT | No | Apex URL Name Database Port Number for DBWorkspace (e.g http://[host]:[port]/apex1521) | |||
| Workspace Name | FDAPEX_WORKSPACE_NAME | No | APEX Workspace Name. Provide uppercase name.APEX SID | FDAPEXSEC_APEX_DB_SID | No | Apex SID (e.g apx03) |
| APEX User Name | FDAPEX_USER | No | 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 | No | Password for APEX User. | |||
| Application ID | FDAPEX_APPLICATION_ID | No | APEX Application ID | |||
| APEX Database Host | FDAPEXSEC_APEX_DB_HOST | No | Apex Database Host Name for DBWorkspace | |||
| APEX Database Port | FDAPEXSEC_APEX_DB_PORT | No | Apex Database Port Number for DBWorkspace (e.g 1521) | |||
| APEX SID | FDAPEXSEC_APEX_DB_SID | No | Apex SID (e.g apx03) | |||
| APEX SQL File Name | FDAPEXSEC_SQL_FILE | No | The path to the Apex SQL file. If relative, it is assumed to be in the FD_ARTIFACTS_DIR. |
Outputs
| Output Name | Description |
|---|---|
| FDAPEXSEC_SCAN_PASSPERCENTAGE | The pass percentage of testfrom the Apex Scan. eg: 85 |
Artifacts
This operation produces artifacts that will be stored in the artifacts repository for only SQL filedoesn’t consume or produce any artifacts.
Endpoint Selection
This operation delegates endpoint selection to the workflow developer. The workflow editor will default the selection to "All", which selects all available endpoints associated to the environment instance. Selecting a specific resource will result in selection of endpoints associated to the environment instance which have that resource defined.
Endpoint Execution
This operation delegates endpoint execution to the workflow developer. The workflow editor will default to "Any", which will execute on any one of the selected endpoints, which will be randomly picked from selected endpoints or a specific endpoint where previous step may have executed. Changing this value to "All" to will result in execution on all selected endpoints.