The job creates a table in the history schema of the destination repository for every table processed by any entity defined in the product family version of your source E-Business Suite repository. If you have added custom tables to any of the entities, the job creates the custom tables. If you add custom tables later, run the job again. If you apply an Oracle patch to your E-Business Suite instance and modify any of the tables created by the job, you need to be run the job again.

Now that the seamless access objects have been created it is time for the APPS portion of the setup. It includes registering the seamless access schemas, creating data groups for the seamless access schemas, and creating responsibilities based on those data groups.

You are now ready to create archive and combined versions of your select inquiry only responsibilities. Seamless access is only intended as a method of looking at data or reporting so choose inquiry responsibilities necessary to give access to the archived data or a combination of the archived and non-archived data for users that will require access to the older archived data. If something needs to be changed then the data will have to be restored and then archived again later after making the changes in one of your standard responsibilities. If the number of responsibilities is large you can download the ARC_FNDLOAD.zip file for a more automated responsibility creation process. The zip file includes a readme with instructions for that process and it will not be covered here.

The next step is the check for any profile options that are set for the original responsibility so the same options can also be set for the archive and combined versions.