runApexSQLFileScan

Executes Apex Sec Scan for the SQL File and returns pass percentage. The SQL file is should be the export of the Oracle Apex Application.

Environment/Instance Properties

Property NameProperty CodeRequiredDescription
APEXSEC Jar file pathFDAPEXSEC_SCANNER_JARYesApexSec Scanner Jar with complete path (example C:\\ApexScanner\\apexScanner.jar)

Project Properties

Property NameProperty CodeRequiredDescription
APEX SQL File NameFDAPEXSEC_SQL_FILEYesThe path to the Apex SQL file. If relative, it is assumed to be in the FD_ARTIFACTS_DIR.

Inputs

Input NameInput CodeRequiredDescription
APEX SQL File NameFDAPEXSEC_SQL_FILENo

The path to the Apex SQL file. If relative, it is assumed to be in the FD_ARTIFACTS_DIR. If not provided, value from  project property will be used.

Outputs

Output NameDescription
FDAPEXSEC_SCAN_PASSPERCENTAGEThe pass percentage from the Apex Scan. eg: 85

Artifacts

This operation consumes the SQL file artifact that is stored in the artifacts repository.

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.