Forum Stats

  • 3,838,882 Users
  • 2,262,408 Discussions


Accessing Oracle Sales Cloud data using REST web services

Venkatesh Yadavalli-Oracle
Venkatesh Yadavalli-Oracle Member Posts: 18
edited Jul 1, 2016 3:38AM in Developer Solutions


An enterprise is using Oracle Sales Cloud to manage information about sales opportunities and revenue estimates. The enterprise has built a custom web application to graphically compare the revenue estimate of a selected opportunity against all other opportunities for that quarter both from an actual dollar amount and a dollar amount adjusted by win probabilities. This application is deployed in JCS-SX and is embedded into Sales Cloud.

A brief functional and technical description of this scenario is presented in this short screen cast.


Figure : REST web service call to access Sales Cloud data

Solution Approach

A sales administrator logs into Oracle Sales Cloud to view the information pertaining to a sales opportunity. When the user selects the opportunity, in the default view, he finds a new sub-tab on the left pane. When clicked on this new sub-tab, the custom web application deployed in JCS-SX is displayed providing an integrated user experience. Upon clicking this tab, a set of two pie charts are displayed comparing the selected opportunity's revenue (both actual and adjusted by win probability) to the quarter's opportunity totals.

The web application deployed in JCS-SX makes a REST web service call to the Sales cloud using super user credentials configured in JCS-SX and retrieve opportunity details. The web application then uses this information to generate the pie charts.

The views expressed in this post are my own and do not necessarily reflect the views of Oracle.