I am new with conversion in Oracle Apps.
I want to do Item Conversion..want to move new items into oracle application..I have read many thing like ...
create flat files
then by using sql loader load data from flat file to staging tables.
then move data from staging table to interface tables and then for interface tables to base tables...
But I am not getting the exact steps....Actually I .csv files for Item now I want to move that flat file to staging table..so I need to create staging tables first ...
So how can I create these staging tables and where can create these and what columns should I need to define in tables....and after that what would be the next step.,...
Please some one would explain me all steps in detail...
You need to read following and if still have question please post here:
MOS notes are:
How to use the Item Open Interface (Doc ID 1457314.1)
Understanding Item Import and Debugging Problems with Item Import (Doc ID 268968.1)
Item Import Performance Tips (Doc ID 66496.1)