runApexSQLFileScan

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

Target Properties

Property Name

Property Code

Required

Description

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)

Project Properties

Property Name

Property Code

Required

Description

Property Name

Property Code

Required

Description

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.

Inputs

Input Name

Input Code

Required

Description

Input Name

Input Code

Required

Description

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. If not provided, value from  project property will be used.

Outputs

Output Name

Description

Output Name

Description

FDAPEXSEC_SCAN_PASSPERCENTAGE

The 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 target. Selecting a specific resource will result in selection of endpoints associated to the target 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. 

The following macros are not currently supported in the footer:
  • style