Work Order Activity Updated Field Mappings R13 (1.0)

The table in this topic details field mappings for when an activity is updated in Oracle Field Service. The fields are updated in Oracle Fusion Service through Oracle Integration.

Work Order Field Mapping

The following table shows the Oracle Field Service activity field mapping to the Oracle Fusion Service work order.

Oracle Fusion Service Attribute	Data Type	Oracle Field Service Property	Data Type	Condition
FsActivityId	Long	activityId	NA	NA
WoId	Long	apptNumber	String	NA
WoStatusCd	String	eventType	NA	Based on event in Oracle Field Service.
ScheduledDate	Date	date	String	NA
ScheduledTimeSlot	String	timeslot	String	NA
Duration	NA	duration	NA	NA
TravelTime	NA	traveltime	NA	NA
ContactName	String	customerName	String	NA
ContactEmail	String	customerEmail	String	NA
ContactPhoneNumber	String	customerPhone	String	NA
ContactAltPhoneNumber	String	customerCell	String	NA
Address1	String	streetAddress	String	NA
Address2	String	streetAddress	Null	NA
Address2	String	streetAddress	Null	NA
Address3	String	streetAddress	Null	NA
Address4	String	streetAddress	Null	NA
City	String	City	String	NA
PostalCode	String	postalCode	String	NA
State Province	String	stateProvince	String	NA
Country	String	country_code	String	NA
FsNote	String	wo_fs_note	String	NA
DeliveryWinStartDate	DateTime	deliveryWindowStart	NA	If deliveryWindowStart != "" Then concat( (substring(deliveryWindowStart,1,10),'T'), (substring(deliveryWindowStart,12,8),'Z'))
DeliveryWinStartEnd	DateTime	deliveryWindowEnd	NA	If deliveryWindowEnd != "" Then concat( (substring(deliveryWindowEnd,1,10),'T'), (substring(deliveryWindowEnd,12,8),'Z'))
ActualStartDate EstimatedStartTime	DateTime DateTime	startTime	NA	If startTime != "" Then concat((substring(startTime,1,10),'T'), (substring(startTime,12,8)),'Z'))
ActualEndDate	DateTime	endTime	NA	If endTime != "" Then concat((substring(endTime,1,10),'T'), (substring(endTime,12,8),'Z'))
BookedDate	DateTime	timeOfBooking	NA	If timeOfBooking != "" Then concat((substring(timeOfBooking,1,10),'T'), (substring(timeOfBooking,12,8),'Z'))
FsContactFlag	Boolean	NA	NA	If customerName is updated from Oracle Field Service Cloud, set to true.
WoIntegrationMsgCd	String	NA	NA	If update successful and no address fields were updated with NULL Then ORA_WO_INT_FS_UPDATE_RECEIVED Else ORA_WO_INT_MSG_FS_UPDATE_FAIL
WoIntegrationStatusCd	String	NA	NA	If update successful and no address fields were updated with ORA_WO_INT_FS_UPDATE_RECEIVED Then ORA_WO_INT_FS_UPDATE_RECEIVED Else ORA_WO_INT_FS_UPDATE_FAILED
FsResourceExternalId	String	resourceId	NA	NA
FsTechnicianLocatorUrl	String	wo_technician_locator_url	String	NA