> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle Sales Cloud Connector

## Intro

Oracle Sales Cloud is a customer relationship management solution that offers capabilities and features enabling companies to significantly grow through accelerated sales, improved customer engagement, and more. It enables modern selling with tools that are easy to deploy and use, completely mobile, packed with powerful analytics, and built for collaborative selling and revenue generation.Use this connector to get data about your opportunities like- your team's opportunities, territories opportunities, subordinate opportunities, and so on.

You connect to your Oracle Sales Cloud account in the Data Center. This topic discusses the fields and menus that are specific to the Oracle Sales Cloud connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in [Adding a DataSet Using a Data Connector](/s/article/360042926274).

## Prerequisites

To connect to your Oracle Sales Cloud account and create a DataSet, you must have the following:

* Your Oracle Sales Cloud username and password
* Your Oracle Sales Cloud REST Server URL. It's the URL of your Oracle Cloud service. Example:

  [https://servername.fa.us2.oraclecloud.com](https://servername.fa.us2.oraclecloud.com)

## Connecting to Your Oracle Sales Cloud Account

This section enumerates the options in the Credentials and Details panes in the Oracle Sales Cloud Connector page. The components of the other panes in this page, **Scheduling** and **Name & Describe Your DataSet**, are universal across most connector types and are discussed in greater length in [Adding a DataSet Using a Data Connector](/s/article/360042926274).

### Credentials Pane

This pane contains fields for entering credentials to connect to your Oracle Sales Cloud account. The following table describes what is needed for each field:

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p> Field </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"> Username </td><td colspan="1" rowspan="1"> Enter your Oracle Sales Cloud username. </td></tr><tr><td colspan="1" rowspan="1"> Password </td><td colspan="1" rowspan="1"> Enter your Oracle Sales Cloud password. </td></tr><tr><td colspan="1" rowspan="1"> API URL </td><td colspan="1" rowspan="1"> Enter your Oracle Sales Cloud REST Server URL. It's the URL of your Oracle Cloud service. Example: <span /><span class="mt-font-courier-new"><a href="https://servername.fa.us2.oraclecloud.com" rel="noopener" target="_blank"> [https://servername.fa.us2.oraclecloud.com](https://servername.fa.us2.oraclecloud.com) </a></span></td></tr></tbody></table>

Once you have entered valid Oracle Sales Cloud credentials, you can use the same account any time you go to create a new Oracle Sales Cloud DataSet. You can manage Connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Managing User Accounts for Connectors](/s/article/360042926054).

### Details Pane

This pane contains a primary **Reports** menu, along with various other menus which may or may not appear depending on the report type you select.

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p> Menu </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> Report </p></td><td colspan="1" rowspan="1"><p> Select the Oracle Sales Cloud report you want to run. The following reports are available: </p><table border="1" cellpadding="1" cellspacing="1"><tbody><tr><td colspan="1" rowspan="1"> Opportunities </td><td colspan="1" rowspan="1"> Returns all the opportunities like sales, revenue for all the products. </td></tr></tbody></table></td></tr><tr><td colspan="1" rowspan="1"> Record Set </td><td colspan="1" rowspan="1"> Select the record set you want to retrieve the opportunities data for. </td></tr><tr><td colspan="1" rowspan="1"> Status Code </td><td colspan="1" rowspan="1"> Enter the status code. </td></tr><tr><td colspan="1" rowspan="1"> Date Selection </td><td colspan="1" rowspan="1"> Select the date format for your data. </td></tr><tr><td colspan="1" rowspan="1"> Single Date </td><td colspan="1" rowspan="1"> Select whether the report data is for a specific date or for a relative number of days back from today. </td></tr><tr><td colspan="1" rowspan="1"> Specific Date </td><td colspan="1" rowspan="1"> Select the specific date using the date selector. </td></tr><tr><td colspan="1" rowspan="1"> Relative Date </td><td colspan="1" rowspan="1"> Enter the number of days back that you would like to get data for in the <b><b> Days Back </b></b> field. Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past. </td></tr><tr><td colspan="1" rowspan="1"> Date Range </td><td colspan="1" rowspan="1"> Select the specific or relative date range. </td></tr><tr><td colspan="1" rowspan="1"> Start Date - Specific </td><td colspan="1" rowspan="1"> Select the first date in your date range using the date selector. </td></tr><tr><td colspan="1" rowspan="1"> End Date - Specific </td><td colspan="1" rowspan="1"> Select the last date in your date range using the date selector. </td></tr><tr><td colspan="1" rowspan="1"> Start Date - Relative </td><td colspan="1" rowspan="1"><p> Enter the number of days back that you would like to get data from (start day). Combine with <b><b><b><b><b><b><b><b> End Date </b></b></b></b></b></b></b></b> to create a range of represented days. </p><p> For example, if you entered 10 for <b><b><b><b><b><b><b><b> Start Date </b></b></b></b></b></b></b></b> and 5 for <b><b><b><b><b><b><b><b> End Date </b></b></b></b></b></b></b></b>, the report would contain data for 10 days ago up until 5 days ago. </p></td></tr><tr><td colspan="1" rowspan="1"> End Date - Relative </td><td colspan="1" rowspan="1"><p> Enter the number of days back that you would like to get data to (end day). Combine with <b><b><b><b><b><b><b><b> Start Date </b></b></b></b></b></b></b></b> to create a range of represented days. </p><p> For example, if you entered 10 for <b><b><b><b><b><b><b><b> Start Date </b></b></b></b></b></b></b></b> and 5 for <b><b><b><b><b><b><b><b> End Date </b></b></b></b></b></b></b></b>, the report would contain data for 10 days ago up until 5 days ago. </p></td></tr></tbody></table>

### Other Panes

For information about the remaining sections of the Connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Data Connector](/s/article/360042926274).

## FAQs

<AccordionGroup>
  <Accordion title="Which endpoint(s) does each report call in this Connector?">
    <table data-aura-rendered-by="33:195;a"><tbody><tr><th colspan="1" rowspan="1" width="30%"> Report Name </th><th colspan="1" rowspan="1" width="70%"> Endpoint URL(s) </th></tr><tr><td colspan="1" rowspan="1"> Opportunities </td><td colspan="1" rowspan="1"> /crmRestApi/resources/11.13.18.05/opportunities </td></tr></tbody></table>
  </Accordion>

  <Accordion title="What kind of credentials do I need to power up this Connector?">
    You need the username and password associated with your Oracle Sales Cloud account, and the URL of your Oracle Cloud service (Example:
    `https://{servername}.fa.us2.oraclecloud.com.`)
  </Accordion>

  <Accordion title="Can I use the same Oracle Sales Cloud account to create multiple datasets?">
    Yes
  </Accordion>

  <Accordion title="Are there any API limits that I need to be aware of?">
    No
  </Accordion>

  <Accordion title="How often can the data be updated?">
    As often as needed.
  </Accordion>
</AccordionGroup>

## Troubleshooting

* Make sure your authentication remains valid.
* Review the configuration to make sure that all required items have been selected.
* Review the Connector history for error messages.
* In rare cases, you may be requesting too much information and reaching API limitations or timeouts. If this is the case, you can review the history of the Connector run to see the error message and duration. If this is the case, you can reduce the number of accounts that are being pulled, choose a smaller number of metrics for the report that you are pulling, or reduce the timeframe that you are trying to pull.
