- OracleApps Epicenter - http://www.oracleappshub.com -
20 Minute Guide to Oracle Integration Repository
Posted By Sanjit Anand On December 22, 2008 @ 5:01 am In EBS Suite | 7 Comments
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/ 
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  /]
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.
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.
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:
- Internal Name
- Type (of Interface)
- Business Entity
- 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.
Article printed from OracleApps Epicenter: http://www.oracleappshub.com
URL to article: http://www.oracleappshub.com/ebs-suite/20-minute-guide-to-oracle-integration-repository/
URLs in this post:
 http://irep.oracle.com/: http://irep.oracle.com/
 http://irep.oracle.com: http://irep.oracle.com
Disclaimer The opinions expressed here represent solely my own represent personal conjecture based upon experience, practice and observation and does not represent the thoughts, intentions, plans or strategies of my current & previous employers and their clients. Copyright © 2007-2010 OracleApps Epicenter. All rights reserved.