Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Saturday, 28 May 2016

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
               UTL File

Practice Examples for Outbound Interface
               GL Account Extract Outbound Interface
               Ceck Extract Outbound Interface
                   Vendor Extract Outbound Interface
                Inventory Outbound Interface 
SQL Loader Overview on following link                    

                SQL Loader

Practice Example for Inbound Interface
                PO Inbound Interface
Share this article :


  1. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check

  2. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.