Oracle Apps 4 Beginners: Introduction to Oracle Interfaces - 1

Why do we need interfaces?

In many real time business scenarios there is a need to transfer data from one system to another system. In such cases we need to develop programs, these programs are nothing by interfaces.

Interfaces are of two types:

1.    Inbound interface

2.    Outbound interface

As the name suggests, inbound interface gets data from another system and imports them into our system. Similarly, an outbound interface extracts data from our system and sends them to another system.

Oracle Apps 4 Beginners: Introduction to Oracle Interfaces - 2

Project / Context

In an ever changing business environment, the need for adopting and building more robust processes in an ERP implementation projects is not only essential but also very crucial for the success of the implementations. The requirement was to seamlessly integrate the Oracle R12 Applications with various other systems. The Interface needs to handle both history data migration as well as replication of ongoing data. Since the volume of history data was expected as very high, the performance of the Interface program needed to be at the optimum level. Since the data needs to flow into Oracle R12 system through various Interfaces from various systems, the business cannot afford to take any failures at Oracle end.