Insert Data into Oracle EBS through Interface tables by using Oracle SOA Suite Technology

Adapter for Oracle Applications uses interface tables to insert and update data in Oracle Applications. 

Interface Tables act as staging tables between client application and Apps Base tables. Data is never loaded directly into Oracle Applications base tables. Instead, data is first loaded into interface tables, and then Oracle-supplied concurrent programs move data from interface tables to base tables. This ensures that all business logic and processing is handled using Oracle components.

Today I successfully loaded Sample Order Data from SOA Server to the following Oracle EBS Interface Tables:-


BPEL Process of Insert Order into EBS

Testing Web Service

Flow Trace Page

Validating Records Using SQL


  1. Wonderful blog checkout my latest post at
    feel free to leave a comment and like us on facebook


Post a Comment

Popular posts from this blog

How to create Oracle stored Procedures using TOAD for Oracle

How to Create Packages in Oracle Database using TOAD for Oracle

Create Tables in Oracle Database using TOAD