- OracleApps Epicenter - http://www.oracleappshub.com -

20 Minute Guide to Oracle Integration Repository

These are the some of questions which was asked by loyal reader in last couple of months.

So this is small but powerful post will help you get the answer of these question.

IREP ....Much about Nothing

Think of it as a knowledge base of all integration points for the e-business suite.

So...that mean the Oracle iRep(Integration Repository) is a compilation of information about the different service endpoints exposed by the Oracle E-business Suite of applications.

This provides you a complete catalog of Oracle E-Business Suite’s business service interfaces. You consider this as powerful tool that helps users to discover and deploy the appropriate business interface for integration with any system application .

There is no additional cost you need to pay to get this add-on tool. This is shipped as part of the E-Business Suite Bundle. As the instance is patched, the repository is automatically updated with content appropriate.

The key advantages of using Irep by Implementation consultants are..

How should you access IREP ?

Choice is yours , use any one of these options:

1) From E-business Suite, you need to add a Responsibility : Integration Repository
2) You can directly use Oracle's hosted url: http://irep.oracle.com/ [1]

What you can access in irep?

You can get the details of these interfaces in these documents, like Service Data Objects ,XML Schema ,DTD ,Interface Tables ,Views

Accessing Oracle Integration Repository

Those who are still using 11i they can use Oracle url for accessing irep. Accessing through appropriate registration, you can use Oracle's hosted instance of Integration Repository [http://irep.oracle.com [2] /]

Those who are using R12 , take a note, these are shipped with product therefore to access these you have to add a separate responsibility to acess irep.So Under sys admin Navigator menu,you can add Integration Repository responsibility.

Once responsibility is given then you can click the Integration Repository link that appears.

How Should I use irep/how irep Works for me?

There are 2 ways to use the Integration Repository.

  1. IREP: Catalog Use:On the welcome page you can see on the left the tree of the catalog you can navigate through.
  2. IREP: Search Page :Clicking on search button will drive you to the research page.You can specify criteria, helped by LOV for some of them.

Step by Step : Accessing Oracle Integration Repository

What you have to do minimum is , you can invoke the repository like any other Oracle E-Business Suite application. From the Navigator menu, select the Integration Repository responsibility, then click the Integration Repository link that appears.

Oracle Integration Repository has two main user navigation modes:

Let’s understand How it works ?

First and foremost you need to understand the "Business entities"..which are defined as objects that either perform business activities or have business activities performed on them .

Sales orders, employees, purchase orders, invoice, Payment, customers, and receipts are all examples of business entities.

An interface can be used by multiple business entities, and a business entity can be accessed using multiple interfaces.

Therefore if you are navigating through Integration Repository in that case you can browse directly to an appropriate list of interfaces if you know which product family and product you want to integrate with.

1)The Product Family view is organized as follows: Product Family > Product > Business Entity
For example, Financials > Payables > Payables Invoice.

2) The Interface Type view is organized as follows: Interface Type > Product Family > Product
For example, Web Service > Financials > Cash Management.

the business interface information in Oracle Integration Repository is organized for browsing and searching by interface type, based on the integration technology used. Use this view to see all of the interfaces available for a particular product that use a particular interface type.XML Gateway and Web service-based interfaces conform to various industry standards .

3)The Standard view is organized as follows: Standard and Version > Product Family > Product.
For example, OAG7.2 > Financials > Payables > Process Invoice.

Use this view to browse for a product’s XML Gateway maps and Web services belonging to the specified standard; for example, W3C or OAG 7.2.

Oracle Integration Repository user navigation modes: Searching for an Interface

You can click the Search button anywhere in Oracle Integration Repository to access the main Search page or you can search for interfaces with any combination of the following criteria. This is screen snapshots which you can use.

  1. Interface Name
  2. Internal Name
  3. Product Family / Product
  4. Internal Name
  5. Interface Type
  6. Business Entity

you can also click Show More Search Options to include any of the following additional criteria in your search:

How to view Interface Details

Very simple, if you able to find the details

The Interface Details are provided if you click on the Interface Name.

If you take the example of FND_GLOBAL, then you can find the details of a PL/SQL API are as follows:

  1. Internal Name
  2. Interface
  3. Type (of Interface)
  4. Business Entity
  5. Status
  6. Scope
  7. Description
  8. Signature
  9. Parameters etc…

Using Export Feature

Once the list of the APIs is displayed, you can press an export button provides a csv format file: to establish a list of APIs

Therefore , Integration Repository is one of such powerful tool that must be used by any EBS implementor or inhouse IT departments to integrate with other application.

7 Comments (Open | Close)

7 Comments To "20 Minute Guide to Oracle Integration Repository"

#1 Comment By Sushil On January 12, 2009 @ 8:33 am

Good peice of info for a quick start on irep.
Thanks for sharing.


#2 Comment By vebhhav On January 26, 2009 @ 2:12 am

looks like you are missing one key point….irep is used at design time to ease integration with E-Business Suite

#3 Comment By michael On February 24, 2009 @ 3:33 am

this is very good piece of information.

I just want to know of a way you can interface with external application real time, like when a change needs to be done or data is inserted into oracle ebs and then be propagated to the ext application?

thanking you in advance


#4 Comment By Mike On March 4, 2009 @ 2:04 pm

Good article, thanks. I’m concerned why Oracle doesn’t provide a lot of query based services. This service registry seems to be comprised mostly of update/create based services, if not entirely comprised of this. Querying tables directly isn’t / shouldn’t be practiced if a query service is available.

#5 Comment By Nitin Gaglani On August 27, 2010 @ 3:56 pm

Good info.

For release R12, the Integration Repository comes bundled with your Oracle E-Business Suite instance. In 12.0.X releases, Integration Repository is available as a Responsibility. But in 12.1.1 release, it is available under Integrated SOA gateway responsibility.

#6 Comment By Stanley On May 4, 2011 @ 6:24 am

Thanks Nitin.

#7 Comment By christophe On January 31, 2013 @ 6:24 am


Just wanted to understand why one would implement Oracle Product Hub with E-business Suite and not a standalone Product Hub with Fusion ?