What is Conversion and Conversion Process

Conversion is a pre implementation load which will transfer the data from the legacy system to the oracle apps system. After the completion of load we will drop all the objects which we have used for the conversion.

Conversion Process:

1.     We will get the flat file to convert, based on the flat file we will generate the temporary file and by using SQLLDR we transfer data from flat file to temporary table.

2.     Create staging table, which is replica of interface table provided by oracle.

3.     Develop a package which have different program units for validation and moving to interface tables

4.     Run the validation procedure to validate the data which has been loaded into staging table. Use extra cols in a staging table ERRFLAG and MESSAGETEXT that are used to identify valid and invalid records with respective error messages.

5.     We transfer the successful records into interface table and change the ERRFLAG status from V(Validated) to M(Moved)

·         ERRFLAG _ E _ ERROR

·         ERRFLAG _ V _ VALIDATED

·         ERRFLAG _ M _ MOVED

6.     As we are working with open interface we will run the import program provided by oracle used to pull the data from interface table and load into base table.

7.     If any records got failed while importing these will exist under oracle defined errors tables.

Conversion Process (Brief):

1.     Based on the flat file provided write the control file to transfer the data into staging tables.

2.     Validate the data that has been loaded into staging tables.

3.     Insert the validated records into interface tables.

4.     This is an open interface we run the import program to import the data into base tables.