Solution

The solution object stores information on solutions to customer problems or service requests. Solutions can be reused if the same problem is identified with a product or service. This prevents the duplication of work for customer service representatives.

Parent Object

Activity and Order Item

Child Component

Attachment and Order Item.

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

Methods Called

The following table details the methods called by the Solution service.

Table Methods Called by Solution Service

Method	Name as Defined in Service
Delete	SolutionDelete
DeleteChild	SolutionDeleteChild
Insert	SolutionInsert
InsertChild	SolutionInsertChild
InsertOrUpdate	SolutionInsertOrUpdate
QueryPage	SolutionQueryPage
Update	SolutionUpdate
UpdateChild	SolutionUpdateChild

Fields

The following table details the required and read-only fields for the solution object.

Table Required and Read-Only Fields for the Solution Object

Child Component	Field Name	Type
Solution (parent)	Title	Required
	Audit Fields	Read-only
	CreatorId	Read-only
	LastUpdated	Read-only
Attachment	DisplayFileName	Required
	FileNameOrURL	Required
	FileDate	Read-only
	FileSize	Read-only
	SolutionId	Read-only
	Id	Read-only
	ModId	Read-only
	Audit Fields	Read-only

The following table details the status key for the solution object.

Table Status Key for the Solution Object

Child Component	Field Name
Solution (parent)	Audit Fields
	ExternalSystemId
	Id
	IntegrationId
	LastUpdated
Attachment	Audit Fields
	Id
	SolutionId
ServiceRequest	Audit Fields
	ExternalSystemId
	Id
	IntegrationId
	LastUpdated

The following table provides a list of the filterable fields for the child components of the solution objects, and a list of user key combinations for each child component.

Table Filterable Fields and User Key Fields on the Solution Object’s Child Components

Child Components	Filterable Fields	User Key Field Combinations
Solution (parent)	All	SolutionId
		IntegrationId
		ExternalSystemId
Attachment	None	Id
		ExternalSystemId
		FileNameOrURL and FileExtension
Service Request	Subject	SRNumber
	Area	IntegrationId
	Owner	ExternalSystemId
	Priority
	Type
	Cause
	Source
	Status

The following table details the picklists available for the solution object.

Table Picklists Available for the Solution Object

Field Name
Area
Cause
Priority
Source
Status
Type

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

Related Topic

Service Request