ERPstuff - Oracle EBS Community

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

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