Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This operation unzips artifact from csvExport, start import process for all Setup Task CSV Packages to target environment, and waits for completion. The csvImport operation can only be used with a FlexDeploy package-based project of type Oracle SaaS FSM.

Artifact contains zero or more zipped Setup Task CSV packages.

Target Properties

...

Property Name

...

Property Code

...

Required

...

Description

...

Oracle SaaS FSM Account

...

FDFSM_CLOUD_ACCOUNT_CODE

...

No*

...

As of versions 6.5.0.20, 7.0.0.11, 8.0.0.6, and 9.0.0.0, this operation imports some files as JSON (Lookups, ValueSet) and others as CSV. Both formats can be successfully uploaded by the import operation.

Target Properties

Property Name

Property Code

Required

Description

Oracle SaaS FSM Account

FDFSM_CLOUD_ACCOUNT_CODE

No*

Oracle SaaS FSM Account will be required on either the plugin input or Target. If a value is set on both then, the plugin input will take precedence.

See Special Considerations below for instructions on how to create Oracle SaaS FSM account.

Oracle SaaS FSM ChromeDriver Path

FDFSM_CHROME_DRIVER_PATH

No*

Location of the chromedriver executable. I.E. /usr/local/bin/chromedriver or C:/Users/user/Documents/chromedriver.exe.This is required only used ifFDFSM_INP_COMPILE_FORMULAS is enabled.Defaults to /usr/local/bin/chromedriver is enabled and the api call to compile the fast formula returns a 403.

See Special Considerations below for instructions on how to download install google chrome and download chromedriver.

...

Input Name

Input Code

Required

Description

Oracle SaaS FSM Account

FDFSM_INP_CLOUD_ACCOUNT_CODE

No*

Oracle SaaS FSM Account will be required on either the plugin input or Target. If a value is set on both then, the plugin input will take precedence.

See Special Considerations below for instructions on how to create Oracle SaaS FSM account.

API Timeout

FDFSM_INP_TIMEOUT

No

Maximum amount of time (seconds) to wait for import process to complete after it is started. Defaults to 900 seconds (15 minutes).

Compile Fast Formulas

FDFSM_INP_COMPILE_FORMULAS

No

Enable compile fast formula after successful import. Applicable to packages containing one more fast formulas. Defaults to true. See special considerations section for additional Chrome browser dependency.

Use SOAP Compilation

FDFSM_INP_USE_COMPILESOAP_FORMULASCOMPILATION

NoEnable compile fast formula after successful import. Applicable to packages containing one more fast formulas. Defaults to true. See special considerations section for additional Chrome browser dependency

Compiling Fast Formulas defaults to using REST apis and falls back to Selenium. Check this to use SOAP instead. Different roles and permissions are needed in each case. If getting a 403, try the other option, or fall back to Selenium option. Selenium fall back is not used if this is checked.

Compile Formula UI Timeout

FDFSM_INP_COMPILE_FORMULAS_UI_TIMEOUT

No

Maximum amount of time (seconds) to wait for Compile Formula payroll flow to complete. Defaults to 300 seconds (5 minutes).

Remote Allow Origins

FDFSM_INP_REMOTE_ALLOW_ORIGINS

No

The value of remote-allow-origins on the Selenium ChromeDriver. Set the value to "*" or specific URL if there are ConnectionFailedException errors during compilation of a Fast Formula.

Using Google-Chrome version v111+ you may be experiencing an error like the below when compiling a fast formula through Selenium Chrome driver:

Code Block
org.openqa.selenium.remote.http.ConnectionFailedException: Unable to establish websocket connection to http://localhost:49877/devtools/browser/3a3af47d-732a-4337-a91c-18c8ced545cd

Save Import Result File

FDFSM_INP_SAVE_IMPORT_RESULT_FILE

No

Saves a comparison result file to the reports directory as a JSON file. The JSON file provides a summary of the comparison process and represents the table shown in the Comparison Details section of the user interface.

Save Import Report File

FDFSM_INP_SAVE_IMPORT_REPORT_FILE

No

Saves a comparison report file to the report's directory as a HTML file. The HTML file provides comparison reports for each of the business objects that were processed. For each business object, a report each for Only in Configuration 1, In Both with Mismatch, and Only in Configuration 2, as applicable is provided.

Save Import Summary Report File

FDFSM_INP_SAVE_IMPORT_SUMMARY_REPORT_FILE

No

Saves a comparison report file to the report's directory as a HTML file. The HTML file provides a summary of the process results, which displays a list of all the processed business objects, and whether their processing completed successfully, or with errors.

...

If FDFSM_INP_COMPILE_FORMULAS is enabled, then compile is attempted twice for each Fast Formula object in the package. The first try make use of the Oracle API’s, but the 2nd attempt utilizes the Chrome browser First, the Oracle APIs to compile are used. If that fails with a 403, the plugin can make a second attempt using a headless Chrome browser run through Selenium to compile from the Oracle SaaS UI. In the latter case Google Chrome and the chromedriver must be installed on the endpoint. If the endpoint is localhost then, Chrome and chromedriver should be installed on the FlexDeploy server. See the below for detailed instructions to install Google Chrome in an Unix environment. Windows install is not covered in the following.

...