Migration Steps in Oracle Apps:

Migration Steps in Oracle Apps:

Step 1:

Get the data file(Excel......)


Step 2:

Create A table which have a columns as in Data file(Excel).
This Table is called "Staging Table".

Step 3:

Delete the Header of the Data file Exmaple:Name,State etc........
and Store it as Filename.CSV


Step 4:

Create a Control File

Step 5:

Load(Import) Data Using SQL * Loader Option in Toad or Using FileZilla and Concurrent Program.


Step 6:

Find The API For which your Requirement is.And find out mandatory parameter

Step 7:

Create A procedure or Package or Script to get required data.and pass it to the API variables.
Note:Try with "P_Validate=>TRUE" if it works then go for "P_Validate=>FALSE".



     Sameer Patil

"Team Work" More We Less Me.