Hi Chaitanya,
I have recently joined this forum and I am also working on conversion of O2C objects so let me know what you need, below are the list of objects for which I am doing conversion.
-Customer
-Items
-Price List
-AR-Invoice
-Standard Cost
-Inventory Balance
Hi Chaitnya,
Which scripts you need I am not using scripts for conversion, let me explain you how I am doing migration for Balance & Cost
1. Extract Data in flat file format from Legacy system.
2. Enrichment of legacy data with oracle mapped values and prepare a file in the fixed format as per requirement of EAI Interface. As I am using E-Gate(EAI) to transfer data to staging tables.
3. After i have data files ready in the EAI Format I use the EAI program to load them into staging tables.
You can create staging tables for same purpose and create a custom SQL Loader programto load your data into staging table.
4. After data is loaded into EAI staging tables then I use custom program which is using oracle API’s to transfer data to Oracle core tables.
I hope this gives you idea how I am doing migration from Legacy to Oracle Apps.