Complete Activity (Oracle Field Service Initiated)

This section describes data mapping for the following:

• Get Master Activity Information

• Get Inventory Attachment

• Invoke Work and Asset Management Activity

• Invoke Work and Activity Management Activity 1

• Get Activity Details

• Get File Data

• Temporary Material Usage Variable

• Invoke Material Usage

Get Master Activity Information

Mapping details for “Get Master Activity Information” activity are as shown in the table below.

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
$getActivityDetails		Outermosttag	canonical_GET		Outermosttag
canonical_GETResponse	$getActivityDetails	Group	TemplateParameters	canonical_GET	Group
activities.definitions.getActivitySchema	canonical_GETResponse	Group
masterActivityId	activities.definitions.getActivitySchema	Integer	activityId	TemplateParameters	Integer

Get Inventory Attachment

Mapping details for “Get Inventory Attachment” activity are as shown in the table below.

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
		Outermosttag	get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_inventories_0x736c68__0x6c6362_inventoryId_0x726362__0x736c68__0x6c6362_propertyLabel_0x726362_		Outermosttag
			Template Parameters	get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_inventories_0x736c68__0x6c6362_inventoryId_0x726362__0x736c68__0x6c6362_propertyLabel_0x726362_	Group
			propertyLabel	TemplateParameters	String				concat('wam_upload_attachment_', $AL/nsmpr0:attachmentList/nsmpr0:wamUploadFileNumber)
$AL		Group
attachmentList	$AL	Group
inventoryId	attachmentList	Field	inventoryId	TemplateParameters	String

Invoke Work and Asset Management Activity

Mapping details for “Invoke Work and Asset Management Activity” activity are as shown in the table below.

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
notify_POST		Outermosttag	W1-MblActCom		Outermosttag
events.definitions.activityEvent	notify_POST	Group	W1-MblActCom	W1-MblActCom	Group
activityDetails	events.definitions.activityEvent	Group	input	W1-MblActCom	Group
apptNumber	activityDetails	String	activityId	input	String				Only if (not(contains(/nssrcmpr:notify_POST/nssrcmpr:events.definitions.activityEvent/ns25:activityDetails/ns25:apptNumber, '-')))
$getActivityDetails		Group
canonical_GETResponse	$getActivityDetails	Group
activities.definitions.getActivitySchema	canonical_GETResponse	Group
masterActivityId	activities.definitions.getActivitySchema	Integer	mobileActivityId	input	String				When ($getActivityDetails/nsmpr12:canonical_GETResponse/nsmpr12:activities.definitions.getActivitySchema/nsmpr3:masterActivityId)
activityId	activityDetails	Integer							Otherwise
string		Field	completionDateTime	input	Datetime
$XmlPayload		Group
parent	$XmlPayload	Group
root	parent	Group
crewName	root	Field	crewName	input	Field				Only if ($XmlPayload/parent/root/tns:crewName)
			completion	input	Group
assetLocationAsset List	root	Field	assetLocationAssets	completion	Field
serviceHistories		Group	assetLocationAssetList	assetLocationAssets	Group
serviceHistoryList	serviceHistories	Field	serviceHistories	assetLocationAssetList	Field				Only if (tns:serviceHistories/tns:serviceHistoryList)
serviceHistoryCompletion		Group	serviceHistoryList	serviceHistories	Group
attachments	serviceHistoryCompletion	Group	serviceHistoryCompletion	serviceHistoryList	Group
attachmentList	attachments	Field	attachments	serviceHistoryCompletion	Field				Only if (tns:serviceHistories/tns:serviceHistoryList)
			attachmentList	attachments	Group
bo		Field	$attachmentbo	attachmentList	Field				Only if (tns:serviceHistories/tns:serviceHistoryList)
lookupValue		Field	bo	attachmentList	Field				Only if (tns:serviceHistories/tns:serviceHistoryList)
			attachmentData	attachmentList	Group
externalAttachmentId		Field	$attachmentId	attachmentData	Field				Only if (tns:serviceHistories/tns:serviceHistoryList)
$XmlPayload		String	$handleTextDecoding	attachmentData	String	WAMOFSC_ConfigProps	PropertyName : wam.handleTextFileDecoding	Value : wam.handleTextFileDecoding.error	Function : decodeBase64($XmlPayload/parent/attList[attId=$attachmentId]/attData)
attData	attList[attId=$attachmentId]	Field							Otherwise and Only if (tns:serviceHistories/tns:serviceHistoryList)
attList[attId=$attachmentId]	parent	Group

Invoke Work and Activity Management Activity 1

Mapping details for “Invoke Work and Activity Management Activity 1” activity are as shown in the table below.

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
streamReference		String	$decoded_file_data		Field				Function : decodeBase64(oraext:encodeReferenceToBase64($getFileData/nsmpr2:get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_activities_0x736c68__0x6c6362_activityId_0x726362__0x736c68__0x6c6362_propertyLabel_0x726362_Response/nsmpr4:streamReference))
$getActivityDetails		Group	W1-MblActCom		Group
canonical_GETResponse	$getActivityDetails	Group	W1-MblActCom	W1-MblActCom	Group
activities.definitions.getActivitySchema	canonical_GETResponse	Group	input	W1-MblActCom	Group
apptNumber	activities.definitions.getActivitySchema	String	activityId	input	String
masterActivityId	activities.definitions.getActivitySchema	Integer	mobileActivityId	input	String				When ($getActivityDetails/nsmpr1:canonical_GETResponse/nsmpr1:activities.definitions.getActivitySchema/nsmpr3:masterActivityId)
activityId	activities.definitions.getActivitySchema	String							Otherwise
endTime	activities.definitions.getActivitySchema	String	completionDateTime	input	Datetime

Get Activity Details

Mapping details for “Get Activity Details” activity are as shown in the table below.

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
notify_POST		Outermosttag	canonical_GET		Outermosttag
events.definitions.activityEvent	notify_POST	Group	Template Parameters	canonical_GET	Group
activityDetails	events.definitions.activityEvent	Group
activityId	activityDetails	Integer	activityId	TemplateParameters	Integer

Get File Data

Mapping details for “Get File Data” activity are as shown in the table below.

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
$getActivityDetails		Outermosttag	get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_activities_0x736c68__0x6c6362_activityId_0x726362__0x736c68__0x6c6362_propertyLabel_0x726362_		Outermosttag
canonical_GETResponse	$getActivityDetails	Group	TemplateParameters	get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_activities_0x736c68__0x6c6362_activityId_0x726362__0x736c68__0x6c6362_propertyLabel_0x726362_	Group
activities.definitions.getActivitySchema	canonical_GETResponse	Group
activityId	activities.definitions.getActivitySchema	Integer	activityId	TemplateParameters	String
			propertyLabel	TemplateParameters	String				Set default value to "wam_activity_consolidated_inventories"

Temporary Material Usage Variable

Mapping details for “Temporary Material Usage Variable” activity are as shown in the table below.

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
		Outermosttag			Outermosttag

Invoke Material Usage

Mapping details for “Invoke Material Usage” activity are as shown in the table below.

Oracle Utilities Work and Asset Cloud Service			Oracle Field Service Cloud			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2
$inStoreroomMaterialUsage		Outermosttag	W1-ActMatUsg		Outermosttag
requestDetails	$inStoreroomMaterialUsage	Group	W1-ActMatUsg	W1-ActMatUsg	Group
			input	W1-ActMatUsg	Group
			requestDetails	input	Group
storeroomId	requestDetails	String	storeroomId	requestDetails	String
activityId	requestDetails	String	activityId	requestDetails	String
mobileActivityId	requestDetails	String	mobileActivityId	requestDetails	String
stockItems	requestDetails	Stockitemstype	employeeExternalId	requestDetails	Field
			stockItems	requestDetails	Group
stockItemDetailId		String	stockItemDetailId	stockItems	String
masterStockItemDetailId		String	masterStockItemDetailId	stockItems	String				Only if (tns:masterStockItemDetailId)
assetId		String	assetId	stockItems	String				Only if (tns:assetId)
quantity		Decimal	quantity	stockItems	Decimal