BTL EPC Limited (SHRACHI Group)

Integration between Salesforce & Oracle E-Business Suite (Master Data, Sales Data, Order Data, Delivery Data)

• Full Automation of Data Transfer Protocol To & Fro between Salesforce and Oracle EBS
  1. From Oracle we consumed Salesforce API through Oracle PLSQL Packages to send data
  2. Salesforce required data is created in Oracle staging table thru concurrent request
  3. Concurrent requests are ran on scheduled periodical basis
  4. Sending data format are maintained in JSON format
  5. We created Webservice API through Oracle Integration Repository to accept data from Salesforce
  6. Data received in JSON format and stored in staging tables
  7. From staging tables data transferred to Interface tables through Concurrent Requests on regular intervals
  8. Thru Oracle Seeded Interface upload process data are consumed in Base EBS
  9. Exceptions are highlighted thru Reports and mailed to users on occurrence of the same

Benefits

1. Full Automated process
2. Total Control on proper data transfer
3. Seamless transfer and receipt of data from Salesforce
4. Enables Sales team to view near real time data