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.
Target Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
Oracle SaaS FSM Account |
| 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 |
| No* | Location of the chromedriver executable. I.E. /usr/local/bin/chromedriver or C:/Users/user/Documents/chromedriver.exe. This is required if Defaults to /usr/local/bin/chromedriver 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 |
| 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 |
| 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 |
| 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 |
| No | Maximum amount of time (seconds) to wait for Compile Formula payroll flow to complete. Defaults to 300 seconds (5 minutes). | ||
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:
| ||
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 | ||
Save Import Report File |
| No | Saves a comparison report file to the report's directory as an Excel a HTML file. The excel HTML file provides comparison reports for each of the business objects that were processed. For | ||
Save Import Summary Report File |
| No | Saves a comparison report file to the report's directory as an Excel a HTML file. The excel HTML file provides a summary of the process results, which displays a list of all the processed |
...
| Code Block |
|---|
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
| Code Block |
|---|
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
...