Otm-ebs Integration

[krishna.kk]

Below are some of the OTM-EBS issue which I currently need help i appreciate if some one can help with some information or docs

1) GL code integration in EBS with OTM Integration(From OTM to EBS).

2) Tax Integration between EBS and OTM .

3) Multi Org Concept in OTM.

4) AR integration between OTM and EBS .

5) Integration of exchange rates between OTM and EBS.

Rgds,
Kishore

[jeff.depaul]

Re: Otm-ebs Integration

Kishore,
I can provide some insight as it relates to a few of the items you are looking for feedback on - see my comments below...

I am the tech lead on a year-long OTM project integrating Oracle EBS applications 11.5.10.2 with OTM v. 5.5 CU2 using Fusion v. 10.1.3.3 BPEL integration interfaces. We started with the "seeded" Oracle BPEL flows that come with the purchase of the OTM application and have had to completely modify each one of them in order to use for our real-world application.

#1 I am not exactly sure what you are referring to why you say "GL code integration" - there is a seeded BPEL flow to bring invoice voucher information from OTM back into EBS - but this feeds into the Accounts Payable subledger API - not GL directly. We had to modify this BPEL flow logic to include support for allocations and transaction rollups which were requirements for our users. There are several data elements which we pass into OTM (via other interfaces) which are used in this interface for allocation purposed - specifically EBS item/category related information.

#3 In my experience, OTM does not support true Multi-Org functionality as it is defined in EBS. There are different schools of thought on how best to configure OTM to support multi-org operability with EBS which mainly depend on business requirements. In OTM, you can create different domains which roughly equate to "orgs" in EBS. There are limitations to this approach which I will not go into here but in short we went with a single domain and limit user data by VPD in OTM. If you are familiar with EBS multi-org, you can guess this causes issues with items that are enabled for multiple Inventory Orgs. We decided to customize the item nomenclature in OTM to include the org name in EBS. We also concatenate the item UOM and store it at the ship unit level of the item. This met our needs but would need to be evaluated against requirements as it does have its drawbacks as well.

#4 Although we did not include AR integration as part of our project scope, we have a follow-up phase which will include integration with AR invoicing. In order to get actual ship costs for prepaid & add included on the invoice, our conceptual approach is to have the AutoInvoice set check OTM for actual freight and include on the customer invoice. There may be other integration touch-points between OTM and AR but we are not considering them.

Hope this feedback helps and let me know if you have further questions.
-Jeff

[krishna.kk]

Re: Otm-ebs Integration

Dear Jeff,

Thanks for you time and I Appreciate the info provided .

Rgds
Kishore

[chrisplough]

Re: Otm-ebs Integration

I completely agree with the points that Jeff made. Unfortunately, none of your questions (1-5) are possible via the pre-packaged EBS/OTM integration and will require custom integration to accomplish. Many of these are possible, however, and I recommend that you reference the following files in your OTM install for more technical details about OTM's integration:

• $OTM_HOME/docs/integration/integration.pdf
• $OTM_HOME/glog/config/GLogXML.xsd
• $OTM_HOME/glog/config/GLogXML.wsdl

Specifically, I can ad a bit more about the Org <==> Domain mapping. OTM's concept of domains is very different from the Org concept within EBS and (I believe) much more flexible. Unfortunately, the pre-packaged integration flows don't allow you to take advantage of this, nor to reconcile the differences between the two systems. One thing you can do, however, is use multiple domains in BPEL and OTM to simplify your TEST and DEV environments.

For instance, I'm working with a client now who has 6 different EBS systems used for testing and development during their implementation (don't ask - it still confuses me). We've developed a way for them to integrate into only 2 OTM instances (TEST and DEV) by using multiple domains in both OTM and BPEL. So, for instance, your DATACONV domain in OTM integrates with your DATACONV domain in BPEL, which then integrates with your DATACONV EBS instance. This has allowed them to greatly simplify their implementation architecture and reduce the number of systems to manage with a minimal (though talented) IT department.

Thanks,
Chris