Interfaces In Oracle Apps

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.

1)Inbound Interface

2)outbound Interface

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

               http://www.oracleappstreet.com/2016/05/utl-file.html

Practice Examples for Outbound Interface

               http://www.oracleappstreet.com/2016/05/gl-account-extract-outbound-interface.html

               http://www.oracleappstreet.com/2016/05/check-extract-outbound-interface.html

                   http://www.oracleappstreet.com/2016/05/vendor-extract-outbound-interface.html
                http://www.oracleappstreet.com/2016/05/inventory-outbound-interface.html 

               

SQL Loader Overview on following link                    

                http://www.oracleappstreet.com/2016/04/sql-loader.html

Practice Example for Inbound Interface

                http://www.oracleappstreet.com/2016/05/po-inbound-interface.html