Introduction

This section provides an introduction and the methodology to work with the E-Business Suite Knowledge Modules in Oracle Data Integrator.

Oracle E-Business Suite (EBS) is a suite of integrated software applications that provides a complete solution to the business needs of Oracle customers.

E-Business Suite Knowledge Modules

Oracle Data Integrator Knowledge Modules for E-Business Suite provide comprehensive, bidirectional connectivity between Oracle Data Integrator and E-Business Suite, which enables you to extract and load data. The Knowledge Modules support all modules of E-Business Suite and provide bidirectional connectivity through EBS objects tables/views and interface tables. The EBS Knowledge Modules provide support for the following capabilities:

Data extract from EBS: Standard Oracle or SQL LKMs can be used to extract data from E-Business suite using objects such as Tables, Views, and KeyFlexfields

Reverse-engineering EBS objects: RKM E-Business Suite can be used to reverse-engineer E- Business Suite data structures

Data integration to EBS: IKM E-Business Suite can be used to integrate data to E-Business Suite using OpenInterface tables. The “OpenInterface” API encapsulates a number of Oracle-specific interfaces and ensures data integrity. An OpenInterface is made up of:

o

Several Interface tables to be loaded. These tables are the incoming data entry points for E- Business Suite.

o

Several programs that validate and process the insertion of the data from the interface tables into E-Business Suite.

Oracle Data Integrator Knowledge Modules for Oracle E-Business Suite interact with the database tier to extract metadata and load data. While loading data, it also interacts with the Concurrent Processing Server of the application tier.