+ Start a Discussion
SunaySunay 

API Integration with Oracle ERP - R12

Hi,

 

I am trying to integrate sales force with Oracle ERP, hence I need help on this how to integrate using API coding as I am new to this integration.

 

Please find the details below:

 

I am trying to push accounts, contacts, opportunities and quotes into oracle. Since the order has to be generated from oracle, the required details from sales force has to be pushed. But I understand that oracle ERP has different tables which is referred by a single field or ID, hence I need help on how to go about this and do the integration using API codes.

 

Also I need help on how to give the sequences/validations while inserting the data.

 

Please help me regarding this!!!

 

Regards,

Sunay

cloudmaniacloudmania

Do you mean "Crm on Demand" by saying "Oracle ERP".I can help you about this ,of course if you still need help

SunaySunay

No it is not "CRM on Demand". Oracle ERP R12 is a Enterprise Resource Planning solution from oracle for its customers. It has nothing to do with CRM. It is basically used to generate orders and keep a record of it.

cloudmaniacloudmania

I get it.Basically, the main structure is ,first you download the wsdl file from EBS and you have to generate proxy classes in to SF by using "Generate From WSDL" button now you are ready to use EBS web service.

SunaySunay

What exactly is EBS? If you can guide me through the steps, it would be helpful.

 

And I am using a professional edition of salesforce. Hence I will not be able to generate WSDL right!!!

cloudmaniacloudmania

Check the following link.It gives some idea how can you download wsdl file from EBS.

http://convergence.satpathy.org/2009/05/05/oracle/ebusiness-suite/oracle-e-business-suite-121-native-out-of-the-box-soap-based-web-services/

But the main problem is using professional edition.I know it does not include "GEnerate From Wsdl Button".Now you have 2 options.First,You have to create your proxy classes manually by parsing wsdl xml( but i never suggest this option:) and second options creating a developer account.If i were you,I will create a developer account and do some test in this account.

VivianVivian

Hi All,

 

There is a webinar tomorrow 10/18 at 9 am PST that explains how Informatica Cloud  easily integrates Oracle EBS and Salesforce and we will have one of our customers, RAE Systems, talk about their Oracle EBS R12 implementation.

 

Register here: http://info.informaticacloud.com/forms/Webinar_Oracle-Rae10082011

 

Thanks,

Vivian

Ajay SarojAjay Saroj
Hi cloudmania,
We have similar requirement of integrating mobile application which is a SAAS based hosted in amazone(cloud). Now we need to integrate this mobile application with the EBS 12.1.3.We need to pull and push data from EBS as well as from mobile application. Please suggest how we could achive the same. How to implemet the WSDL ? It would be great help if you could mail the suggestions at a.saroj@transasia.co.in

Thanks.
Ravi TripathiRavi Tripathi
Free Webinar : Oracle E-Business Suite - Salesforce.com Integration via Oracle's API on Aug 26th, 2015 at 3PM EST.

Visit:  http://blog.optiosys.com