Migration from

[Shashi_k]

Hi,

I would like to know what is the process one should follow for migration of data from legacy systems to oracle for modules like AP, AR ,PO and FA etc. Is there any document available for migration process.

Regards,
Shashi.

[lukman]

The information are available in each module documentation and in R12 usually we use interface table to do it. However there might be some things that Oracle has not provided yet and you can't migrate. One that I found was about bank.

[David Falana]

The process is in two folds:
1. Create temporary tables to load data from external source.
2. Load data to temporary tables.
3. Write plsql code (packages, procedures) to map temporary tables to the apropriate interface tables as listed below.
4. Load data to the interface tables
5. Run appropriate API for each of the Modules to load data from interface tables to the base tables

The interface tables for each modules are liosted below

AP: ap_invoices_interface
ap_lines_interface

AR: ra_customers_interface_all
ra_contact_phones_int_all
ra_customer_profiles_int_all
ra_interface_lines_all
ra_interface_distributions_all
ra_interface_salescredits_all

PO: po_requistitions_interface_all
po_req_dist_interface_all

FA: fa_inv_interface
fa_production_interface
fa_mass_additions