About Export Management

You can use Export Management to move data out of Oracle Applications Cloud in the form of CSV files.

To export data, you start by creating an export activity. As part of the export activity, you select a parent object and its relevant child objects. You also must define filters on these objects to specify the records you want to export.

Scenarios for Export

You may want to export data in the following scenarios:

• You might want to move data out of Oracle Applications Cloud into another application. To perform this activity you have to export the data into a ZIP file and import the exported data into the target application.

• You might want to format the data as per your requirements.

• You may want to identify the unique identifiers of an object such as Party ID or Party Number. You can use this information to update an object record.

You can schedule an export either immediately or at a future date. If you schedule it for a future date, then provide the start date and time while defining the export activity.

Note: Currently recurring export isn't supported. You can however use the Export REST resource to schedule recurring export activities through REST API. For more information see REST API for CX Sales and Fusion Service.

Using Export Filters

You can define the conditions for the records to export in the export filter. The exported data sets contain only those records that match the specified filter criteria on the parent/child object. It is recommended that you use multiple filters to reduce the number of records to export.

You can create a filter by navigating to Tools > Export Management > Export Objects and clicking on the Display Name link for the export object. On the Manage Filters page, click the Create Filter button to create a filter. On the Script Edit page, enter the filter name, filter parameters, and the order by clause if required. You can reuse an existing filter by selecting a value from the Existing Filters drop-down list. Once you're done with your changes, click Validate Script and then click Save and Close to save your new filter. You can also create a filter while creating an export activity, on the Map Fields page.

You can delete a filter on the Manage Filters page, by clicking the delete icon for your filter under the Delete Filter column. Note that you can delete only the filters created by you and those that aren't used in an active export job.

Split Export Data

There are no limits to file size for exporting data. However, you can split the exported data set based on a split size. You can enable split from the UI by checking the Enable Split check box in the set up page and select the split size. The default is 100k. You can specify the split size in multiples of 100k records, ranging from 100k to 1000k. Each CSV file can contain a maximum of 50k records. Hence, the exported data will be split into two CSV files after 50k records. The CSV files will then be zipped together and exported.

For example, if an export job fetches 300k records and split is enabled with a split size of 200k, then 2 export ZIP files will be generated. The first one will contain a total of 200k records which will be divided into 4 CSV files each with 50k records. The second ZIP file will contain a total of 100k records which will be divided into 2 CSV files each with 50k records.