If you want to import data to a module from any other modules or any legacy system instead of directly inserting into transactional tables oracle has interface tables in which you have to upload you data. Then from these table Oracle scripts will import data so all validation will be there. tks
Data loader is a wonderful utility, cuts down on lots of complicated steps but doesn't it makes the entire process a little slow as compared to interface?