Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Exports CSV File Package(s) from an Oracle SaaS FSM server to the file system. This operation can be used from a 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.

...

Property Name

Property Code

Required

Description

Oracle SaaS FSM Account

FDFSM_CLOUD_ACCOUNT_CODE

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.

...

Code Block
languagejava
{
  "tasks": 
  [
	{
      "TaskCode" : "XLE_MANAGE_LEGAL_ENTITY",
	  "ExportCriteria": [
        {
          "BusinessObjectCode" : "XLE_ENTITY_PROFILE",
          "AttributeName" : "LegalEntityIdentifier",
          "AttributeValue" : "LE_AU_01",
        }
      ]
    },
	{
      "TaskCode" : "PAY_MANAGE_FAST_FORMULA",
      "FilterCriteria": [
	  	{
          "BusinessObjectCode" : "FF_FORMULA",
          "Operator" : "Equals",
          "AttributeName" : "FormulaName",
          "AttributeValue" : "MANAGER RANGE OF SCHEDULED HOURS",
        }
	  ]
    }
  ]
}

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

  1. Downloads the Manage Legal Entity task where XLE_ENTITY_PROFILE column LegalEntityIdentifer is equal to LE_AU_01.

    • File path where this file to be downloaded is /SetupTasks/XLE_MANAGE_LEGAL_ENTITY/LE_AU_01.zip

  2. Downloads the Fast Formulas task where FF_FORMULA column FormulaName is equal to MANAGER RANGE OF SCHEDULED HOURS.

    • File path where this file to be downloaded is /SetupTasks/PAY_MANAGE_FAST_FORMULA/MANAGER_RANGE_OF_SCHEDULED_HOURS.zip

The JSON objects within the "tasks" array can contain these 7 keys. 

...

Info

If the JSON format is used with ExportCriteria and FilterCriteria, then the ValueSets, Lookups, Flexfields, and FastFormulas part will not be added to the path. This is both for simplicity and only the listed because only the SetupTask object type supports filter criteria (ValueSets, FastFormulas, Lookups, and Flexfields object types do not support filter criteria on a FSM projectFilter Criteria) and also for simplicity.

Inputs Provided

Output File

Only FDFSM_INP_TASK_CODE is provided

<FDFSM_INP_DOWNLOAD_FOLDER>/SetupTasks/<FDFSM_INP_TASK_CODE>.zip

If FDFSM_INP_TASK_CODE and FDFSM_INP_ATTRIBUTE_VALUE is provided

<FDFSM_INP_DOWNLOAD_FOLDER>/SetupTasks/<FDFSM_INP_TASK_CODE>/<FDFSM_INP_ATTRIBUTE_VALUE>.zip

If FDFSM_INP_TASK_CODE and FDFSM_INP_ATTRIBUTE_VALUE is provided,

and task is ValueSet related

<FDFSM_INP_DOWNLOAD_FOLDER>/SetupTasks/ValueSets/<FDFSM_INP_TASK_CODE>/<FDFSM_INP_ATTRIBUTE_VALUE>.zip

If FDFSM_INP_TASK_CODE and FDFSM_INP_ATTRIBUTE_VALUE is provided,

and task is Lookup related

<FDFSM_INP_DOWNLOAD_FOLDER>/SetupTasks/Lookups/<FDFSM_INP_TASK_CODE>/<FDFSM_INP_ATTRIBUTE_VALUE>.zip

If FDFSM_INP_TASK_CODE and FDFSM_INP_ATTRIBUTE_VALUE is provided,

and task is FlexField related

<FDFSM_INP_DOWNLOAD_FOLDER>/SetupTasks/Flexfields/<FDFSM_INP_TASK_CODE>/<FDFSM_INP_ATTRIBUTE_VALUE>.zip

If FDFSM_INP_TASK_CODE and FDFSM_INP_ATTRIBUTE_VALUE is provided,

and task is Fast Formula related

<FDFSM_INP_DOWNLOAD_FOLDER>/SetupTasks/FastFormulas/<FDFSM_INP_TASK_CODE>/<FDFSM_INP_ATTRIBUTE_VALUE>.zip

...