This chapter helps you to configure iSetup. It covers the prerequisites for using iSetup and suggestions to tune iSetup for optimal performance.
This chapter covers the following topics:
The source, central, and the target instances must be at the same patch set level. For more information, see Instance Overview.
An instance comprises of one or many applications of the Oracle E-Business Suite along with a dedicated Oracle database instance.
Following are the types of instances that you use while working with Oracle iSetup:
Source Instance: The instance used to extract data.
Central Instance: The instance that hosts the iSetup application and iSetup Repository.
Target Instance: The instance where data is to be loaded.
Note:
The Central instance is optional. Oracle iSetup can be run from either the source or the target instance.
The Target instance need not be a fresh install.
Perform the following tasks to prepare an instance of the Oracle E-Business Suite:
Recompile Database Objects
Check for invalid database objects and recompile if necessary. Invalid objects may cause the load to fail. Contact your System Administrator for more information.
Set Open Cursor Limit
Set the open cursor limit for your instance to 750. This setting is in the init.ora file for the instance. The default value is 500. If this value is not optimally set, you may encounter an error once the load may exceeds the maximum open cursor limit.
Set Sleep Seconds for the Concurrent Manager
This setting specifies the time a request remains in the pending status before being picked up by the Concurrent Manager for processing. A high setting, such as 300 seconds, slows down the load or extract process.
Navigate to Concurrent > Manager > Define Form.
Open the Define Form and query for Standard Manager. Click Work Shifts to continue. This takes you to the Workshifts screen.
Check the Sleep Seconds setting. It is recommended to set this to 30 seconds or less.
AZ: VO Fetch Size (Concurrent Processing profile category)
This profile option specifies the number of records that Oracle iSetup extracts in a batch, before it writes it to a temporary location on the file system for later use. The profile option is set on the source instance only. The recommended and the maximum value for the option AZ: VO Fetch Size is 100.
AZ: Commit Row Counts (Concurrent Processing profile category)
This profile option specifies the number of records that Oracle iSetup commits to the database on the target instance during load. If the value is high, you require high JVM heap size to avoid an out-of-memory error during load. This profile option is set on the target instance only. It is recommended to set this value to 1000.
AZ: CP Number Of Batches (Concurrent Processing profile category)
This profile option specifies the number of threads that can be launched during extract or load. This profile option is to be set on the source and the target instances. It is recommended to set this value to 5.
Note: This option must be set to 1 when any Manufacturing APIs are used to extract or load.
AZ: Reporter Max Records (User Interface profile category)
This profile option specifies the number of records that the system would fetch for rendering the online report. The maximum value is 200 and the recommended value is 100.
AZ: Number Of Records For Home Tab (User Interface profile category)
This profile option specifies the number of most recent Extracts, Loads, and Reports to be displayed on the Home screen. It is recommended to set this value to 4.
For more information on profile options and categories, see Appendix B.
Oracle iSetup is a part of the Oracle E-Business Suite. Hence, you must log in to Oracle E-Business Suite using the self-service login URL.
Log in to Oracle E-Business Suite
Log in to the Oracle E-Business Suite using your user name and password.
Choose a Responsibility
The user name you log in with must have the Oracle iSetup responsibility. From the list of responsibilities, select iSetup to access the Oracle iSetup functionality.
Choose Function
Menu options for this responsibility are:
Home: Takes you to the Home page of iSetup. This page displays the most recent extracts, loads and reports. It also has links to other components of the product.
Migrations: This menu contains the Selection Sets, Extracts, Transforms, and Loads subtabs. Each of these subtabs take you to their respective windows.
Reports: This menu contains the Standard Reports and Comparison Reports subtabs. Clicking on them takes you to the respective windows.
Administration: This menu contains the Instance Mapping subtab. If you have appropriate access privileges, you can also see the Interface Repository subtab in addition to the Instance Mapping subtab.