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