This operation exports file(s) from the build Oracle SaaS environment or your SCM repository, waits for all exports processes to complete, and then downloads results as a single zip file artifact. The csvExport operation can only be used with a FlexDeploy package-based deployment project of type Oracle SaaS FSM.
Artifact is a single zip file containing zipped CSV File Packages.
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. |
Inputs
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 export process to complete after it is started. Defaults to 900 seconds (15 minutes). |
Save Export 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 Export Report File |
| No | Saves a comparison report file to the reports 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 Export Summary Report File |
| No | Saves a comparison report file to the reports 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. |
Filter Criteria Preview Mode |
| No | @since 7.0.0.2 When enabled no artifacts, CSV file package(s), will be generated. Instead before and after zip files will be provided in FD_REPORTS_DIR along with diff and unified diff files to validate filter criteria behavior. Make sure this is disabled at build time if you wish to deploy setup changes. Defaults to false. |
Artifacts
This operation produces artifacts that will be stored in 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
Oracle SaaS FSM Account*
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.
See Object Type - Setup Task, Oracle SaaS FSM Object Type - Fast Formula, Oracle SaaS FSM Object Type - Value Set, etc.. for details on how to configure Files for export.
FSM Setup Task Export Reports
CSVExport 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 exported by business object and the execution time for each
<TASK_CODE>_ProcessResult _<EXPORT_DATE_TIME>.json - The response body from the Export 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 csvExport workflow operation.
Example reports:
XLE_MANAGE_LEGAL_REPORTING_UNIT_ProcessLog_20231208_123744_0831.log
The export operation was initiated calling the export API as indicated below. Export operation: submitTaskCSVExport.Request ID: 7,176,630. Status: In progress. Submitted By: CURTIS.FEITTY. Process Date: 12/8/23 6:36 PM. The implementation project Manage Legal Reporting Unit_20231208_063617_114 was exported successfully. Business object: Legal Reporting Unit. Status: In progress. Status details: Detail Object: LegalLocation. Status: Completed successfully. Status Details: A total of 98 rows were processed. 0 rows of them failed and 0 rows completed with warnings.. Started: 12/8/23 6:36 PM. Ended: 12/8/23 6:36 PM. Business object: Legal Reporting Unit. Status: Completed successfully. Status details: Detail Object: LegalEntityData. Status: Completed successfully. Status Details: A total of 2 rows were processed. 0 rows of them failed and 0 rows completed with warnings.. Started: 12/8/23 6:37 PM. Ended: 12/8/23 6:37 PM. Detail Object: LegalLocation. Status: Completed successfully. Status Details: A total of 98 rows were processed. 0 rows of them failed and 0 rows completed with warnings.. Started: 12/8/23 6:36 PM. Ended: 12/8/23 6:36 PM. Total Objects Processed: 1 Total Objects Succeeded: 1 Total Objects Failed: 0 Total Objects with Warnings: 0 Total Objects for External Loading: 0 Request ID: 7,176,630. Status: Completed successfully. Submitted By: CURTIS.FEITTY. Process Date: 12/8/23 6:37 PM.
XLE_MANAGE_LEGAL_REPORTING_UNIT_ProcessResultsSummaryReport_20231208_123744_0831.html
XLE_MANAGE_LEGAL_REPORTING_UNIT_ProcessResultsReport_20231208_123744_0831.html
How to find Task Code for a Setup Task?
To initiate the export or import process, Oracle endpoints requires providing a code for the task. Following these instructions to find the Task Code. We are assuming you have access to FSM resource.
Click Navigator > My Enterprise > Setup and Maintenance.
In the Setup and Maintenance work area, click Manage Setup Content from the Tasks panel tab.
To search for the code of a task
On the Manage Setup Content page, click Manage Task Lists and Tasks.
In the Search field, select Tasks and click Search.
In the search results, click the name of the task.
On the Task page, look for value that appears against Code.
Copy the code and use it where necessary