Versions Compared

Version Old Version 1 New Version Current
Changes made by

Karl Henselin

Jay-Ar Brouillard

Saved on

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 packagespackages.

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.

Note

Setup Data Update Rules During Import

When you import a configuration package to the target environment, setup data in the target is modified as follows:

  • If a record exists in the configuration package but doesn't exist in the target, then import creates the record.

  • If a record doesn't exist in the configuration package but exists in the target, then import doesn't modify the record in the target.

    Note:

    Import doesn't delete the records in the target that don't exist in the configuration package. You must delete these records or make them obsolete manually, if necessary.

  • If a record exists both in the configuration package and in the target, then:

    • If all attribute values are the same, import doesn't modify the record in the target.

    • If values of any attributes of the record are different, then import updates the record in the target with the values in the configuration package.

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 only used ifFDFSM_INP_COMPILE_FORMULAS 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_SOAP_COMPILATION

No

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 checkedone more fast formulas. Defaults to true. See special considerations section for additional Chrome browser dependency.

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.

...

Before using this plugin operation, navigate to Topology → Integrations → Cloud, then create an account with provider OracleFSM for each one of your SaaS environments. This account will store the URL and credentials to make HTTPS requests to your SaaS environment. The account will be reusable by all Oracle SaaS FSM Plugin operations. All fields shown are required.

...

Compile Fast Formulas - Compilation Methods used and optional Chrome Browser Dependency

If FDFSM_INP_COMPILE_FORMULAS is enabled, then compile is attempted for each Fast Formula object in the package. First, SOAP compilation is attempted. if that fails, the Oracle APIs to compile are used. If that fails with a 403, the plugin can optionally make a second attempt using a headless Chrome browser run through Selenium to compile from the Oracle SaaS UI. In the latter last 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.

...