Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
Adapter Views
| Name | Description |
| AccountsEmails | The email address and its associated information. |
| AccountsPhones | The details related to the phone number. |
| AnalyticsReports | The analytics report definition that provides descriptions of a report's output columns, search criteria, and other components. |
| AnalyticsReportsFilters | The filters used for running an analytics report. |
| AnalyticsReportsNames | The language-specific strings used for localization of fields. |
| AnswersCategories | The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base. |
| AnswersCommonAttachments | The file attachment shared by sibling answers. |
| AnswersCommonAttachmentsNames | The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field. |
| AnswersFileAttachments | The file attachment shared by answers. |
| AnswersNotes | The note text associated with the objects such as contacts and organizations. |
| AnswersProducts | The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base. |
| AnswersRelatedAnswers | The knowledge base information that provides solutions to the common customer support questions. |
| AnswersSiblingAnswers | The knowledge base information that provides solutions to the common customer support questions. |
| AnswerVersionsCategories | The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base. |
| AnswerVersionsCommonAttachments | The file attachment shared by sibling answers. |
| AnswerVersionsCommonAttachmentsNames | The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field. |
| AnswerVersionsFileAttachments | The file attachment shared by answers. |
| AnswerVersionsNotes | The note text associated with the objects such as contacts and organizations. |
| AnswerVersionsProducts | The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base. |
| AnswerVersionsRelatedAnswers | The link to related answers. |
| AssetsSLAInstances | The instance of a Service Level Agreement (SLA). |
| AssetStatuses | The status of the assets, namely product and services that are registered and tracked in Oracle B2C Service. |
| AssetStatusesNames | The language-specific strings used for localization of fields. |
| Campaigns | The information on email marketing campaigns created in Oracle B2C Service Outreach Cloud Service. |
| ChannelTypes | The social channels tracked in contact records when storing social account user names and associating social monitor incidents to contacts. |
| ChannelTypesNames | The language-specific strings used for localization of fields. |
| Chats | The real-time, two-way dialog between a customer and one or more chat agents. |
| Configurations | The information about the configuration settings within Oracle B2C Service. |
| ContactsChannelUsernames | The user name of the channel. |
| ContactsEmails | The email address and its associated information. |
| ContactsFileAttachments | The file attachment that includes additional fields used for attachments to various classes. |
| ContactsNotes | The note text associated with the objects such as contacts and organizations. |
| ContactsOpenIDAccounts | The OpenID related information for the contact. |
| ContactsPhones | The details related to the phone number. |
| CountriesNames | The language-specific strings used for localization of fields. |
| CountriesProvinces | The information about the provinces in the Countries/Provinces customizable menu. |
| CountriesProvincesNames | The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field. |
| HolidaysAdminVisibleInterfaces | The named ID that can be included in a list. |
| IncidentsBilledMinutes | The work time applied to incidents through the Time Billed feature. |
| IncidentsFileAttachments | The file attachment that includes fields specific to incidents. |
| IncidentsMilestoneInstances | The milestone instances associated with incidents. |
| IncidentsThreads | The incident discussion thread entry. |
| Mailboxes | The mailbox used for collecting email inquiries sent by customers, responses to mailings, and bounced messages. |
| MarketingMailboxes | The mailbox used to send and receive emails and process bounced messages. |
| MessageBases | The editable text string that allows international language support and customization of headings, labels, buttons, and other text in the administration interface and customer portal. It also applies to email messages and notifications. |
| NamedIDs | An ID which has an associated name string. These IDs can be set by either value or name. |
| OpportunitiesFileAttachments | The file attachment that includes additional fields used for attachments to various classes. |
| OpportunitiesNotes | The note text associated with the objects such as contacts and organizations. |
| OpportunitiesOtherContacts | The secondary contact associated with the opportunity. |
| OpportunitiesQuotes | The sales quote associated with an opportunity. |
| OpportunitiesQuotesFileAttachments | The file that is attached or associated with another object. |
| OpportunitiesQuotesLineItems | The product line item in a quote. |
| OpportunityStatuses | The information about the default and custom opportunity statuses and their corresponding types. |
| OpportunityStatusesNames | The language-specific strings used for localization of fields. |
| OrganizationsAddresses | The physical address of the organization. |
| OrganizationsFileAttachments | The file attachment that includes additional fields used for attachments to various classes. |
| OrganizationsNotes | The note text associated with the objects such as contacts and organizations. |
| SalesProductsAdminVisibleInterfaces | The named ID that can be included in a list. |
| SalesProductsDescriptions | The language-specific string used for localization. |
| SalesProductsNames | The language-specific strings used for localization of fields. |
| SalesProductsSchedules | The price schedule for a sales product. |
| SalesTerritoriesAdminVisibleInterfaces | The named ID that can be included in a list. |
| SalesTerritoriesNames | The language-specific strings used for localization of fields. |
| ServiceCategoriesAdminVisibleInterfaces | The named ID that can be included in a list. |
| ServiceCategoriesDescriptions | The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field. |
| ServiceCategoriesEndUserVisibleInterfaces | The named ID that can be included in a list. |
| ServiceCategoriesNames | The language-specific strings used for localization of fields. |
| ServiceCategoriesProductLinks | The product linking for a category or a disposition. |
| ServiceDispositionsAdminVisibleInterfaces | The named ID that can be included in a list. |
| serviceDispositionsDescriptions | The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field. |
| ServiceDispositionsNames | The language-specific strings used for localization of fields. |
| ServiceDispositionsProductLinks | The product linking for a category or a disposition. |
| ServiceMailboxes | The email box dedicated to collect email inquiries sent by customers. |
| ServiceProductsAdminVisibleInterfaces | The named ID that can be included in a list. |
| ServiceProductsCategoryLinks | The category linking for a product. |
| ServiceProductsDescriptions | The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field. |
| ServiceProductsDispositionLinks | The disposition linking for a product. |
| ServiceProductsEndUserVisibleInterfaces | The named ID that can be included in a list. |
| ServiceProductsNames | The language-specific strings used for localization of fields. |
| SiteInterfaces | The console, windows, and pages used by staff members and customers to access the application and interact with a single knowledge base. |
| StandardContentsAdminVisibleInterfaces | The named ID that can be included in a list. |
| StandardContentsContentValues | The standard content value with a data type and a formatted data value. |
| TasksFileAttachments | The file attachment that includes additional fields used for attachments to various classes. |
| TasksNotes | The note text associated with the objects such as contacts and organizations. |
| VariablesInterfaceValues | The interface-specific value of a variable. |