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.
As of 6.5.0.20, 7.0.0.11, 8.0.0.6, and 9.0.0.0, this operation will export some files as json files, and others as CSV files. Both can be uploaded successfully by the import operation. The types of files that are now downloaded as JSON instead of CSV are a subset of Value Sets and Lookups. The JSON download is much faster and smaller than the CSV one is. The resolves several issues that customers brought up where value sets and look ups were not exported properly due to file size restrictions in the export process.
Value Sets are downloaded as JSON now instead of CSV if the following criteria are met:
...
The
Typeis set toValue SetThe
TaskCodeis set toFND_MANAGE_VALUE_SETSThe
ValueSetCode AttributeValueis set to the ValueSetCode of the ValueSet that you wish to download.
These criteria are met for the auto-discovered Value Sets.
Lookups are downloaded as JSON now instead of CSV if the following criteria are met:
...
The
Typeis set toLookupsThe
TaskCodecan be set to any of the following:FND_MANAGE_SET_ENABLED_LOOKUPS, FND_MANAGE_COMMON_LOOKUPS, or FND_MANAGE_STANDARD_LOOKUPS.The
Lookup Typeis set to the LookupType of the Lookup that you wish to download.
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. |
...
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 6.5.0.14 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.
...
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
| Code Block |
|---|
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?
...