This chapter gives you an overview of Oracle iSetup. It also gives you a brief introduction to Oracle iSetup's footprint and usage scenarios.
This chapter covers the following topics:
Oracle iSetup, a data migration and reporting tool, is a part of the Oracle E-Business Suite. This tool consists of the Migrator and the Reporter:
The Migrator helps you to migrate data from one instance of Oracle E-Business Suite to another. Following are the steps to migrate data:
Extract select data from an Oracle E-Business Suite instance.
Transform select attributes of the extracted data objects as per your requirements.
Load data to the target Oracle E-Business Suite instance.
The Reporter helps you to generate reports. You can:
Generate reports on the extracted data.
Compare two sets of extracted data to identify differences.
Additional Information: Transforming the attributes is an optional step.
Currently, Oracle iSetup helps to migrate data for the following applications:
Oracle Application Object Library (FND)
Oracle Financials
Oracle Human Resources Management System
Oracle Supply Chain Management
For more details on the areas covered by Oracle iSetup, within these product families, refer to Selection Sets Templates.
There are many scenarios where Oracle iSetup can be used. Following are some of these:
For example, the CRP instance is configured and ready for test by the quality team. Now, you need to:
Migrate select configuration to the test instance.
After testing, modify the configuration in another instance.
Migrate the modified configuration to the production instance.
These steps are illustrated in the diagram below.
Migrate Data
In another example, he test instance is configured. Using Oracle iSetup you can transform the data and load it to the target instance, as shown in the following illustration.
Transform Data
Extract selected data from the source instance.
Transform the data.
Load it to the target instance.
Extract data from an instance using Oracle iSetup. The extracted data is stored in the Oracle iSetup repository. You can download this data and save it in an external repository, as illustrated below:
Save an Extract
The steps are:
Extract the data from the production instance.
Store the data in the Oracle iSetup repository.
Optionally download the data to an external data store.
Generate a report on the extracted data available in the Oracle iSetup repository. This report can be viewed online or downloaded in different formats. The report can also, be sent to a functional analyst. The Reporter module enables this functionality.
As shown in the following diagram, data is extracted from a production instance and a report is generated from the extracted data.
Generate Report
Compare the differences in data between the production instance and the test instance, as shown in the following diagram:
Comparison Report
Extract data from each of two instances.
Generate a comparison report based on the extracted data.