Exports CSV File Package(s) for single Setup Task from an Oracle SaaS FSM server to the file system. This operation can be used from an utility workflow, which can also be augmented to sync the files to a source control management system (such as Git or Subversion). This allows the Oracle SaaS FSM project which is used for build and deployment to source from a source code repository rather than directly from a development SaaS instance.
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, but the JSON packages will show as different files in SCM, so you may need to manually remove the old files if you use the operation both before and after upgrading between those versions. 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
TaskCodeis set toFND_MANAGE_VALUE_SETSThe
AttributeNameis set toValueSetCodeThe
AttributeValueis set to the ValueSetCode of the ValueSet that you wish to download.
Lookups are downloaded as JSON now instead of CSV if the following criteria are met:
The
TaskCodeis set to one ofFND_MANAGE_COMMON_LOOKUPS,FND_MANAGE_STANDARD_LOOKUPS, orFND_MANAGE_SET_ENABLED_LOOKUPSThe
AttributeNameis set toLookupTypeThe
AttributeValueis set to the LookupType of the Lookup that you wish to download.
| Warning |
|---|
LimitationThis operation is a simple export, meaning you can only export a single task or multiple subsets of a single task. Unlike other download operations, you cannot do export of all Setup Tasks in a single execution. To achieve similar functionality, see csvDownloadAdvance csvDownloadAdvanced which takes an input file to download more than a single Setup Task. |
...
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. |
...
Business Object Code, Attribute Name, and Attribute Value are all required when exporting any Setup Tasks with a scopable business object. In the special case of Value Set tasks (I.E. Manage Chart of Accounts Value Sets, Manage Applications Core Value Sets, Manage Purchasing Value Sets, etc..). only FDFSM_INP_ATTRIBUTE_VALUE input is required. You must provide the Value Set Code for the Value Set in order to download a subset of the Value Set. See below image as an example.
...
Download Folder Structure
...