Running a script in the SQL Developer

Provide the source path and a destination path and click the Run Script button.

• For example to run PSFT FI script in SQL Developer

  @"C:\PSFTAI\ExtractPSFTFISCMAI.SQL" "C:\PSFTFI_SQLDEV" "ENG" "ENG" "SYSADM" "FINC" "ENGLISH" "ENGLISH"

  Note: C:\PSFTAI\ExtractPSFTFISCMAI.SQL is the location of SQL script and C:\PSFTFI_SQLDEV is the location for extracted data.
• For example to run PSFT HR script in SQL Developer

  @"C:\PSFTAI\ExtractPSFTHRMSAI.SQL" "C:\PSFTHR_SQLDEV" "ENG" "ENG" "SYSADM" "PSHCM" " "ENGLISH" "ENGLISH"

  Note: 

  C:\PSFTAI\ ExtractPSFTHRMSAI.SQL is the location of SQL script and C:\PSFTHR_SQLDEV is the location for extracted data.

Results are displayed in the lower Script Output panel and the ScriptRunner Task indicator.

After the task completes the ScriptRunner Task indicator changes as shown below.