Exports CSV File Package(s) 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.

Environment/Instance Properties

FDFSM_CLOUD_ACCOUNT_CODE

Project Properties

Inputs

FDFSM_INP_CLOUD_ACCOUNT_CODE

FDFSM_INP_TIMEOUT

FDFSM_INP_DOWNLOAD_FOLDER

FDFSM_INP_STOP_ON_ERROR

FDFSM_INP_JSON_FILE_PATH

Outputs

Artifacts

This operation does not produce any artifacts.

Endpoint Selection

This operation will select all available endpoints associated to the environment/instance.

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 will be required on either the input or environment instance. If a value is set on both then, the input will take precedence.

JSON File Path

csvDownloadAdvanced is expecting a file containing a json object with an array of data, which we call tasks. Recommendation is to name this file something along the lines of "FSMSetupTasks-Development" and give it an extension of .json. The "Development" postfix on the file name is to denote that these tasks will get exported from your Development Oracle SaaS FSM environment. Typically user will maintain one json file containing the below content because syncing to SCM process happens against one SaaS environment (Development in this case).

{
  "tasks" :
  [
    { 
      "TaskCode" : "PAY_MANAGE_FAST_FORMULA",
      "BusinessObjectCode" : "",
      "AttributeName" : "",
      "AttributeValue" : ""
    },
    {
      "TaskCode" : "PAY_MANAGE_FAST_FORMULA",
      "BusinessObjectCode" : "FF_FORMULA",
      "AttributeName" : "FormulaName1",
      "AttributeValue" : "EXT_ASSIGNMENTS_RECORD300000189455050_300000189455050"
    },
    {
      "TaskCode" : "PAY_MANAGE_FAST_FORMULA",
      "BusinessObjectCode" : "FF_FORMULA",
      "AttributeName" : "BaseFormulaName",
      "AttributeValue" : "EXT_BENEFITS_RECORD300000189455103_300000189455103##EXT_PERFORMANCES_RECORD300000189455100_300000189455100"
    },
    {
      "TaskCode" : "FUN_MANAGE_BUSINESS_UNIT",
      "BusinessObjectCode" : "FUN_BUSINESS_UNIT",
      "AttributeName" : "Name",
      "AttributeValue" : "AU Council Business Unit"
    },
    {
      "TaskCode" : "GL_MANAGE_CHART_OF_ACCOUNTS_VALUE_SETS",
      "BusinessObjectCode" : "",
      "AttributeName" : "",
      "AttributeValue" : "FlexDeploy Value Set Accounts##FlexDeploy Value Set Currencies"
    }
  ]
}

Referencing the above list of "tasks" one by one:

1. Downloads the entire Fast Formula task
   • Notice only TaskCode is set
2. Downloads the Fast Formula task scoped by Formula Name of EXT_ASSIGNMENTS_RECORD300000189455050_300000189455050
   • Notice all values are set and AttributeValue has only single value
3. Downloads the Fast Formula task scoped twice. Once scoped by base formula name of EXT_BENEFITS_RECORD300000189455103_300000189455103 and a second time scoped by base formula name of EXT_PERFORMANCES_RECORD300000189455100_300000189455100
   • When 2 more values are set (delimited by ##), then an individual CSV File package is downloaded for each value with respective scope applied.
4. Downloads the Manage Business Unit task scoped by Name of AU Council Business Unit
5. Downloads the Manage Chart of Accounts Value Set task twice. Once filtered by value set code of FlexDeploy Value Set Accounts and a second time filtered by value set code of FlexDeploy Value Set Currencies.

Format of the JSON objects within the "tasks" array require 4 key-value pairs. 

Download Folder Structure

csvDownloadAdvanced maintains the following folder structure convention when saving the CSV File packages to the file system:

If only FDFSM_INP_TASK_CODE input is provided: <FDFSM_INP_DOWNLOAD_FOLDER>/SetupTasks/<Name of the Setup Task>.zip

Otherwise: <FDFSM_INP_DOWNLOAD_FOLDER>/SetupTasks/<Name of the Setup Task>/<FDFSM_INP_ATTRIBUTE_VALUE>.zip

Example directory structure. Download folder in this example is "SAAS-FSM". Notice the CSV file packages, zip files, are under the "SetupTasks" folder if no scope fields (Business Object Codes, Attribute Name, and Attribute Value) are provided, otherwise, they will appear at the deepest level in the directory structure.