Process Service Call

This section describes data mapping for the following:

• Oracle Cloud Infrastructure Fault Mappings

• Oracle Utilities Work and Asset Cloud Service Send Positive Response

• Oracle Utilities Customer Cloud Service Update Service Call

• Oracle Utilities Customer Cloud Service Cancel Service Call

• Oracle Utilities Customer Cloud Service Create Service Call

• Oracle Cloud Infrastructure Remote Fault Mappings

Oracle Cloud Infrastructure Fault Mappings

The “FaultMappings” integration point details are as shown in the table below:

Oracle Cloud Infrastructure Fault Message			Oracle Utilities Customer Cloud Service Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Column 1	Column 2	Comments
requestMessage	request-wrapper	Group
serviceCallCommId	requestMessage	string	serviceCallCommId	TemplateParameters	string
			components.schemas.UPDATE_request	update	Group
serviceCallCommId	requestMessage	string	serviceCallCommId	components.schemas.UPDATE_request	string
			isInError	components.schemas.UPDATE_request	boolean				Hard coded as "true"
msg		Field	messageCategory	components.schemas.UPDATE_request	string				User Defined Func: getMessageCategory(msg)
msg		Field	messageNumber	components.schemas.UPDATE_request	string				User Defined Func: getMessageNumber(msg)
msg		Field	messageText	components.schemas.UPDATE_request	string				User Defined Func: getMessageText(msg)

Oracle Utilities Work and Asset Cloud Service Send Positive Response

The “sendPositiveResponse” integration point details are as shown in the table below:

Oracle Utilities Work and Asset Cloud Service Response Message			Oracle Utilities Customer Cloud Service Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Customer Cloud Service Column	Oracle Utilities Work and Asset Cloud Service Column	Comments
requestMessage	request-wrapper	Group
serviceCallCommId	requestMessage	string	serviceCallCommId	TemplateParameters	string
			components.schemas.UPDATE_request	update	Group
serviceCallCommId	requestMessage	string	serviceCallCommId	components.schemas.UPDATE_request	string
$invokeWAMCreateServiceCall		Group
createServiceCallResponse	$invokeWAMCreateServiceCall	Group
CREATESERVICECALL_response	createServiceCallResponse	Group
serviceCallId	CREATESERVICECALL_response	string	serviceCallId	components.schemas.UPDATE_request	string
serviceCallNumber	CREATESERVICECALL_response	string	serviceCallNumber	components.schemas.UPDATE_request	string
communicationId	CREATESERVICECALL_response	string	externalId	components.schemas.UPDATE_request	string

Oracle Utilities Customer Cloud Service Update Service Call

The “updateServiceCallMappings” integration point details are as shown in the table below:

Oracle Utilities Customer Cloud Service Request Message			Oracle Utilities Work and Asset Cloud Service Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Customer Cloud Service Column	Oracle Utilities Work and Asset Cloud Service Column	Comments
execute		Outermosttag	createCommunication		Outermosttag
request-wrapper	execute	Group	CREATECOMMUNICATION_request	createCommunication	Group
requestMessage	request-wrapper	Group
serviceCallCommId	requestMessage	string	communicationExternald	CREATECOMMUNICATION_request	string
comments	requestMessage	string	comments	CREATECOMMUNICATION_request	string
contactDetails	requestMessage	Group
contactFirstName	contactDetails	string	firstName	CREATECOMMUNICATION_request	string
contactLastName	contactDetails	string	lastName	CREATECOMMUNICATION_request	string
communicationType	contactDetails	string	communicationType	CREATECOMMUNICATION_request	string	OUTL-BRT-CCS_WACS_CommunicationType	CCS_Type	WACS_Type	This lookup transforms CCS communication type to WACS communication type and vice versa.
contactPrimaryPhone	contactDetails	string	primaryPhone	CREATECOMMUNICATION_request	string
contactHomePhone	contactDetails	string	homePhone	CREATECOMMUNICATION_request	string
contactMobilePhone	contactDetails	string	mobilePhone	CREATECOMMUNICATION_request	string
			originatingEntity	CREATECOMMUNICATION_request	Group
"W1WR"		Field	entityType	originatingEntity	string	OUTL-BRT-CCS_WACS_EntityType	CCS_Entity	WACS_Entity	This lookup transforms CCS entity type to WACSs entity type and vice versa.

Oracle Utilities Customer Cloud Service Cancel Service Call

The “cancelServiceCallMappings” integration point details are as shown in the table below:

Oracle Utilities Customer Cloud Service Request Message			Oracle Utilities Work and Asset Cloud Service Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Customer Cloud Service Column	Oracle Utilities Work and Asset Cloud Service Column	Comments
requestMessage	request-wrapper	Group
serviceCallId	requestMessage	string	serviceCallId	TemplateParameters	string
			CANCELSERVICECALL_request	cancelServiceCall	Group
serviceCallCommId	requestMessage	string	communicationExternald	CANCELSERVICECALL_request	string
comments	requestMessage	string	comments	CANCELSERVICECALL_request	string
contactDetails	requestMessage	Group
contactFirstName	contactDetails	string	firstName	CANCELSERVICECALL_request	string
contactLastName	contactDetails	string	lastName	CANCELSERVICECALL_request	string
communicationType	contactDetails	string	communicationType	CANCELSERVICECALL_request	string	OUTL-BRT-CCS_WACS_CommunicationType	CCS_Type	WACS_Type	This lookup transforms CCS communication type to WACS communication type and vice versa.
contactPrimaryPhone	contactDetails	string	primaryPhone	CANCELSERVICECALL_request	string
contactHomePhone	contactDetails	string	homePhone	CANCELSERVICECALL_request	string
contactMobilePhone	contactDetails	string	mobilePhone	CANCELSERVICECALL_request	string
serviceCallCancelReasonDescription	requestMessage	string	cancelReason	CANCELSERVICECALL_request	string

Oracle Utilities Customer Cloud Service Create Service Call

The “createServiceCallMappings” integration point details are as shown in the table below:

Oracle Utilities Customer Cloud Service Request Message			Oracle Utilities Work and Asset Cloud Service Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Customer Cloud Service Column	Oracle Utilities Work and Asset Cloud Service Column	Comments
execute		Outermosttag	createServiceCall		Outermosttag
request-wrapper	execute	Group	CREATESERVICECALL_request	createServiceCall	Group
requestMessage	request-wrapper	Group
serviceCallCommId	requestMessage	string	serviceCallExternalId	CREATESERVICECALL_request	string
description	requestMessage	string	description	CREATESERVICECALL_request	string
detailedDescription	requestMessage	string	detailedDescription	CREATESERVICECALL_request	string
serviceCategory	requestMessage	string	serviceCategory	CREATESERVICECALL_request	string	OUTL-BRT-CCS_WACS_ServiceCategory	CCS_ServiceCategory	WACS_ServiceCategory	Only if (/nssrcmpr:execute/nssrcdfl:request-wrapper/nssrcdfl:requestMessage/nssrcdfl:serviceCategory !='')
serviceCode	requestMessage	string	serviceCode	CREATESERVICECALL_request	string	OUTL-BRT-CCS_WACS_ServiceCode	CCS_ServiceCode	WACS_ServiceCode	Only if (/nssrcmpr:execute/nssrcdfl:request-wrapper/nssrcdfl:requestMessage/nssrcdfl:serviceCategory !='')
requiredByDate	requestMessage	string	requiredByDate	CREATESERVICECALL_request	string				Only if (/nssrcmpr:execute/nssrcdfl:request-wrapper/nssrcdfl:requestMessage/nssrcdfl:requiredByDate!='')
callBackRequired	requestMessage	string	callbackRequired	CREATESERVICECALL_request	string	OUTL-BRT-CCS_WACS_CallBackCode	CCS_CallBackCode	WACS_CallBackCode	Only if (/nssrcmpr:execute/nssrcdfl:request-wrapper/nssrcdfl:requestMessage/nssrcdfl:callBackRequired !='')
locationDetails	requestMessage	Group
wamNodeId	locationDetails	string	locationId	CREATESERVICECALL_request	string				Only if (/nssrcmpr:execute/nssrcdfl:request-wrapper/nssrcdfl:requestMessage/nssrcdfl:locationDetails/nssrcdfl:wamNodeId !='')
mdmSpId	locationDetails	string	locationExternalId	CREATESERVICECALL_request	string				Only if (/nssrcmpr:execute/nssrcdfl:request-wrapper/nssrcdfl:requestMessage/nssrcdfl:locationDetails/nssrcdfl:mdmSpId !='')
country	locationDetails	string	country	CREATESERVICECALL_request	string
address1	locationDetails	string	address1	CREATESERVICECALL_request	string
address2	locationDetails	string	address2	CREATESERVICECALL_request	string
address3	locationDetails	string	address3	CREATESERVICECALL_request	string
address4	locationDetails	string	address4	CREATESERVICECALL_request	string
crossStreet	locationDetails	string	crossStreet	CREATESERVICECALL_request	string
houseType	locationDetails	string	houseType	CREATESERVICECALL_request	string	OUTL-BRT-CCS_WACS_HouseType	CCS_HouseType	WACS_HouseType	This look up is used to transform ccs house type to wacs house type and vice versa.
number1	locationDetails	string	number1	CREATESERVICECALL_request	string
number2	locationDetails	string	number2	CREATESERVICECALL_request	string
geoCode	locationDetails	string	geographicCode	CREATESERVICECALL_request	string
city	locationDetails	string	city	CREATESERVICECALL_request	string
county	locationDetails	string	county	CREATESERVICECALL_request	string
state	locationDetails	string	state	CREATESERVICECALL_request	string
postal	locationDetails	string	postal	CREATESERVICECALL_request	string
latitude	locationDetails	string	latitude	CREATESERVICECALL_request	decimal
longitude	locationDetails	string	longitude	CREATESERVICECALL_request	decimal
contactDetails	requestMessage	Group
contactFirstName	contactDetails	string	firstName	CREATESERVICECALL_request	string
contactLastName	contactDetails	string	lastName	CREATESERVICECALL_request	string
contactPrimaryPhone	contactDetails	string	primaryPhone	CREATESERVICECALL_request	string
contactMobilePhone	contactDetails	string	mobilePhone	CREATESERVICECALL_request	string
contactHomePhone	contactDetails	string	homePhone	CREATESERVICECALL_request	string

Oracle Cloud Infrastructure Remote Fault Mappings

The “Remote Fault Mappings” integration point details are as shown in the table below:

Oracle Cloud Infrastructure Fault Message			Oracle Utilities Customer Cloud Service Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Customer Cloud Service Column	Oracle Utilities Work and Asset Cloud Service Column	Comments
requestMessage	request-wrapper	Group
serviceCallCommId	requestMessage	string	serviceCallCommId	TemplateParameters	string
			components.schemas.UPDATE_request	update	Group
serviceCallCommId	requestMessage	string	serviceCallCommId	components.schemas.UPDATE_request	string
			isInError	components.schemas.UPDATE_request	boolean				Hard coded as "true"
			messageCategory	components.schemas.UPDATE_request	string	OUTL-BRT-CCS_WACS_ConfigProps	PropertyName : ccs.remote.fault.messagecategory	Value : 22001	This lookup sets or unsets config properties
			messageNumber	components.schemas.UPDATE_request	string	OUTL-BRT-CCS_WACS_ConfigProps	PropertyName : ccs.remote.fault.messagenumber	Value : 2850	This lookup sets or unsets config properties.
			messageText	components.schemas.UPDATE_request	string				Hard coded as "Target application invocation issue : error code 500"