Data Conversion in Oracle Cloud

Data Conversion is a process of moving required volumes of data from our clients' existing systems to Oracle

Points to note

• Convert Master Data as well as Transactional Data
• The conversion of closing balances data as on Cut Off Data in the form of journals in Oracle General Ledger
• Conversions of open transaction as on Cut Off Date into Oracle Subledger modules like Accounts Payables, Accounts Receivables, Fixed Assets, Purchasing and Inventory.
• Import of Oracle Subledger Module data into Oracle General Ledger and reversing those entries in GL.

Summary of what we convert by module

Module	Conversion Data
AP	Supplier/ Supplier Sites Master
AP	Open Invoices, Debit Memos/Credit Memos and Prepayments
AR	Customer Master
AR	Open Customer Invoices, Debit Memos and Credit Memos and Unapplied Receipts
CM	Bank Master
CM	Open Bank Statement Lines
FA	Fixed Assets Balance
PO	Open Purchase Orders
PO	Employee Master
INV	Item Master
INV	Opening Balances – Quantity and Price
GL	Account Balances

Data Conversion EBS Vs Cloud using FBDI Templates

No technical work is involved in Fusion for Data conversion. The below high level process is followed for all activities like AP, AR, Journals conversion or asset conversions in Cloud using FBDI templates.

Steps	EBS Data Conversions	Steps	Fusion Data Conversion
1	Create Data Templates	1	Download templates from Oracle OER(Oracle Enterprise Repository)
2	Collect Data	2	Collect data from Business
3	Share with Technical	3	Create CSV files from data template
4	Convert into CSV	4	Upload CSV files into UCM(Universal Content Management)
5	Create Staging Tables	5	Populate data into interface tables
6	Coding	6	Import data into base tables
7	Populate data into staging tables from CSV
8	Validation
9	Populate data into interface tables
10	Import data into base tables