Page 1 of 1
Migration from
Posted: Fri Apr 17, 2009 4:20 am
by 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.
Posted: Wed Apr 22, 2009 11:31 pm
by 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.
Posted: Fri May 15, 2009 1:59 pm
by 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