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

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 cloud 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. You can manage the Oracle SaaS cloud account via the Integrations > Cloud page. See Configuring Oracle SaaS Cloud Account for additional details.
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 if `FDFSM_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.

Property Name

Property Code

Required

Description

Oracle SaaS FSM Account

FDFSM_CLOUD_ACCOUNT_CODE

No*

Oracle SaaS cloud 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.

You can manage the Oracle SaaS cloud account via the Integrations > Cloud page.

See Configuring Oracle SaaS Cloud Account for additional details.

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 if FDFSM_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.

Project Properties

Property Name	Property Code	Required	Description
Stop on Deployment Error	`FDFSM_STOP_ON_ERROR`	No	Stop deploying package files if any error occurs. If unchecked all files will be deployed even if one or more files fails. Defaults to true.

Inputs

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

Artifacts

This operation consumes artifacts from the artifacts repository.

Endpoint Selection

This operation will select all available endpoints associated to the Target.

Endpoint Execution

This operation will execute on any one of the selected endpoints and will be random in the determination of which one.

Special Considerations

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

Google Chrome Install

// (Option 1) With yum for RedHat-based Linux Distributions i.e. AlmaLinux, CentOS, Fedora, RedHat, Rocky Linux
yum -y install google-chrome-stable_current_x86_64.rpm

// If you get cannot open rpm error (Can not load RPM file: google-chrome-stable_current_x86_64.rpm) you can instead just download the rpm itself and then install with the file
wget https://dl.google.com/linux/direct/google-chrome-stable_current_x86_64.rpm
yum install ./google-chrome-stable_current_*.rpm

// If you run into errors you may need to clear the yum cache or update yum
yum clean all
rm -r /var/cache/yum
yum -y update

// If you get error like 'Invalid configuration value: failovermethod=priority in /etc/yum.repos.d/nodesource-el8.repo; Configuration: OptionBinding with id "failovermethod" does not exist'
// Go to /etc/yum.repos.d/nodesource-el8.repo and comment out the 'failovermethod' entries
cat /etc/yum.repos.d/nodesource-el8.repo
[nodesource]
name=Node.js Packages for Enterprise Linux 8 - $basearch
baseurl=https://rpm.nodesource.com/pub_14.x/el/8/$basearch
#failovermethod=priority
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/NODESOURCE-GPG-SIGNING-KEY-EL

[nodesource-source]
name=Node.js for Enterprise Linux 8 - $basearch - Source
baseurl=https://rpm.nodesource.com/pub_14.x/el/8/SRPMS
#failovermethod=priority
enabled=0
gpgkey=file:///etc/pki/rpm-gpg/NODESOURCE-GPG-SIGNING-KEY-EL
gpgcheck=1

// (Option 2) With dpkg
wget https://dl.google.com/linux/direct/google-chrome-stable_current_amd64.deb
sudo dpkg -i google-chrome-stable_current_amd64.deb

Test Google Chrome installation

google-chrome &

Chromedriver Install

Download the chromedriver from https://chromedriver.chromium.org/downloads which is supported for the google chrome version installed on your endpoint. Linux, mac, and windows binaries are available. Where you store the chromedriver executable should set on target property Oracle SaaS FSM ChromeDriver Path.

wget https://chromedriver.storage.googleapis.com/107.0.5304.62/chromedriver_linux64.zip
unzip chromedriver_linux64.zip
// Suggest moving the chromedriver somewhere like /usr/local/bin
// mv chromedriver /usr/local/bin

FSM Setup Task Import Reports

CSVImport can generate additional reports and log files which are viewable and downloadable from workflow execution → reports tab. The .log file will always be a generated report. Keep in mind, the contents of the .log file will also be outputted to the plugin log file. Additional reports that can be generated include:

<TASK_CODE>_ProcessResultsSummaryReport_<EXPORT_DATE_TIME>.html - A high level overview of the number of objects exported and the execution time
<TASK_CODE>_ProcessResultsReport_<EXPORT_DATE_TIME>.html - A high level overview of the objects imported by business object and the execution time for each
<TASK_CODE>_ProcessResult _<EXPORT_DATE_TIME>.json - The response body from the Import API after export has completed. This is generally not used but provided regardless.

To include any of the additional reports, you must enable those in the csvImport workflow operation.

Example reports: AP_MANAGE_TAX_CODES_ProcessLog_20231211_153950_0415.log

The import process was initiated calling the import API as indicated below. Import operation: submitTaskCSVImport.Request ID: 7,185,711. Status: In progress. Submitted By: CURTIS.FEITTY. Process Date: 12/11/23 9:37 PM.

Business object: Business Unit GCO Tax Subscription. Status: Completed successfully. Status details: 
	Detail Object: TaxRegime. Status: Completed successfully. Status Details: A total of 1 rows were processed. 0 rows of them failed and 0 rows completed with warnings.. Started: 12/11/23 9:38 PM. Ended: 12/11/23 9:38 PM.
	Detail Object: BusinessUnitTaxProfile. Status: Completed successfully. Status Details: A total of 80 rows were processed. 0 rows of them failed and 0 rows completed with warnings.. Started: 12/11/23 9:38 PM. Ended: 12/11/23 9:38 PM.

Business object: Business Unit Regime Subscription Detail. Status: Completed successfully. Status details: This object was already processed. The import or export details were listed under the Business Unit GCO Tax Subscription business object.

Business object: Business Unit Tax Regime Profile. Status: Completed successfully. Status details: This object was already processed. The import or export details were listed under the Business Unit GCO Tax Subscription business object.

Business object: Business Unit Regime Usage. Status: Completed successfully. Status details: This object was already processed. The import or export details were listed under the Business Unit GCO Tax Subscription business object.

Business object: Tax Regime Subscription Exclusion. Status: Completed successfully. Status details: This object was already processed. The import or export details were listed under the Business Unit GCO Tax Subscription business object.

Business object: Transaction Tax Threshold Schedule Control. Status: In progress. Status details: 
	Detail Object: TransactionTax. Status: Completed successfully. Status Details: A total of 1 rows were processed. 0 rows of them failed and 0 rows completed with warnings.. Started: 12/11/23 9:38 PM. Ended: 12/11/23 9:38 PM.

Business object: Transaction Tax Threshold Schedule Control. Status: In progress. Status details: 
	Detail Object: TaxJurisdiction. Status: Completed successfully. Status Details: A total of 0 rows were processed. 0 rows of them failed and 0 rows completed with warnings.. Started: 12/11/23 9:39 PM. Ended: 12/11/23 9:39 PM.
	Detail Object: TransactionTax. Status: Completed successfully. Status Details: A total of 1 rows were processed. 0 rows of them failed and 0 rows completed with warnings.. Started: 12/11/23 9:38 PM. Ended: 12/11/23 9:38 PM.

Business object: Transaction Tax Threshold Schedule Control. Status: Completed successfully. Status details: 
	Detail Object: TaxSettlementAuthorityVO. Status: Completed successfully. Status Details: A total of 1 rows were processed. 0 rows of them failed and 0 rows completed with warnings.. Started: 12/11/23 9:39 PM. Ended: 12/11/23 9:39 PM.
	Detail Object: TaxJurisdiction. Status: Completed successfully. Status Details: A total of 0 rows were processed. 0 rows of them failed and 0 rows completed with warnings.. Started: 12/11/23 9:39 PM. Ended: 12/11/23 9:39 PM.
	Detail Object: TransactionTax. Status: Completed successfully. Status Details: A total of 1 rows were processed. 0 rows of them failed and 0 rows completed with warnings.. Started: 12/11/23 9:38 PM. Ended: 12/11/23 9:38 PM.

Business object: Transaction Default Tax Account. Status: Completed successfully. Status details: This object was already processed. The import or export details were listed under the Transaction Tax Threshold Schedule Control business object.

Business object: Transaction Jurisdiction Default Tax Account. Status: Completed successfully. Status details: This object was already processed. The import or export details were listed under the Transaction Tax Threshold Schedule Control business object.

Business object: Transaction Tax Jurisdiction. Status: Completed successfully. Status details: This object was already processed. The import or export details were listed under the Transaction Tax Threshold Schedule Control business object.

Business object: Transaction Tax Threshold Schedule. Status: Completed successfully. Status details: This object was already processed. The import or export details were listed under the Transaction Tax Threshold Schedule Control business object.

Business object: Transaction Tax. Status: Completed successfully. Status details: This object was already processed. The import or export details were listed under the Transaction Tax Threshold Schedule Control business object.

Business object: Tax Regime. Status: Completed successfully. Status details: This object was already processed. The import or export details were listed under the Business Unit GCO Tax Subscription business object.

Total Objects Processed: 12

Total Objects Succeeded: 12

Total Objects Failed: 0

Total Objects with Warnings: 0

Total Objects for External Loading: 0

Request ID: 7,185,711. Status: Completed successfully. Submitted By: CURTIS.FEITTY. Process Date: 12/11/23 9:39 PM.

AP_MANAGE_TAX_CODES_ProcessResultsSummaryReport_20231211_153950_0415.html

AP_MANAGE_TAX_CODES_ProcessResultsReport_20231211_153950_0415.html

FlexDeploy 10.0 Documentation

​Setup Data Update Rules During Import

​Target Properties

​Project Properties

​Inputs

​Artifacts

​Endpoint Selection

​Endpoint Execution

​Special Considerations

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

​Google Chrome Install

​Chromedriver Install

​FSM Setup Task Import Reports