Page Comparison

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

...

...

{
  "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. 

...

Key

...

Required

...

Description

...

TaskCode

...

Yes

...

Code of the Setup Task.

...

BusinessObjectCode

...

No*

...

Code of the business object whose attribute is used as the scope. Leave value empty to export entire Setup Task.

*Required to apply scope to Setup Task object type.

...

AttributeName

...

No*

...

Name of the attribute of the business object used as the scope. Leave value empty to export entire Setup Task.

*Required to apply scope to Setup Task object type.

...

AttributeValue

...

No*

...

Value of the named attribute that defines the filter criteria. Provide multiple values using ## I.E. VALUE1##VALUE2. Leave value empty to export entire Setup Task.

If you provide more than one value using ## separator, individual file for each value is downloaded.

*Required to apply scope to Setup Task object type. Otherwise, all supported non-Setup Task object type (I.E. Value Set, Lookups, or Flexfields), only Attribute Value and TaskCode are required. BusinessObjectCode and AttributeName can be left empty. See JSON object 5 example in FSMSetupTasks-Development.json

...

ExportCriteria

...

No*

...

{
      "TaskCode" : "FND_MANAGE_COMMON_LOOKUPS",
	  "ExportCriteria": [
        {
          "AttributeName" : "LookupType",
          "AttributeValue" : "ORA_PER_UNION_CODE",
        }
      ]
    },
    {
      "TaskCode" : "FND_MANAGE_VALUE_SETS",
	  "ExportCriteria": [
        {
          "AttributeName" : "ValueSetCode",
          "AttributeValue" : "AHC_CUST_CATEGORY",
        }
      ]
    }
  ]
}

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

3. Downloads the LookupType ORA_PER_UNION_CODE in JSON format.

4. Downloads the ValueSet AHC_CUST_CATEGORY is JSON format.

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

Another JSON format shown below will only allow for one export criteria to be configured. We suggest using the keys ExportCriteria and FilterCriteria instead. However, keep in mind using this format will add an additional part in the path. More on this later. If both formats exists, then the format explained above will take precedence.

...

...

Another JSON format shown below will only allow for one export criteria to be configured. We suggest using the keys ExportCriteria and FilterCriteria instead. However, keep in mind using this format will add an additional part in the path. More on this later. If both formats exists, then the format explained above will take precedence.

{
  "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" : "PAYFUN_MANAGE_FASTBUSINESS_FORMULAUNIT",
      "BusinessObjectCode" : "FFFUN_BUSINESS_FORMULAUNIT",
      "AttributeName" : "FormulaName1Name",
      "AttributeValue" : "EXT_ASSIGNMENTS_RECORD300000189455050_300000189455050AU Council Business Unit"
    },
    {
      "TaskCode" : "PAYGL_MANAGE_FAST_FORMULA_CHART_OF_ACCOUNTS_VALUE_SETS",
      "BusinessObjectCode" : "FF_FORMULA",
      "AttributeName" : "BaseFormulaName",
      "AttributeValue" : "EXT_BENEFITS_RECORD300000189455103_300000189455103##EXT_PERFORMANCES_RECORD300000189455100_300000189455100"
    },
FlexDeploy Value Set Accounts##FlexDeploy Value Set Currencies"
   { },
     "TaskCode" : "FUN_MANAGE_BUSINESS_UNIT", {
      "BusinessObjectCodeTaskCode" : "FUNFND_MANAGE_BUSINESSCOMMON_UNITLOOKUPS",
      "AttributeName" : "NameLookupType",
      "AttributeValue" : "AU Council Business UnitORA_PER_UNION_CODE"
    },
    {
      "TaskCode" : "GL_MANAGE_CHART_OF_ACCOUNTS_VALUE_SETS",{
      "BusinessObjectCodeTaskCode" : "FND_MANAGE_VALUE_SETS",
      "AttributeName" : "ValueSetCode",
      "AttributeValue" : "FlexDeploy Value Set Accounts##FlexDeploy Value Set CurrenciesAHC_CUST_CATEGORY"
    }
  ]
}

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.

6. Downloads Lookup ORA_PER_UNION_CODE using the JSON format.

7. Downloads ValueSet AHC_CUST_CATEGORY using the JSON format.

Download Folder Structure

...