Oracle SFDC Integration

Oracle EBS - Salesforce.com Integration  In this post I will describe a specific integration use case where we will integrate a Master Items data from Oracle EBS to Salesforce.com using JAVA Web service and PL/SQL APIs. This will illustrate how we can upload items created/updated in EBS to SFDC by creating Simple JAVA Web service. Scope: This is a two-step process where in first step we will write PL/SQL procedure to insert new/updated master item data to oracle staging table and in second step we will write a JAVA web service to upload item data from staging table to SFDC. This web service will either create new item...

Read more »