Appointment Request (Oracle Utilities Service Order Management Initiated)

This section describes data mapping for the following:

Request Mappings

The request mapping details in the Appointment Request integration point are shown in the table below.

Oracle Utilities Service Order Management Request Message			Oracle Field Service Request Message (Activity Booking Options)			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Service Order Management Column	Oracle Field Service Column
sendDetail	sendDetail	outermosttag	QueryParameters		outermosttag
startDateTime	sendDetail		dates	QueryParameters					Concat start date and end date and take only substring from 1,10 Use comma as delimeter
endDateTime	sendDetail		dates	QueryParameters
postal	sendDetail		postalCode	QueryParameters
criteria	sendDetail
appointmentBookingGroup	sendDetail
maxAppointmentWindowCount	sendDetail
maxCostUnits	sendDetail
timeZone	sendDetail
taskType	sendDetail		activityType	QueryParameters	string	SOMOFSC_ActivityType.dvm	SOM_ActivityType	OFSC_ActivityType
serviceArea	sendDetail
geocodeLatitude	sendDetail
geocodeLongitude	sendDetail
duration	sendDetail
address1	sendDetail
address2	sendDetail
address3	sendDetail
address4	sendDetail
crossStreet	sendDetail
city	sendDetail
stateProvince	sendDetail
suburb	sendDetail
postal	sendDetail		postalCode	QueryParameters	string
country	sendDetail
matchQuality	sendDetail
siteDelay	sendDetail
hostExternalId	sendDetail

Response Mappings

The response mapping details in the Appointment Request integration point are shown in the table below.

Oracle Field Service Response Message (Activity Booking Options)			Oracle Utilities Service Order Management Response			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Service Order Management Column	Oracle Field Service Column
activityBookingOptions			responseDetail		outermosttag
dates	activityBookingOptions	List
areas	dates	List
timeslots	areas	List	appointmentBookingsList	responseDetail	list
label	timeslots	string	shiftId	appointmentBookingsList	string
date	dates		arrivalDateTime	appointmentBookingsList		OFSCSOM_Appt_Timeslots	SOM_TimeSlots	OFSC_TimeSlots	Concat date '-' with the value coming from Dvm Lookup dvm with 'label' value and use only start time Once you extract the start time, translate to the desired format HH:MM:SS Use SOMOFSC_Appt_StartTime extension library function
date	dates		completionDateTime	appointmentBookingsList		OFSCSOM_Appt_ Timeslots	SOM_TimeSlots	OFSC_TimeSlots	Concat date '-' with the value coming from Dvm Lookup dvm with label value and use only end time Use SOMOFSC_Appt_EndTime extension library function
			rank	appointmentBookingsList					Add position() function in the mappin
remainingQuota	timeslots		units	appointmentBookingsList
date	dates		appointmentWindowDateTime	appointmentBookingsList		OFSCSOM_Appt_ Timeslots	SOM_TimeSlots	OFSC_TimeSlots	Concat date '- with the value coming from Dvm Lookup dvm with label value and use only start time Use SOMOFSC_Appt_StartTime extension library function
date	dates		appointmentWindowDuration	appointmentBookingsList		OFSCSOM_Appt_ Timeslots	OFSC_TimeSlots	Duration_InSeconds	Map the value comes from Dvm
			action	appointmentBookingsList
			messageText	responseDetail
			messageCategory	responseDetail
			messageNumber	responseDetail
			messageParameters	responseDetail

Remote Fault

The remote fault mapping details in the Appointment Request integration point are shown in the table below.

Oracle Integration for Cloud Global Fault			Oracle Utilities Service Order Management Response Message
Element Name	Parent Element	Type	Element Name	Parent Element	Type
fault		OutermostTag	responseDetail		OutermostTag
details	fault	String
			appointmentBookingsList	responseDetail
			shiftId	appointmentBookingsList
			arrivalDateTime	appointmentBookingsList
			completionDateTime	appointmentBookingsList
			rank	appointmentBookingsList
			units	appointmentBookingsList
			appointmentWindowDateTime	appointmentBookingsList
			appointmentWindowDuration	appointmentBookingsList
			action	appointmentBookingsList
reason	fault	String	messageText	responseDetail
			messageCategory	responseDetail
			messageNumber	responseDetail
			messageParameters	responseDetail
			fault	responseDetail
errorCode	fault	String	faultCode	fault
			faultString	fault
			faultActor	fault
			details

Sub Language Fault

The sub language fault mapping details in the Appointment Request integration point are shown in the table below.

Oracle Integration for Cloud Global Fault			Oracle Utilities Service Order Management Request Message
Element Name	Parent Element	Type	Element Name	Parent Element	Type
fault		OutermostTag	responseDetail		OutermostTag
details	fault	String
			appointmentBookingsList	responseDetail	List
			shiftId	appointmentBookingsList
			arrivalDateTime	appointmentBookingsList
			completionDateTime	appointmentBookingsList
			rank	appointmentBookingsList
			units	appointmentBookingsList
			appointmentWindowDateTime	appointmentBookingsList
			appointmentWindowDuration	appointmentBookingsList
			action	appointmentBookingsList
reason	fault	String	messageText	responseDetail
			messageCategory	responseDetail
			messageNumber	responseDetail
			messageParameters	responseDetail
			fault	responseDetail
errorCode	fault	String	faultCode	fault
			faultString	fault
			faultActor	fault
			details