Instance Consolidation

[pawaskarsandeep]

Hi,

We are currently in an instance consolidation project for two Oracle Apps instances.
For the above mentioned criteria:
1) Is there a defined methodology for instance consolidation?

2) Is there an easily available tool to copy the setups between the two Apps instances? We are currently using FNDLOAD & DataLoad.

3) Is it possible to import the historical transactions from one apps instance to the other or only open transactions can be brought forward?

Regards,
Sandeep

[nitin76]

Hi,

For Cross Instance Consolidation you will have
a. Source Instance - From where SOB data will be picked up
b. Target Instance - Into which SOB data will flow.This is Parent SOB instance.

You should have a subsidiary entity SOB defined in both instances using same 3 C's i.e. currency,calendar,chart of accounts.

Either download the data into ADI journal template in source and upload in target database, upload using SQL loader.

Nitin