Tables
The adapter models the data in Oracle Sales Cloud into a list of tables that can be queried using standard SQL statements.
Generally, querying Oracle Sales Cloud tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
Oracle Sales Cloud Adapter Tables
Name | Description |
AccountAddresses | The address resource is used to view, create, and update addresses of an account. An address represents the location information of an account. |
AccountAddressPurposes | The address purpose resource is used to view, create, or modify the address purpose. The address purpose describes the use of an address, such as shipping address or billing address. |
AccountNotes | The note resource is used to capture comments, information, or instructions for an account. |
AccountPrimaryAddresses | The primary address resource is used to view, create, and update primary address of an account. A primary address is the default communication address of an account. |
AccountRelationships | The relationship resource is used to view, create, and update account relationships. |
AccountResources | The sales team member resource represents a resource party and is assigned to a sales account team. A sales account team member has a defined access role for the sales account. |
Accounts | The sales team member resource represents a resource party and is assigned to a sales account team. A sales account team member has a defined access role for the sales account. |
Activities | Table to capture task and appointment information. |
ActivityAssignees | Table used to capture the assignees/resources associated to the activity. |
ActivityContacts | Table used to capture the contacts associated to the activity. |
ActivityNotes | Note data objects that capture comments, information or instructions for an Oracle Fusion Applications business object. |
ActivityObjectives | Table used to capture the objectives associated to the activity. |
ContactAddresses | Table that includes attributes used to store values while creating or updating an address. An address represents the location information of an account, contact or household. |
ContactAddressPurposes | The address purpose resource is used to view, create, or modify the address purpose. The address purpose describes the use of an address, such as shipping address or billing address. |
ContactNotes | The note resource is used to capture comments, information, or instructions for a contact. |
ContactPrimaryAddresses | The primary address resource is used to view, create, or modify a primary address of a contact. A primary address is the default communication address of an entity. |
ContactRelationships | The relationship resource includes attributes that are used to store values while viewing, creating, or updating a relationship. |
Contacts | Table resource items include attributes used to store values while creating or updating a contact. |
ContactSalesAccountResources | The sales team member resource represents a resource party and is assigned to a sales account team. A sales account team member has a defined access role for the sales account. |
EmployeeResourceAttachments | The contact picture attachment resource is used to view, create, and update the resource's picture.Get a resource's picture |
EmployeeResources | The resources resoure is used to view, create, and update a resource. A resource is a person within the deploying company who can be assigned work to accomplish business objectives, such as sales persons or partner members. |
Opportunities | The opportunity competitor resource is used to view, create, and update the competitors for an opportunity. The opportunity competitors is used to store information about the competitors associated with the opportunity. |
OpportunityCompetitors | The opportunity competitor resource is used to view, create, and update the competitors for an opportunity. The opportunity competitors is used to store information about the competitors associated with the opportunity. |
OpportunityContacts | The opportunity contact resource is used to view, create, and update the contacts of an opportunity.The contact associated with the opportunity. You can specify a contact's role, affinity, and influence level on an opportunity. A single contact can be marked as primary. |
OpportunityDeals | A deal associated with the opportunity. |
OpportunityLeads | The opportunity lead resource is used to view, create, and update the lead that resulted in an opportunity. |
OpportunityNotes | The note resource is used to capture comments, information, or instructions for an opportunity. |
OpportunityPartners | The opportunity partner resource is used to view, create, and update the partners associated with this opportunity.The opportunity partner is used to store information about partners who are contributing to the selling effort of the current opportunity. |
OpportunityRevenueItems | The revenue items resource is used to view, create, and update revenue items of an opportunity. The revenue items associated with opportunities are products, services, or other items a customer might be interested in purchasing. You add revenue items by selecting a product group or product to associate with an opportunity. |
OpportunityRevenueProductGroups | The product group resource is used to view, create, and update the product groups associated with an opportunity. The product group let you categorize products and services that you sell. |
OpportunityRevenueProducts | The following table describes the default response for this task. |
OpportunityRevenueTerritories | The opportunity revenue territories resource is used to view, create, and update the revenue territories of an opportunity. The territories assigned to an opportunity revenue line. The territories provide the rules for automatically assigning salespeople and other resources to customers, partners, leads, and opportunity line items. |
OpportunitySources | The opportunity source resource is used to view, create, and update the source of an opportunity.The opportunity source is used to capture the marketing or sales campaign that resulted in this opportunity. |
OpportunityTeamMembers | The opportunity team members resource is used to view, create, and update the team members associated with an opportunity. The opportunity team member of the deploying organization associated with the opportunity. |
Territories | The sales territories resource represents the list of sales territories that the logged-in user can view. A sales territory is an organizational domain with boundaries defined by attributes of customers, products, services, resources, and so on. Sales territories can be created based on multiple criteria including postal code, area code, country, vertical market, size of company, product expertise, and geographical location. Sales territories form the fundamental infrastructure of sales management as they define the jurisdiction that salespeople have over sales accounts, or the jurisdiction that channel sales managers have over partners and partner transactions. |