Additional Settings for Setup Data Export and Import Processes

In general, you won't need these additional settings for your export and import processes. To know whether you need them, review the special requirements explained in this topic.

Manage Import-only Setup Mode

You may have to operate one of your environments, such as your production environment, in import-only setup mode. Then, you can manage the setup data in that environment through the setup import process.

When an environment is in import-only setup mode, users won't be able to use any of the setup user interfaces to manage setup data. If anyone wants to use import processes to manage setup data, they must have the Manage Setup Migration Settings (ASM_MANAGE_SETUP_MIG_SETTINGS_PRIV) privilege to run setup data import. This privilege isn't included in any roles delivered by Oracle and must be granted explicitly to you.

To specify your environment as import-only, follow these steps.

  1. Click Navigator > My Enterprise > Enterprise.

  2. On the Enterprise Information page, go to the Functional Setup Settings section and enable Import-only Setup Mode.

Mange Export of Externally Mastered Setup Data

You may have some of your setup data sourced from an external master system. If you want to exclude those externally mastered data from the setup export process, follow the instructions and make the required changes. You need the Manage Setup Migration Settings (ASM_MANAGE_SETUP_MIG_SETTINGS_PRIV) privilege for this task. This privilege isn't included in any roles delivered by Oracle and must be granted explicitly to you.

  1. Click Navigator > My Enterprise > Enterprise.

  2. On the Enterprise Information page, go to the Functional Setup Settings section and click Manage Export of Externally Mastered Setup Data. The Manage Export of Externally Mastered Setup Data page lists all business objects sourced from an external master system.

  3. Select the Include in Export check box to include a business object in the export process. If you want to exclude a business object, deselect the check box.

  4. Click Save and Close.

Change Export File Size

The default size of setup data export files is usually sufficient for most export requirements. If you're exporting large volumes of setup data for any tasks, you might need to increase the export file size. That would also address the size-related warning message that you might see during the export process.

Note: The file size limit applies to each business object. Based on the existing file size limit, the application allocates resources to process all the business objects. If there's burden on the processing capacity, it could impact the application's performance. Therefore, to prevent unexpected performance issues, change the file size, but only if absolutely necessary. You may temporarily increase the file size to handle the large volume of data and reset it to the default value after the process is complete.

To change the export file size limit, you must be assigned the Manage Setup Migration Settings (ASM_MANAGE_SETUP_MIG_SETTINGS) privilege. To change the export file size, follow these steps.

  1. Click Navigator > My Enterprise > Enterprise.

  2. On the Enterprise Information page, go to the Functional Setup Settings section and click Manage Setup Data File Sizes.

  3. Select the file type and change its value as per the recommendation from Oracle Support. If you want to set a larger file size, consider the available memory in your environment before changing the value.

  4. Click Save and Close.