{"type":"doc","content":[{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"paragraph","content":[{"text":"As of 6.5.0.20, 7.0.0.11, 8.0.0.6, and 9.0.0.0, this operation will source 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.","type":"text"}]},{"type":"paragraph","content":[{"text":"Value Sets are downloaded as JSON now instead of CSV if the following criteria are met:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"TaskCode","type":"text","marks":[{"type":"code"}]},{"text":" is set to ","type":"text"},{"text":"FND_MANAGE_VALUE_SETS","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"AttributeName","type":"text","marks":[{"type":"code"}]},{"text":" is set to ","type":"text"},{"text":"ValueSetCode","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"AttributeValue","type":"text","marks":[{"type":"code"}]},{"text":" is set to the ValueSetCode of the ValueSet that you wish to download. ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Lookups are downloaded as JSON now instead of CSV if the following criteria are met:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"TaskCode","type":"text","marks":[{"type":"code"}]},{"text":" is set to one of ","type":"text"},{"text":"FND_MANAGE_SET_ENABLED_LOOKUPS","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text"},{"text":"FND_MANAGE_COMMON_LOOKUPS","type":"text","marks":[{"type":"code"}]},{"text":", or ","type":"text"},{"text":"FND_MANAGE_STANDARD_LOOKUPS","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"AttributeName","type":"text","marks":[{"type":"code"}]},{"text":" is set to ","type":"text"},{"text":"LookupType","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"AttributeValue","type":"text","marks":[{"type":"code"}]},{"text":" is set to the LookupType of the Lookup that you wish to download. ","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"success"},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Endpoint Tip","type":"text"}]},{"type":"paragraph","content":[{"text":"This operation uses HTTPS to communicate remotely to the Oracle SaaS FSM server, and therefore, can be executed on any endpoint (including LOCALHOST).","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Target Properties","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","width":1800.0,"localId":"500def83-42ec-4b22-ba74-89d6c5b42aef"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[236.0]},"content":[{"type":"paragraph","content":[{"text":"Property Name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[288.0]},"content":[{"type":"paragraph","content":[{"text":"Property Code","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[99.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[615.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.0]},"content":[{"type":"paragraph","content":[{"text":"Oracle SaaS FSM Account","type":"text","marks":[{"type":"textColor","attrs":{"color":"#4f4f4f"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[288.0]},"content":[{"type":"paragraph","content":[{"text":"FDFSM_CLOUD_ACCOUNT_CODE","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[99.0]},"content":[{"type":"paragraph","content":[{"text":"No*","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[615.0]},"content":[{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"paragraph","content":[{"text":"See Special Considerations below for instructions on how to create Oracle SaaS FSM account.","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Inputs","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","width":1800.0,"localId":"698ae9e4-609b-48b0-84ee-ba60a11bbfab"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"Input Name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[320.0]},"content":[{"type":"paragraph","content":[{"text":"Input Code","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[108.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#f4f5f7","rowspan":1,"colwidth":[675.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"Oracle SaaS FSM Account","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[320.0]},"content":[{"type":"paragraph","content":[{"text":"FDFSM_INP_CLOUD_ACCOUNT_CODE","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[108.0]},"content":[{"type":"paragraph","content":[{"text":"No*","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[675.0]},"content":[{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"paragraph","content":[{"text":"See Special Considerations below for instructions on how to create Oracle SaaS FSM account.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"API Timeout","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[320.0]},"content":[{"type":"paragraph","content":[{"text":"FDFSM_INP_TIMEOUT","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[108.0]},"content":[{"type":"paragraph","content":[{"text":"No","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[675.0]},"content":[{"type":"paragraph","content":[{"text":"Maximum amount of time (seconds) to wait for export process to complete after it is started. Defaults to 900 seconds (15 minutes).","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"Download Folder","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[320.0]},"content":[{"type":"paragraph","content":[{"text":"FDFSM_INP_DOWNLOAD_FOLDER","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[108.0]},"content":[{"type":"paragraph","content":[{"text":"No","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[675.0]},"content":[{"type":"paragraph","content":[{"text":"Absolute or relative target folder path. Relative path will be assumed in FD_TEMP_DIR.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"Stop on Error","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[320.0]},"content":[{"type":"paragraph","content":[{"text":"FDFSM_INP_STOP_ON_ERROR","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[108.0]},"content":[{"type":"paragraph","content":[{"text":"No","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[675.0]},"content":[{"type":"paragraph","content":[{"text":"Stop exporting CSV File Package, if any error occurs. If false or not specified, exporting of other CSV File Packages will continue. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"JSON File Path","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[320.0]},"content":[{"type":"paragraph","content":[{"text":"FDFSM_INP_JSON_FILE_PATH","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[108.0]},"content":[{"type":"paragraph","content":[{"text":"Yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[675.0]},"content":[{"type":"paragraph","content":[{"text":"A list of tasks for export expressed as a JSON object. The JSON must contain a json array called “tasks”. See special considerations for details.","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"The value can directly be a JSON array or an absolute/relative path to a JSON file. If the first line begins with '@' then it assumed to be path to a file and try to load that. For example, @DEV_CSV_File_Packages.conf.","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Relative paths will be assumed in FD_TEMP_DIR. ","type":"text"}]},{"type":"paragraph","content":[{"text":"The JSON file can either be","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Extract JSON File from SCM","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use absolute path to location on server. (Not recommended as it requires manual setup on server)","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"See special considerations for more information about format and contents of JSON File Path.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"Extract CSV File Package","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[320.0]},"content":[{"type":"paragraph","content":[{"text":"FDFSM_INP_EXTRACT_CSV","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[108.0]},"content":[{"type":"paragraph","content":[{"text":"Yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[675.0]},"content":[{"type":"paragraph","content":[{"text":"Optionally expand (unzip) the exported zip file. Default to true.","type":"text"}]},{"type":"paragraph","content":[{"text":"This is useful for developers or reviewers to view the content of the CSV file package (zip) in a SCM without needing to unarchive the file first.","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Artifacts","type":"text"}]},{"type":"paragraph","content":[{"text":"This operation does not produce any artifacts.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Endpoint Selection","type":"text"}]},{"type":"paragraph","content":[{"text":"This operation will select all available endpoints associated to the Target.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Endpoint Execution","type":"text"}]},{"type":"paragraph","content":[{"text":"This operation will execute on any one of the selected endpoints and will be random in the determination of which one.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Special Considerations","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Oracle SaaS FSM Account*","type":"text"}]},{"type":"paragraph","content":[{"text":"Before using this plugin operation, navigate to Topology → Integrations → Cloud, then create an account with provider ","type":"text"},{"text":"OracleFSM ","type":"text","marks":[{"type":"strong"}]},{"text":"for each one of your SaaS environments. This account will store the URL and credentials to make HTTPS requests to your SaaS environment. The account will be reusable by all Oracle SaaS FSM Plugin operations. All fields shown are required.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":1080,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"id":"0ce8e97b-b6f1-49b6-a1f2-58cdc73ad6bb","collection":"contentId-10561720897","type":"file","height":922}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"JSON File Path","type":"text"}]},{"type":"paragraph","content":[{"text":"csvDownloadAdvanced is expecting a file containing a ","type":"text"},{"text":"json object","type":"text","marks":[{"type":"link","attrs":{"href":"https://www.w3schools.com/js/js_json_intro.asp"}}]},{"text":" 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 ","type":"text"},{"text":".json","type":"text","marks":[{"type":"strong"}]},{"text":". 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).","type":"text"}]},{"type":"paragraph","content":[{"text":"ExportCriteria and FilterCriteria are supported in the json file. This will allow for multiple export or filter criteria to be configured.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"java"},"content":[{"text":"{\n \"tasks\": \n [\n\t{\n \"TaskCode\" : \"XLE_MANAGE_LEGAL_ENTITY\",\n\t \"ExportCriteria\": [\n {\n \"BusinessObjectCode\" : \"XLE_ENTITY_PROFILE\",\n \"AttributeName\" : \"LegalEntityIdentifier\",\n \"AttributeValue\" : \"LE_AU_01\",\n }\n ]\n },\n\t{\n \"TaskCode\" : \"PAY_MANAGE_FAST_FORMULA\",\n \"FilterCriteria\": [\n\t \t{\n \"BusinessObjectCode\" : \"FF_FORMULA\",\n \"Operator\" : \"Equals\",\n \"AttributeName\" : \"FormulaName\",\n \"AttributeValue\" : \"MANAGER RANGE OF SCHEDULED HOURS\",\n }\n\t ]\n },\n {\n \"TaskCode\" : \"FND_MANAGE_COMMON_LOOKUPS\",\n\t \"ExportCriteria\": [\n {\n \"AttributeName\" : \"LookupType\",\n \"AttributeValue\" : \"ORA_PER_UNION_CODE\",\n }\n ]\n },\n {\n \"TaskCode\" : \"FND_MANAGE_VALUE_SETS\",\n\t \"ExportCriteria\": [\n {\n \"AttributeName\" : \"ValueSetCode\",\n \"AttributeValue\" : \"AHC_CUST_CATEGORY\",\n }\n ]\n }\n ]\n}","type":"text"}]},{"type":"paragraph","content":[{"text":"Referencing the above list of \"tasks\" one by one:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Downloads the Manage Legal Entity task where XLE_ENTITY_PROFILE column LegalEntityIdentifer is equal to ","type":"text"},{"text":"LE_AU_01","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"File path where this file to be downloaded is /SetupTasks/XLE_MANAGE_LEGAL_ENTITY/LE_AU_01.zip ","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Downloads the Fast Formulas task where FF_FORMULA column FormulaName is equal to ","type":"text"},{"text":"MANAGER RANGE OF SCHEDULED HOURS","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"File path where this file to be downloaded is /SetupTasks/PAY_MANAGE_FAST_FORMULA/MANAGER_RANGE_OF_SCHEDULED_HOURS.zip","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Downloads the LookupType ","type":"text"},{"text":"ORA_PER_UNION_CODE","type":"text","marks":[{"type":"code"}]},{"text":" in JSON format.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Downloads the ValueSet ","type":"text"},{"text":"AHC_CUST_CATEGORY","type":"text","marks":[{"type":"code"}]},{"text":" is JSON format.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"The JSON objects within the \"tasks\" array can contain these 7 keys. ","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","width":1800.0,"localId":"3cb73378-013a-443e-933b-674549658940"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"Key","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1038.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"TaskCode","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":"Yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1038.0]},"content":[{"type":"paragraph","content":[{"text":"Code of the Setup Task.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"BusinessObjectCode","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":"No*","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1038.0]},"content":[{"type":"paragraph","content":[{"text":"Code of the business object whose attribute is used as the scope. Leave value empty to export entire Setup Task.","type":"text"}]},{"type":"paragraph","content":[{"text":"*Required to apply scope to Setup Task object type.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"AttributeName","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":"No*","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1038.0]},"content":[{"type":"paragraph","content":[{"text":"Name of the attribute of the business object used as the scope. Leave value empty to export entire Setup Task.","type":"text"}]},{"type":"paragraph","content":[{"text":"*Required to apply scope to Setup Task object type.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"AttributeValue","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":"No*","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1038.0]},"content":[{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"paragraph","content":[{"text":"If you provide more than one value using ## separator, individual file for each value is downloaded.","type":"text"}]},{"type":"paragraph","content":[{"text":"*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","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"ExportCriteria","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":"No*","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1038.0]},"content":[{"type":"paragraph","content":[{"text":"List of criteria objects applied at export time. This is configured in the same fashion as the export criteria on a packaged-based FSM project, see ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://flexagon.atlassian.net/wiki/spaces/FD80/pages/10556413502/Oracle+SaaS+FSM+Object+Type+-+Setup+Task#Export-Criteria"}},{"text":" for more details.","type":"text"}]},{"type":"paragraph","content":[{"text":"Each export criteria object requires the following key-value pairs:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"BusinessObjectCode","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"AttributeName","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"AttributeValue","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"If any of the keys or values are missing csvDownloadAdvanced will throw a validation error.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[258.0]},"content":[{"type":"paragraph","content":[{"text":"FilterCriteria","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[91.0]},"content":[{"type":"paragraph","content":[{"text":"No*","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1038.0]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"List of criteria object applied post export for additional filtering. This is configured in the same fashion as the filter criteria configured on a packaged-based FSM project, see ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://flexagon.atlassian.net/wiki/spaces/FD80/pages/10556413502/Oracle+SaaS+FSM+Object+Type+-+Setup+Task#Filter-Criteria"}},{"text":" for more details.","type":"text"}]},{"type":"paragraph","content":[{"text":"Each filter criteria object requires the following key-value pairs:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"BusinessObjectCode","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Operator","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"See ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://flexagon.atlassian.net/wiki/spaces/FD80/pages/10556413502/Oracle+SaaS+FSM+Object+Type+-+Setup+Task#Filter-Criteria-Operators"}},{"text":" for the list of valid options","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"AttributeName","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"AttributeValue","type":"text"}]}]}]}]}]}]},{"type":"paragraph","content":[{"text":"Another JSON format shown below will only allow for one export criteria to be configured. We suggest using the keys ","type":"text"},{"text":"ExportCriteria","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"FilterCriteria","type":"text","marks":[{"type":"code"}]},{"text":" 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.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"java"},"content":[{"text":"{\n \"tasks\" :\n [\n {\n \"TaskCode\" : \"PAY_MANAGE_FAST_FORMULA\",\n \"BusinessObjectCode\" : \"\",\n \"AttributeName\" : \"\",\n \"AttributeValue\" : \"\"\n },\n {\n \"TaskCode\" : \"PAY_MANAGE_FAST_FORMULA\",\n \"BusinessObjectCode\" : \"FF_FORMULA\",\n \"AttributeName\" : \"FormulaName1\",\n \"AttributeValue\" : \"EXT_ASSIGNMENTS_RECORD300000189455050_300000189455050\"\n },\n {\n \"TaskCode\" : \"PAY_MANAGE_FAST_FORMULA\",\n \"BusinessObjectCode\" : \"FF_FORMULA\",\n \"AttributeName\" : \"BaseFormulaName\",\n \"AttributeValue\" : \"EXT_BENEFITS_RECORD300000189455103_300000189455103##EXT_PERFORMANCES_RECORD300000189455100_300000189455100\"\n },\n {\n \"TaskCode\" : \"FUN_MANAGE_BUSINESS_UNIT\",\n \"BusinessObjectCode\" : \"FUN_BUSINESS_UNIT\",\n \"AttributeName\" : \"Name\",\n \"AttributeValue\" : \"AU Council Business Unit\"\n },\n {\n \"TaskCode\" : \"GL_MANAGE_CHART_OF_ACCOUNTS_VALUE_SETS\",\n \"BusinessObjectCode\" : \"\",\n \"AttributeName\" : \"\",\n \"AttributeValue\" : \"FlexDeploy Value Set Accounts##FlexDeploy Value Set Currencies\"\n },\n {\n \"TaskCode\" : \"FND_MANAGE_COMMON_LOOKUPS\",\n \"AttributeName\" : \"LookupType\",\n \"AttributeValue\" : \"ORA_PER_UNION_CODE\"\n },\n {\n \"TaskCode\" : \"FND_MANAGE_VALUE_SETS\",\n \"AttributeName\" : \"ValueSetCode\",\n \"AttributeValue\" : \"AHC_CUST_CATEGORY\"\n }\n ]\n}","type":"text"}]},{"type":"paragraph","content":[{"text":"Referencing the above list of \"tasks\" one by one:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Downloads the entire Fast Formula task","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Notice only TaskCode is set","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Downloads the Fast Formula task scoped by Formula Name of ","type":"text"},{"text":"EXT_ASSIGNMENTS_RECORD300000189455050_300000189455050","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Notice all values are set and AttributeValue has only single value","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Downloads the Fast Formula task scoped twice. Once scoped by base formula name of ","type":"text"},{"text":"EXT_BENEFITS_RECORD300000189455103_300000189455103 ","type":"text","marks":[{"type":"strong"}]},{"text":"and a second time scoped by base formula name of ","type":"text"},{"text":"EXT_PERFORMANCES_RECORD300000189455100_300000189455100","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"When 2 more values are set (delimited by ##), then an individual CSV File package is downloaded for each value with respective scope applied.","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Downloads the Manage Business Unit task scoped by Name of ","type":"text"},{"text":"AU Council Business Unit","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Downloads the Manage Chart of Accounts Value Set task twice. Once filtered by value set code of ","type":"text"},{"text":"FlexDeploy Value Set Accounts","type":"text","marks":[{"type":"strong"}]},{"text":" and a second time filtered by value set code of ","type":"text"},{"text":"FlexDeploy Value Set Currencies","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Download Folder Structure","type":"text"}]},{"type":"paragraph","content":[{"text":"csvDownloadAdvanced maintains the following folder structure convention when saving the CSV File packages to the file system:","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"If the JSON format is used with ","type":"text"},{"text":"ExportCriteria","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"FilterCriteria","type":"text","marks":[{"type":"code"}]},{"text":", then the ValueSets, Lookups, Flexfields, and FastFormulas part will not be added to the path. This is because only the SetupTask object type supports filter criteria (ValueSets, FastFormulas, Lookups, and Flexfields object types do not support Filter Criteria) and also for simplicity.","type":"text"}]}]},{"type":"table","attrs":{"layout":"full-width","width":1800.0,"localId":"3699e058-4a3d-4149-a580-2dd82109086c"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[86.0]},"content":[{"type":"paragraph","content":[{"text":"Inputs Provided","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[747.0]},"content":[{"type":"paragraph","content":[{"text":"Output File","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[86.0]},"content":[{"type":"paragraph","content":[{"text":"Only FDFSM_INP_TASK_CODE is provided","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[747.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":"SetupTasks","type":"text","marks":[{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":".zip","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[86.0]},"content":[{"type":"paragraph","content":[{"text":"If FDFSM_INP_TASK_CODE and FDFSM_INP_ATTRIBUTE_VALUE is provided","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[747.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"SetupTasks","type":"text","marks":[{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":".zip","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[86.0]},"content":[{"type":"paragraph","content":[{"text":"If FDFSM_INP_TASK_CODE and FDFSM_INP_ATTRIBUTE_VALUE is provided,","type":"text"}]},{"type":"paragraph","content":[{"text":"and task is ","type":"text"},{"text":"ValueSet","type":"text","marks":[{"type":"strong"}]},{"text":" related","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[747.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"SetupTasks","type":"text","marks":[{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"ValueSets","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":".zip","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[86.0]},"content":[{"type":"paragraph","content":[{"text":"If FDFSM_INP_TASK_CODE and FDFSM_INP_ATTRIBUTE_VALUE is provided,","type":"text"}]},{"type":"paragraph","content":[{"text":"and task is ","type":"text"},{"text":"Lookup","type":"text","marks":[{"type":"strong"}]},{"text":" related","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[747.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"SetupTasks","type":"text","marks":[{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"Lookups","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":".zip","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[86.0]},"content":[{"type":"paragraph","content":[{"text":"If FDFSM_INP_TASK_CODE and FDFSM_INP_ATTRIBUTE_VALUE is provided,","type":"text"}]},{"type":"paragraph","content":[{"text":"and task is ","type":"text"},{"text":"FlexField","type":"text","marks":[{"type":"strong"}]},{"text":" related","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[747.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"SetupTasks","type":"text","marks":[{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"Flexfields","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":".zip","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[86.0]},"content":[{"type":"paragraph","content":[{"text":"If FDFSM_INP_TASK_CODE and FDFSM_INP_ATTRIBUTE_VALUE is provided,","type":"text"}]},{"type":"paragraph","content":[{"text":"and task is ","type":"text"},{"text":"Fast Formula","type":"text","marks":[{"type":"strong"}]},{"text":" related","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[747.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"SetupTasks","type":"text","marks":[{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"FastFormulas","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":"/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#339966"}},{"type":"strong"},{"type":"em"}]},{"text":".zip","type":"text"}]}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Notes","type":"text"}]},{"type":"paragraph","content":[{"text":"All spaces in file path / name will be replaced with underscore and : will be replaced with %3a.","type":"text"}]}]}],"version":1}

Browser not supported