Data Uploading on Oracle EBS using interface Tables

1. Create csv file and map it with interface table.
2. Check there are no commas in csv file, if any then replace comma with null.
3. Create a customized table as
1. Create SYSTEM_ITEMS_INTERFACE as Select * from MTL_SYSTEM_ITEMS_INTERFACE
4. Make sure that control file contain customized table name.
5. Open WinSCP or any FTP program.
6. Copy csv and control file in prod or test server in new directory.
7. Open Putty. 
8. Set environment of serve.
9. Now go to control file cd /home/oracle/upload/DIR
10. Now run the control file
1. Sqlldr apps/password(toad password) item_master.ctl 
11. Data will be uploaded in customized table
12. If there are some errors during data uploading, check the log file from WinSCP and identify the error
13. Otherwise upload the data in the interface table.
1. insert into MTL_SYSTEM_ITEMS_INTERFACE select * from  SYSTEM_ITEMS_INTERFACE
14. Then run the request from Application "Import Item" with Create parameter