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
