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:-

1) OE_HEADERS_IFACE_ALL
2) OE_LINES_IFACE_ALL

BPEL Process of Insert Order into EBS



Testing Web Service



Flow Trace Page



Validating Records Using SQL





Comments

  1. Wonderful blog checkout my latest post at
    http://togetherfornature.blogspot.com/2012/07/what-is-nature.html
    feel free to leave a comment and like us on facebook

    ReplyDelete

Post a Comment

Popular posts from this blog

How to create Oracle stored Procedures using TOAD for Oracle

Create Tables in Oracle Database using TOAD

How to Create Packages in Oracle Database using TOAD for Oracle