Tuesday, April 9, 2013

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





1 comment:

  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

ShareThis

Related Posts Plugin for WordPress, Blogger...