Oracle CRM On Demand Documentation Library: Activity

Oracle Web Services On Demand Guide > Oracle CRM On Demand Objects Accessible Through Web Services > Core Parent Objects (Web Services v1.0) >

Activity

The activity object stores information on an activity that a user must carry out, for example, a call-back activity for an account. When an activity is created, the user must set the Activity field explicitly to Task or Appointment.

Usage

Oracle On Demand Web Services uses activities to organize, track, and resolve a variety of tasks, from finding and pursuing opportunities to closing service requests. If a task requires multiple steps that one or more people can carry out, activities greatly simplify the job. Activities can help to:

Define and assign the task
Provide information to complete the task
Track the progress of the task
Track costs and bill for the task

Parent Objects

Account, Campaign, Contact, Lead, Opportunity, and Service Request

Child Components

Attachment, Book, Contact, ProductsDetailed, PromotionalItemsDropped, SampleDropped, Solution, and User.

For information about using attachments with this object, see Using Attachments with Web Services On Demand.

Methods Called

Table 193 details the methods called by the Activity service.

Table 193. Methods Called by Activity Service
Method	Name as Defined in Service
Delete	ActivityDelete
DeleteChild	ActivityDeleteChild
Insert	ActivityInsert
InsertChild	ActivityInsertChild
InsertOrUpdate	ActivityInsertOrUpdate
QueryPage	ActivityQueryPage
Update	ActivityUpdate
UpdateChild	ActivityUpdateChild

Fields

Table 194 details the required and read-only fields for the activity object.

Table 194. Required and Read-Only Fields for the Activity Object
Child Component	Field Name	Type
Activity (parent)	Subject	Required
	Activity	Required
	ActivityId	Read-only
	AddressId	Read-only
	CallType	Read-only
	ContactFirstName	Read-only
	ContactLastName	Read-only
	LeadFirstName	Read-only
	LeadLastName	Read-only
	MedEdEventName	Read-only
	OpportunityName	Read-only
	FundRequest	Read-only
	SmartCall	Read-only
	AssignedQueue	Read-only
	QueueHoldTime	Read-only
	QueueStartTime	Read-only
	TotalHoldTime	Read-only
	ResolutionCode	Read-only
	Audit Fields	Read-only
Attachment	DisplayFileName	Required
	FileNameOrURL	Required
	FileDate	Read-only
	FileSize	Read-only
	ActivityId	Read-only
	Id	Read-only
	ModId	Read-only
	Audit Fields	Read-only
Book	BookName	Required
	BookId	Read-only
	SystemAssociateFlag	Read-only
	ModId	Read-only
	Audit Fields	Read-only
Contact	ContactId	Read-only
	ContactFirstName	Read-only
	ContactLastName	Read-only
	ContactAccountId	Read-only
	ContactAccountName	Read-only
	ContactAccountLocation	Read-only
	ContactAccountIntegrationId	Read-only
	ContactAccountExternalSystemId	Read-only
	Audit Fields	Read-only
ProductDetailed	ProductId	Required
	Indication	Required
	ProductDetailedId	Read-only
PromotionalItemDropped	ProductName	Required
	Quantity	Required
	ProductAllocationId	Required
	Audit Fields	Read-only
SampleDropped	ProductId	Required
	Quantity	Required
	SampleDroppedId	Read-only
	Audit Fields	Read-only
User	UserId	Read-only
	UserEmail	Read-only
	UserFirstName	Read-only
	UserLastName	Read-only
	UserRole	Read-only
	Audit Fields	Read-only

Table 195 details the status key for the activity object.

Table 195. Status Key for the Activity Object
Child Component	Field Name
Activity (parent)	Audit Fields
	ActivityId
	ExternalSystemId
	IntegrationId
Attachment	Audit Fields
	Id
	ActivityId
Book	Audit Fields
	BookId
	ModId
Contact	Audit Fields
	ActivityContactId
	ContactIntegrationId
	ContactExternalSystemId
	ContactId
User	Audit Fields
	UserId
	UserExternalSystemId
	UserIntegrationId
ProductDetailed	Audit Fields
	ProductDetailedId
	ExternalId
SampleDropped	Audit Fields
	SampleDroppedId
	ExternalId
Solution	Audit Fields
	SolutionId
	ExternalId

Table 196 details the pick map fields for the activity object and the child objects on which they reside.

Table 196. Pick Map Fields for the Activity Object
Child Component	Pick Map Field	Maps To
Activity (parent)	AccountName	AccountId
	AccountLocation	AccountId
	AccountExternalSystemId	AccountId
	AccountIntegration	AccountId
	Owner	OwnerId
	CampaignExternalSystemId	CampaignId
	CampaignIntegrationId	CampaignId
	CampaignName	CampaignId
	LeadExternalSystemId	LeadId
	LeadIntegrationId	LeadId
	MedEdEventExternalSystemId	MedEdEventId
	MedEdEventIntegrationId	MedEdEventId
	OpportunityExternalSystemId	OpportunityId
	OpportunityIntegrationId	OpportunityId
	PortfolioExternalSystemId	PortfolioId
	PortfolioIntegrationId	PortfolioId
	ServiceRequestNumber	ServiceRequestId
	ServiceRequestExternalSystemId	ServiceRequestId
	ServiceRequestIntegrationId	ServiceRequestId
	FundRequestExternalSystemId	FundRequestId
	FundRequestIntegrationId	FundRequestId
Book	BookName	BookId
Contact	ContactExternalId	ContactId
Contact	ContactIntegrationId	ContactId
User	UserExternalSystemId	UserId
User	UserIntegrationId	UserId
SampleDropped	ProductIntegrationId	ProductId
SampleDropped	ProductExternalSystemId	ProductId
ProductDetailed	ProductIntegrationId	ProductId
ProductDetailed	ProductExternalSystemId	ProductId
PromotionalItemDropped	ProductName	ProductId
	ProductIntegrationId	ProductId
	ProductExternalSystemId	ProductId
Solution	ProductIntegrationId	ProductId
Solution	ProductExternalSystemId	ProductId

Table 197 provides a list of the filterable fields for the child components of the activity objects, and a list of the user key combinations for each child component.

Table 197. Filterable Fields and User Key Fields on the Activity Object's Child Components
Child Components	Filterable Fields	User Key Field Combinations
Activity (parent)	All	ActivityId
		IntegrationId
		ExternalSystemId
Attachment	None	Id
		ExternalSystemId
		FileNameOrURL and FileExtension
Book	None	BookId
Book	None	BookName
Contact	ContactId	ContactId
	ContactExternalSystemId	ContactExternalSystemId
	ContactIntegrationId	ContactIntegrationId
	ContactFirstName
	ContactLastName
	ContactAccountId
	ContactAccountName
	ContactAccountLocation
	ContactAccountIntegrationId
	ContactAccountExternalSystemId
	ModifiedDate
ProductDetailed	ProductDetailedId	ProductDetailedId
	ProductDetailedExternalSystemId	ProductDetailedExternalSystemId
	ProductId	ProductId
	ProductExternalSystemId	ProductExternalSystemId
	ModifiedDate	Name
	ModifiedDate	Indication
SampleDropped	SampleDroppedId	SampleDroppedId
	SampleDroppedExternalSystemId	SampleDroppedExternalSystemId
	ProductId	ProductId
	ProductExternalSystemId	ProductExternalSystemId
	ModifiedDate	Quantity
	ModifiedDate	ProductName
Solution	SolutionId	SolutionId
	SolutionExternalSystemId	SolutionExternalSystemId
	ModifiedDate
	ProductLine
	PrimaryProductName
	Name
	ProductId
	ProductIntegrationId
	ProductExternalId
User	ModifiedDate	UserId
	UserId	UserExternalSystemId
	UserExternalSystemId	UserIntegrationId
	UserIntegrationId
	UserEmail
	UserFirstName
	UserLastName
	UserRole

Table 198 details the picklists available for the activity object.

Table 198. Picklists Available for the Activity Object
Field Name
AccountName
AccountLocation
AccountIntegrationId
AccountExternalSystemId
OpportunityName
ServiceRequestNumber
ServiceRequestIntegrationId
ServiceRequestExternalSystemId
DelegatedByExternalSystemId
PrimaryContactIntegrationId
PrimaryContactExternalSystemId
MedEdEventIntegrationId
MedEdEventExternalSystemId
FundRequestExternalId
LeadIntegrationId
LeadExternalSystemId
CampaignIntegrationId
CampaignExternalSystemId
ActivitySubtype
ResolutionCode
PublishInternal
Status NOTE: The Status picklist is editable for users whose role includes the Customize Application - Edit Activity 'Status' Picklist privilege.
Issue
Indication

For more information on the fields accessible through the Activity Web service, go to the Web Services Administration page within the Oracle CRM On Demand application, and generate the WSDL file for the activity object.

Oracle Web Services On Demand Guide, Version 24.0 (Oracle CRM On Demand Release 36)		Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.