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.

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:

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:

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.
Related
Comments (12)
Thanks for the link it will be a wonderful resource
Posted by Sunil Choudhary | May 17, 2006 8:12 AM
Posted on May 17, 2006 08:12
Hi
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 http://server.com:port/dev60cgi/f60cgi?&appletmode=nonforms&HTMLpageTitle=Test&HTMLpreApplet=Test&code=appletname&width=400&height=300&archive=folder/appletname.jar. 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 | May 25, 2007 4:46 AM
Posted on May 25, 2007 04:46
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 | May 30, 2007 9:08 AM
Posted on May 30, 2007 09:08
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 | July 6, 2007 12:41 PM
Posted on July 6, 2007 12:41
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 | July 15, 2007 7:58 PM
Posted on July 15, 2007 19:58
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 | July 17, 2007 9:13 PM
Posted on July 17, 2007 21:13
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 (10.1.3.3) 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 | August 3, 2007 1:59 PM
Posted on August 3, 2007 13:59
Steven,
Thank you for the info and best wishes. Will await further updates..
Posted by MDT | August 4, 2007 6:53 AM
Posted on August 4, 2007 06:53
Hi Steven,
You mentioned "We have EBS Adapter (10.1.3.3) 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?
Thanks,
Qing
Posted by Qing | August 10, 2007 10:47 AM
Posted on August 10, 2007 10:47
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 | August 15, 2007 10:09 AM
Posted on August 15, 2007 10:09
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 | November 10, 2008 7:23 PM
Posted on November 10, 2008 19:23
Hi, Felix,
No, I'm not aware of any way of exporting the IREP metadata into another tool.
Regards,
Steven
Posted by Steven Chan | November 13, 2008 4:13 PM
Posted on November 13, 2008 16:13