Integration Repository for the E-Business Suite

There are many ways of getting information into and out of the E-Business Suite.  Until recently, however, these have been documented in a wild assortment of different places, including product-specific Apps manuals, the Electronic Technical Reference Manual (eTRM), and other unlikely sources.  If you've been subjected to the dubious pleasure of sifting through
our documentation in search of APIs and web services, this article should come as welcome news.

Integration Repository 11i Screenshot:

The new Oracle Integration Repository for the E-Business Suite pulls all of those sources into a single place... at last.  Initially intended to catalog service endpoints available via our service-oriented architecture, this repository has since grown into a comprehensive reference for all of the E-Business Suite's business service interfaces. 

You can browse the repository by product family, drilling down into specific modules:

Integration Repository 11i Menu:

Once you drill into a specific API, there's a concise list of the details you'd expect, including function names, parameters, rules, and so on:

Integration Repository 11i API Screenshot:

Looking Ahead to Release 12

The Release 11i version of the repository is available online only.  In Release 12, it's expected that the Integration Repository will be part of your Rapid Install.  As your instance is patched, the repository will automatically be updated with content appropriate for the precise revisions of interfaces in your environment.

July 13 Update:  We will also host an online version of the Integration Repository for Release 12, as well.




Thanks for the link it will be a wonderful resource

Posted by Sunil Choudhary on May 17, 2006 at 01:12 AM PDT #

I am developing my own applet that will be used in conjunction with Oracle e-Business Suite. I want to ensure that when the applet is launched it executes using the existing install of Jinitiator on the client PC. What would be the correct way to launch this applet? It does not seem to be possible to make Jinitiator the default JVM for the browser. I am playing around with url痴 like But I want to ensure that I get it correct. Can you point me to the correct documentation? I am struggling to find a good source of information.

Posted by Shaun on May 24, 2007 at 09:46 PM PDT #

Hi, Shaun,I've done a bit of research on this but am drawing a blank, ultimately, on recommendations.In general, no applets or extensions within the E-Business Suite should be attempting to force invocations of any specific JVM/Jinitiator release.   Whatever Java invocation takes place on the mid-tier should simply trigger the default Java desktop client configured for the overall E-Business Suite environment.  If the sysadmin has configured their E-Business Suite environment to use the native JRE, then that should be triggered by your extension, too.I don't have any pointers to official documentation on these types of extensions, unfortunately.  If you're really interested in investigating this further, our Oracle Consulting group may be better able to assist than us in Development.Sorry -- I wish had a better answer for you.  Good luck with your project.Regards,Steven 

Posted by Steven Chan on May 30, 2007 at 02:08 AM PDT #

Hi Steve, great blog.

Had a chance to look into the Integration repository in V12 from the perspective of data integration across an enterprise. Is is possible to interrogate the repository from an outside program using APIs? Or is the repository only meant to to be a browser within the Oracle Apps environment? It would be very useful to have the API capability so that the discovery, import and mapping activities to the V12 integration objects [example, interface tables, stored procedures, business views,..] can be performed from an integration program.

Posted by MDT on July 06, 2007 at 05:41 AM PDT #

Hi, MDT,Thanks for the feedback on the blog.  Sorry for the delay in responding.Good question!  I've passed it on to our Integration Repository team and will post their reply as soon as possible.Regards,Steven 

Posted by Steven Chan on July 15, 2007 at 12:58 PM PDT #

Thanks Steven, will await the response.

Follow on question - if the repository is strictly a browser and does not expose a queryable API (as I suspect), is there an export facility so that one could export a whole set of interface metadata and import that into an external integration application?

Posted by MDT on July 17, 2007 at 02:13 PM PDT #

Hi, MDT:Sorry for the delay in getting back to you on this.  My post-pneumonia backlog has been formidable.There are no facilities presently to do bulk interface metadata exports.  For you previous question, here's an excerpt from the reply from our Integration Repository team:Current Solution:===========We have EBS Adapter ( today which
provides the introspection capability for IREP for most of the integration
interfaces, and can be directly used either in a ESB or BPEL as a pure
Web-Service.We also have a native Service Bean in IREP which allows
interogation on the Service Bean's deployed in the IREP. This can be called from
any WS Client.They also dropped some interesting hints about their product roadmap.  They still putting together some formal communications around this now, so I can't share those quite yet.  Stay tuned:  I'll post some updates on this as soon as possible.Regards,Steven

Posted by Steven Chan on August 03, 2007 at 06:59 AM PDT #

Thank you for the info and best wishes. Will await further updates..

Posted by MDT on August 03, 2007 at 11:53 PM PDT #

Hi Steven,

You mentioned "We have EBS Adapter ( today which provides the introspection capability for IREP for most of the integration interfaces, and can be directly used either in a ESB or BPEL as a pure Web-Service." in you last post. My understand is the EBS Adapter provided the Web-Service, from which user can get most of the integration interfaces showing in the IREP. Do I understand this correctly? If it's correct. Are those WSDL files of web-services published in somewhere?


Posted by Qing on August 10, 2007 at 03:47 AM PDT #

Hi, Qing,My understanding is that this is correct:  the EBS Adapter has the same seed data for the published web service endpoints for the E-Business Suite. However, I don't know whether the actual WSDL files are published somewhere.  I'd recommend logging a Service Request against the EBS Adapter to get some guidance with more hands-on experience with that than I.Regards,Steven

Posted by Steven Chan on August 15, 2007 at 03:09 AM PDT #

Hi fooks:
Are there any API and method can be used by public to import the IREP metadata which can be used to construct the interface tree?
Hopefully your suggestions!

Posted by felix on November 10, 2008 at 11:23 AM PST #

Hi, Felix,

No, I'm not aware of any way of exporting the IREP metadata into another tool.


Posted by Steven Chan on November 13, 2008 at 08:13 AM PST #

Hi Steven,
we are using Oracle EBS 11i, and we have implemented iprocurement, HR SS and iexpenses modules. as part of staff portal solution, we would like to expose these functionalities thru Oracle SOA suite and Webcenter Portal. The method which which we are adopting is using Oracle IREP to integrate self service APIs to the SOA suite and develop custom portlet for building seemless UI.
could you tell us is IREP for EBS 11i is enough on accessing selef services' functionalities.


Posted by husam on December 28, 2009 at 05:03 AM PST #

Hi, Husam,

It's hard to say definitely whether the services exposed through the Integration Repository will be "enough" for your purposes. There are some services exposed, but they're a subset of what's available natively to, say, OA Framework developers. You're probably better-able to comment whether the available services match up with your list of third-party portlet requirements.

Good luck with your integration project.


Posted by Steven Chan on December 29, 2009 at 05:21 AM PST #


Is there any direct API available for self services?

For eg. I want to create an iExpense: Using OA adapter I found that there are stored procedures (API) which I can call.

My question: Is there any api at functionality level like for creating an iExpense something like createiExpense which takes parameters and call appropriate API's inturn.

OR do I need to use the granular api calls to achieve iExpense creation.

Thanks in advance


Posted by Yousuf Baig on February 09, 2010 at 06:39 PM PST #

Hi, Yousuf,

I'm afraid that I don't have a lot of visibility into the types of APIs available for individual products like iExpenses. My general impression is that the APIs exposed are quite granular, but this varies from product to product.

If you'd like to get an authoritative answer, your best bet would be to log a formal Service Request against the iExpenses product via My Oracle Support (formerly Metalink) to get one of those product specialists engaged.


Posted by Steven Chan on February 10, 2010 at 01:15 AM PST #

It seems that Oracle Integration Repository (online) is broken. I got the following message:

Request URI:/OA_HTML/OA.jsp


Posted by Kevin Zhang on July 11, 2012 at 08:35 AM PDT #

Hi, Kevin,

Thanks for letting us know about this. I apologize for the inconvenience. We'll get that restarted as quickly as possible.


Posted by Steven Chan on July 11, 2012 at 08:47 AM PDT #

Hi, Kevin,

The system had to be restarted; it's working once again.


Posted by Steven Chan on July 12, 2012 at 10:01 AM PDT #

The Oracle Integration Repository is down again...

Can you restart it please?

Posted by DL on August 28, 2012 at 02:56 AM PDT #

Hello, DL,

Our apologies -- we'll get this restarted again. We have some monitoring in place to prevent these kinds of situations, but clearly something has gone awry there. We'll get that fixed.


Posted by Steven Chan on August 28, 2012 at 08:08 AM PDT #

Hello, DL,

It's up and running now. We're tracing the root cause of the outage.

Sorry for the inconvenience, and thanks, again, for letting us know about this.


Posted by Steven Chan on August 28, 2012 at 09:38 AM PDT #

Hi Steven,

Thanks but, whilst it was up for a while, it's now down again...

Can you restart it again please?


Posted by guest on August 29, 2012 at 01:51 AM PDT #

Hi, Guest,

Can you retry?


Posted by Steven Chan on August 29, 2012 at 02:11 PM PDT #

Hi Steven,

In the
there is the Level wording attach to the menu like Level0, Level1 and Level2.

Posted by Brian on September 26, 2012 at 01:44 AM PDT #

It seems that Oracle Integration Repository (online, is broken. I got the following message:

Application Unavailable

This application is currently unavailable. We apologize for the inconvenience.

Any ETA for its up?



Posted by Kevin Zhang on October 29, 2012 at 09:54 AM PDT #

Hi, Kevin,


Hosted EBS 11i Integration Repository Temporarily Offline


Posted by Steven Chan on October 29, 2012 at 10:34 AM PDT #

Hi Steven,

Unable to open can you please suggest if it is down or can be accessed through some other link?

Posted by Tarun Vashistha on August 10, 2015 at 05:32 AM PDT #

Hi, Tarun,

Unfortunately, we've had to take that service offline permanently.


Posted by Steven Chan on August 10, 2015 at 09:04 AM PDT #

Post a Comment:
Comments are closed for this entry.


« December 2016