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” |
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. |
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 |