Interface is one of the Program which will be used to transfer the data from Oracle database tables in to flat file (or) Flat files into Database tables
We have two types of Interfaces.
Outbound Interface will be used to extract the data from oracle Database tables into the flat files.
Inbound Interface will be used to upload the data from legacy system (Flat files) into Oracle Applications base tables.
While developing the outbound Interface we will use UTL_File to Extract the data.
While Developing the Inbound interface we will use SQL * loader to import the data into base tables.
UTL_FILE Package Overview on following link
Practice Examples for Outbound InterfaceVendor Extract Outbound Interface
Inventory Outbound Interface
SQL Loader Overview on following link
Practice Example for Inbound Interface