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

Use of DB Adapter in SOA Composite Application

I successfully create SOA Composie Application that interact with Oracle Database by using DB Adapter. The Oracle Database Adapter enables a BPEL process to communicate with Oracle databases or third party databases through JDBC.

The Oracle Database Adapter service is defined within a BPEL process partner link by using the Adapter Configuration Wizard of Oracle BPEL Process Manager.

BPEL Process of my DB Adapter

Oracle WebCenter Content 11.1.1.7 and Portal 11.1.1.7

Oracle just released the new version of WebCenter products stack, the WebCenter Centent 11gR1 (11.1.1.7) and WebCenter Portal 11gR1 (11.1.1.7). According to Oracle's official blog it includes many bug fixes in addition to enhancements to the WebCenter Content Application Extension Framework (AXF) supporting integrations with E-Business Suite and PeopleSoft.

Time Importance in Personal and Professional life

Time Importance in Islamic point of view

God says: "The son of man aggrieves Me when he abuses Time, whereas I am Time"(Prophet Muhammad, PBUH)

Time is the only resource that once spent, never comes back. Make sure that you use, not abuse it. Don't waste time in gossips and vein talk. Before every task, ask yourself; "is there a better use of my time right now?" (Faiez H. Seyal from 30 Second Manager)

Oracle Fusion Middleware Environment on Solaris 11

Recently I prepared Oracle Fusion Middleware 11g environment for SOA Server Suite on Oracle Solaris11.1 (x86-64bit). This includes the installation and configuration of following Oracle products:-

1) Oracle Database 11gR2.
2) Repository creation for SOA Suite.
3) Oracle Weblogic Server 11g.
4) Oracle SOA Suite 11g.
5) Domain creation and configuration for Admin Server and SOA Server.

List of Oracle expire exams in 2013

According to Oracle's official blog following exams are going to be expire in July 31, 2013:-

1)   1Z0-007 Introduction to Oracle9i: SQL
2)   1Z0-031 Oracle9i Database: Fundamentals I
3)   1Z0-032 Oracle9i Database: Fundamentals II
4)   1Z0-033 Oracle9i Database: Performance Tuning
5)   1Z0-141 Oracle Forms: Build Internet Applications
6)   1Z0-147 Program with PL/SQL