Activity Creation (Oracle Field Service Initiated)
This section describes data mapping for the following:
sendresponse
Mapping details for “Send Response” activity are as shown in the table below.
Oracle Utilities Customer Cloud Service
Oracle Field Service Cloud
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM
Column 1
Column 2
 
$invokeSOMActivity
 
Outermosttag
update_PATCH
 
Outermosttag
 
 
 
 
D1-FARequestSynchronousResponse
$invokeSOMActivity
Group
TemplateParameters
update_PATCH
Group
 
 
 
 
D1-FARequestSynchronous
D1-FARequestSynchronousResponse
Group
 
 
 
 
 
 
 
request
D1-FARequestSynchronous
Group
 
 
 
 
 
 
 
relatedActivityId
request
String
activityId
TemplateParameters
Integer
 
 
 
 
response
D1-FARequestSynchronous
Group
activities.definitions.updateActivitySchema
update_PATCH
Group
 
 
 
 
referenceId
response
String
apptNumber
activities.definitions.updateActivitySchema
String
 
 
 
Only if ($invokeSOMActivity/nsmpr1:D1-FARequestSynchronousResponse/nsmpr2:D1-FARequestSynchronous/nsmpr2:response/nsmpr2:referenceId !='')
 
 
 
common_utilities_product_code
activities.definitions.updateActivitySchema
Field
 
 
 
Hardcoded as “OFSCCCS”
 
invokesomactivity
Mapping details for “Invoke SOM Activity” are as shown in the table below.
Oracle Utilities Customer 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
D1-FARequestSynchronous
 
Outermosttag
 
 
 
 
 
 
 
D1-FARequestSynchronous
D1-FARequestSynchronous
Group
 
 
 
 
 
 
 
request
D1-FARequestSynchronous
Group
 
 
 
 
 
 
 
sourceSystem
request
String
SOMOFSC_ConfigProps
PropertyName : som.externalsystem
Value : OFSC
Maps PropertyName Cloumn to the respective Value Column. Do not change the values in PropertyName column.
notify_POST
 
Group
 
 
 
 
 
 
 
events.definitions.activityEvent
notify_POST
Group
 
 
 
 
 
 
 
activityChanges
events.definitions.activityEvent
Group
 
 
 
 
 
 
 
activityType
activityChanges
String
taskType
request
String
SOMOFSC_ActivityType
OFSC_ActivityType
SOM_TaskType
Maps OFSC Activity type with SOM task type and vice versa.
c2m_service_pt_id
activityChanges
String
spId
request
String
 
 
 
Only if (/nssrcmpr:notify_POST/nssrcmpr:events.definitions.activityEvent/nsmpr0:activityChanges/nsmpr0:c2m_service_pt_id)
activityDetails
events.definitions.activityEvent
Group
 
 
 
 
 
 
 
activityId
activityDetails
Integer
relatedActivityId
request
String
 
 
 
 
 
 
 
externalActivityElement
request
Group
 
 
 
 
activityId
activityDetails
Integer
requesterTransactionId
externalActivityElement
String
 
 
 
 
 
 
 
startDateTime
externalActivityElement
Group
 
 
 
 
$dateTimeformat
 
Field
$dateTimeformat
startDateTime
Datetime
 
 
 
 
user
events.definitions.activityEvent
String
requesterUserId
externalActivityElement
String
 
 
 
 
ACTIVITY_NOTES
activityChanges
String
comments
externalActivityElement
String
 
 
 
 
 
 
 
addressConstituents
request
Group
 
 
 
 
country_code
activityChanges
String
country
addressConstituents
String
SOMOFSC_CountryCode
OFSC_CountryCode
SOM_CountryCode
Maps SOM Country Code to OFSC Country Code and vice versa.
postalCode
activityChanges
String
postal
addressConstituents
String
 
 
 
 
streetAddress
activityChanges
String
$address
addressConstituents
Field
 
 
 
 
string
 
Field
$CountVar
addressConstituents
Field
 
 
 
 
$address
 
Field
address1
addressConstituents
String
 
 
 
Only if ($CountVar=5 or $CountVar=4 or $CountVar=3 or $CountVar=2) Function : substring-before($address,', ')
$address
 
Field
address2
addressConstituents
String
 
 
 
Only if ($CountVar=5 or $CountVar=4 or $CountVar=3) Function : substring-before(substring-after($address,', '),', ')
$address
 
Field
address3
addressConstituents
String
 
 
 
Only if ($CountVar=5 or $CountVar=4) Function : substring-before(substring-after(substring-after($address,', '),', '),', ')
$address
 
Field
address4
addressConstituents
String
 
 
 
Only if ($CountVar=5) Function : substring-before(substring-after(substring-after(substring-after($address,', '),', '),', '),',')
city
activityChanges
String
city
addressConstituents
String
 
 
 
 
stateProvince
activityChanges
String
state
addressConstituents
String
 
 
 
 
latitude
activityChanges
Double
geocodeLatitude
addressConstituents
Decimal
 
 
 
 
longitude
activityChanges
Double
geocodeLongitude
addressConstituents
Decimal
 
 
 
 
 
 
 
contactDetails
request
Group
 
 
 
 
 
 
 
customerInformation
contactDetails
Group
 
 
 
 
customerName
activityChanges
String
customerName
customerInformation
String
 
 
 
 
customerPhone
activityChanges
String
mainPhone
customerInformation
String
 
 
 
 
customerCell
activityChanges
String
cellPhone
customerInformation
String
 
 
 
 
 
 
 
isAppointmentNecessary
customerInformation
String
SOMOFSC_ConfigProps
PropertyName : pickuporder.apptneeded
Value : N
Maps PropertyName Cloumn to the respective Value Column. Do not change the values in PropertyName column.
 
getactivity
Mapping details for “Get Activity” are as shown in the table below.
Oracle Utilities Customer 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
canonical_GET
 
Outermosttag
 
 
 
 
events.definitions.activityEvent
notify_POST
Group
TemplateParameters
canonical_GET
Group
 
 
 
 
activityDetails
events.definitions.activityEvent
Group
 
 
 
 
 
 
 
activityId
activityDetails
Integer
activityId
TemplateParameters
Integer