To migrate a system extract:You can migrate a system extract from one business group to another after you define the data elements, record layouts, file layout, and selection criteria that comprise the extract definition.
The migration process does not support seeded extract definitions. You migrate seeded extracts directly from the Extract Definition window.
Note: Any extract criteria in your source extract definition must also exist in your target database. For example, if you filter extract records by a change event, you must enable the change event in the target business group. You cannot copy Advanced Criteria.
You run processes from the Submit Request window.
To migrate a system extract:Select Extract Definition Download to Data File in the Name field.
Run this process from the source business group that contains the extract definition you want to migrate.
In the Location and File Name field, enter a target directory path and file name.
Your database administrator should provide you with a valid directory path. If you do not enter a path, the download process writes the file to the directory where you store your concurrent manager log files.
Select an Extract File Layout Name from your list of extract definitions.
Click OK.
Complete the process request and choose Submit.
To upload a system extract for migration:In the Name field, select Extract Definition Upload from Data File.
Run this process from the target business group.
In the Location and File Name field, enter the directory path and file name where you downloaded the extract definition.
If you are migrating between database instances, you must physically move the downloaded data file to a directory where you can upload the file into the target business group.
Select Commit or Rollback in the Validate field.
The migration process does not update an extract that you have already migrated. Run the upload process in Rollback mode to fix errors listed in the audit log before you commit the upload.
Click OK.
Complete the process request and choose Submit.
If you migrate an extract definition and any extract criteria in your target business group do not match the source business group, you must recreate the data in the target after you complete the upload process. You can make any other changes to your extract definition after you complete the upload.
If you encounter any errors when uploading the extract definition, verify that you:
Set the patching level of the target database to the same level as the source database.
Enable any Change Event codes in the target business group that you use in the source business group.
Make available any applicable selection criteria or decoded values in the target business group.