Oracle Utilities Work and Asset Cloud Service | Oracle Field Service Request Message | DVM Mapping/OIC Library | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM | Oracle Utilities Work and Asset Management Column | Oracle Field Service Column | |
OFSC_INT_WO_PA | OutermostTag | POST | OutermostTag | ||||||
components.schemas.request-wrapper | POST | Group | |||||||
sendDetails | OFSC_INT_WO_PA | ||||||||
activity | sendDetails | ||||||||
activityDetails | activity | ||||||||
mobileActivityId | activityDetails | String | activityId | components.schemas.request-wrapper | String | ||||
activityId | activity | String | wamActivityId | components.schemas.request-wrapper | String | ||||
Oracle Utilities Work and Asset Cloud Service | Oracle Field Service Cloud | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM | Column 1 | Column 2 | |
$InvokePullUpdateFlow | Outermosttag | OFSC_INT_WO_PAResponse | Outermosttag | ||||||
POSTResponse | $InvokePullUpdateFlow | Group | responseDetails | OFSC_INT_WO_PAResponse | Group | ||||
components.schemas.response-wrapper | POSTResponse | Group | |||||||
wamActivityId | components.schemas.response-wrapper | String | externalActivityId | responseDetails | String | ||||
Oracle Utilities Work and Asset Cloud Service | Oracle Field Service Cloud | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM | Column 1 | Column 2 | |
$searchActivity | Outermosttag | execute | Outermosttag | ||||||
search_GETResponse | $searchActivity | Group | TemplateParameters | execute | Group | ||||
activities.definitions.activities | search_GETResponse | Group | |||||||
items | activities.definitions.activities | Group | |||||||
activityId | items | Integer | activityId | TemplateParameters | String | ||||
Oracle Utilities Work and Asset 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 | Fault | Field | Only if ($cancelActivity/nsmpr0:executeResponse/ns30:response-wrapper/ns30:detail!='') Hardcoded as N | ||||||
Fault/ResponseCode | Field | Hardcoded as "CANCELED_CODE" | |||||||
$cancelActivity | Group | ||||||||
executeResponse | $cancelActivity | Group | |||||||
response-wrapper | executeResponse | Group | |||||||
detail | response-wrapper | String | Fault/ResponseText | Field | |||||
Oracle Utilities Work and Asset 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 | Fault/ResponseStatus | Field | Hardcoded as "N" | ||||||
$cancelScopeFaultObject | Group | ||||||||
fault | $cancelScopeFaultObject | Group | |||||||
errorCode | fault | Field | Fault/ResponseCode | Field | |||||
details | fault | Field | Fault/ResponseText | Field | |||||
Oracle Utilities Work and Asset 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 | Fault/ResponseCode | Field | Hardcoded as RESPONSECODE | ||||||
Fault | Field | When ($CurrentFaultObject/nsmpr0:APIInvocationError/nsmpr0:errorDetails/nsmpr0:errorCode=400 and contains($CurrentFaultObject/nsmpr0:APIInvocationError/nsmpr0:errorDetails,'Action on past date')) Hardcoded as Action on past date is not allowed | |||||||
Otherwise and Only if (contains($CurrentFaultObject/nsmpr0:APIInvocationError/nsmpr0:errorDetails,'Activity with this status')) Hardcoded as Activity with this status cannot execute this action | |||||||||
Oracle Utilities Work and Asset 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 | Fault/ResponseCode | Field | Hardcoded as RESPONSECODE | ||||||
Fault/ResponseText | Field | Hardcoded as The Activity is not found in OFS, Please check if the activity is existing in OFS before cancelling the activity. | |||||||
Oracle Utilities Work and Asset Cloud Service | Oracle Field Service Cloud | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM | Column 1 | Column 2 | |
$ofscActivityResp | Outermosttag | OFSC_INT_WO_PAResponse | Outermosttag | ||||||
bulkUpdate_POSTResponse | $ofscActivityResp | Group | responseDetails | OFSC_INT_WO_PAResponse | Group | ||||
activities.definitions.customActionActivityBulkUpdateSchemaResponse | bulkUpdate_POSTResponse | Group | |||||||
results | activities.definitions.customActionActivityBulkUpdateSchemaResponse | Group | |||||||
activityKeys | results | Group | |||||||
activityId | activityKeys | Integer | externalActivityId | responseDetails | String | ||||
Oracle Utilities Work and Asset 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 | search_GET | Outermosttag | |||||||
QueryParameters | search_GET | Group | |||||||
searchInField | QueryParameters | String | Hardcoded as "apptNumber" | ||||||
OFSC_INT_WO_PA | Group | ||||||||
sendDetails | OFSC_INT_WO_PA | Group | |||||||
activity | sendDetails | Group | |||||||
activityId | activity | String | searchForValue | QueryParameters | String | ||||
Token | dateFrom | QueryParameters | String | Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "search.dateFrom", "Value", "" ) | |||||
dateTo | QueryParameters | String | Function : substring-before (string (fn:current-date() ), "Z" ) | ||||||
limit | QueryParameters | Integer | Hardcoded as "1" | ||||||
Oracle Utilities Work and Asset Cloud Service | Oracle Field Service Cloud | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM | Column 1 | Column 2 | |
$ofscActivityResp | Outermosttag | update_PATCH | Outermosttag | ||||||
bulkUpdate_POSTResponse | $ofscActivityResp | Group | TemplateParameters | update_PATCH | Group | ||||
activities.definitions.customActionActivityBulkUpdateSchemaResponse | bulkUpdate_POSTResponse | Group | |||||||
results | activities.definitions.customActionActivityBulkUpdateSchemaResponse | Group | |||||||
activityKeys | results | Group | |||||||
activityId | activityKeys | Integer | activityId | TemplateParameters | Integer | ||||
activities.definitions.updateActivitySchema | update_PATCH | Group | |||||||
$elemName | activities.definitions.updateActivitySchema | Field | concat('WE_', $currentEquipment/ns1:equipmentList/ns1:equipmentCode, '_Nd') | ||||||
$currentEquipment | Group | ||||||||
equipmentList | $currentEquipment | Group | |||||||
quantity | equipmentList | Double | element | activities.definitions.updateActivitySchema | Field | Function : number(ceiling($currentEquipment/ns1:equipmentList/ns1:quantity)) | |||
Oracle Utilities Work and Asset 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 | bulkUpdate_POST | Outermosttag | |||||||
activities.definitions.customActionActivityBulkUpdateSchema | bulkUpdate_POST | Group | |||||||
updateParameters | activities.definitions.customActionActivityBulkUpdateSchema | Group | |||||||
identifyActivityBy | updateParameters | String | Set Default value to "activityId" | ||||||
Activities.definitions.customactionactivitybulkupdateschema.updateparameters | Set Default value to "doNothing" | ||||||||
inventoryPropertiesUpdateMode | updateParameters | Field | Set Default value to "keepProperties" | ||||||
OFSC_INT_WO_PA | Group | activities | activities.definitions.customActionActivityBulkUpdateSchema | Group | |||||
sendDetails | OFSC_INT_WO_PA | Group | |||||||
activity | sendDetails | Group | |||||||
activityDetails | activity | Group | |||||||
locationInformation | activityDetails | Group | |||||||
serviceArea | locationInformation | String | resourceId | activities | String | WAMOFSC_ServiceArea | Service_Area | Bucket_Name | When (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:serviceArea !='') and Only if (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:action != 'W1UP') |
WAMOFSC_ConfigProps | PropertyName : ofsc.bucket | Value : ofsc.bucket.error | Otherwise and Only if (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:action != 'W1UP') | ||||||
activityId | activity | String | apptNumber | activities | String | ||||
activityType | activityDetails | String | activityType | activities | String | WAMOFSC_ActivityType | WAM_ActType | OFSC_ActType | Only if (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:activityType) |
mobileActivityId | activityDetails | String | activityId | activities | Integer | Only if (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:mobileActivityId !='') | |||
nodeId | locationInformation | String | wam_activity_node_id | activities | Field | ||||
location | locationInformation | Group | |||||||
address1, | location | Group | |||||||
OFSC_INT_WO_PA | address1, | Group | |||||||
address2, | location | Group | |||||||
OFSC_INT_WO_PA | address2, | Group | |||||||
address3, | location | Group | |||||||
OFSC_INT_WO_PA | address3, | Group | |||||||
address4 | location | String | streetAddress | activities | String | Function : nsmpr2:WAMOFSC_ConcatAddress(/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:location/nsmpr0:address1, /nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:location/nsmpr0:address2, /nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:location/nsmpr0:address3, /nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:location/nsmpr0:address4) | |||
city | location | String | city | activities | String | ||||
postal | location | String | postalCode | activities | String | ||||
state | location | String | stateProvince | activities | String | ||||
geocodeLongitude | locationInformation | Decimal | longitude | activities | Double | Only if (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:geocodeLatitude and /nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:geocodeLongitude and not(number(/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:geocodeLatitude) = 0 and number(/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:geocodeLongitude) = 0)) | |||
geocodeLatitude | locationInformation | Decimal | latitude | activities | Double | Only if (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:geocodeLatitude and /nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:geocodeLongitude and not(number(/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:geocodeLatitude) = 0 and number(/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:locationInformation/nsmpr0:geocodeLongitude) = 0)) | |||
substring | Field | slaWindowStart | activities | String | Only if (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:windowStartDateTime) | ||||
substring | Field | slaWindowEnd | activities | String | Only if (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:windowEndDateTime) | ||||
timeZone | activities | String | WAMOFSC_ConfigProps | PropertyName : wam.timeZoneIANA | Value : wam.timeZoneIANA.error | Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column. | |||
info | activityDetails | String | wam_work_activity_info | activities | String | ||||
workorderdetails | activityDetails | Group | |||||||
description | workorderdetails | String | wam_work_order_desc | activities | String | ||||
description | activityDetails | String | wam_activity_desc | activities | String | ||||
longDescription | activityDetails | String | wam_activity_long_desc | activities | String | ||||
wam_emergency_indicator | activities | String | Hardcoded as 'Yes' | ||||||
info | locationInformation | String | wam_activity_location_info | activities | String | ||||
totalPriority | activityDetails | Decimal | wam_total_priority | activities | String | ||||
requiredByDate | activityDetails | Date | wam_required_by_date | activities | String | Only if (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:requiredByDate) | |||
requestorInfo | activityDetails | String | wam_requestor_info | activities | String | ||||
activityTypeDesc | activityDetails | String | wam_activity_type_desc | activities | String | ||||
workOrderId | workorderdetails | String | wam_work_order_id | activities | String | ||||
workOrderNumber | workorderdetails | String | wam_work_order_number | activities | String | ||||
assetLocationAssets | activityDetails | Group | |||||||
assetLocationAssetList[1] | assetLocationAssets | Group | |||||||
assetDetails | assetLocationAssetList[1] | Group | |||||||
info | assetDetails | String | wam_activity_asset_info | activities | String | ||||
wam_activity_length | activities | Field | concat($hrs, " hour") | ||||||
common_utilities_product_code | activities | Field | WAMOFSC_ConfigProps | PropertyName : source.system | Value : source.system.error | Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column. | |||
equipmentGroup | String | wam_equipment_group | activities | String | Function : get-content-as-string(/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:equipmentGroup) | ||||
laborGroup | String | wam_labor_group | activities | String | Function : get-content-as-string(/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:laborGroup) | ||||
otherGroup | String | wam_other_group | activities | String | Function : get-content-as-string(/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:otherGroup) | ||||
storeroomGroup | String | wam_storeroom_group | activities | String | Function : get-content-as-string(/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:storeroomGroup) | ||||
serviceHistoryTypes | String | $wamSHTStr | activities | Field | Function : get-content-as-string(/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:serviceHistoryTypes) | ||||
$wamSHTStr | Field | $msgSize | activities | Field | Function : string-length($wamSHTStr) | ||||
$msgSize div 1024 | Field | $sizeInKB | activities | Field | |||||
$sht_node | Group | ||||||||
sht_text[1] | $sht_node | Field | wam_service_history_types1 | activities | String | Only if ($sht_node/sht_text[1]) | |||
sht_text[2] | $sht_node | Field | wam_service_history_types2 | activities | String | Only if ($sht_node/sht_text[2]) | |||
sht_text[3] | $sht_node | Field | wam_service_history_types3 | activities | String | Only if ($sht_node/sht_text[3]) | |||
sht_text[4] | $sht_node | Field | wam_service_history_types4 | activities | String | Only if ($sht_node/sht_text[4]) | |||
sht_text[5] | $sht_node | Field | wam_service_history_types5 | activities | String | Only if ($sht_node/sht_text[5]) | |||
sht_text[6] | $sht_node | Field | wam_service_history_types6 | activities | String | Only if ($sht_node/sht_text[6]) | |||
sht_text[7] | $sht_node | Field | wam_service_history_types7 | activities | String | Only if ($sht_node/sht_text[7]) | |||
sht_text[8] | $sht_node | Field | wam_service_history_types8 | activities | String | Only if ($sht_node/sht_text[8]) | |||
sht_text[9] | $sht_node | Field | wam_service_history_types9 | activities | String | Only if ($sht_node/sht_text[9]) | |||
sht_text[10] | $sht_node | Field | wam_service_history_types10 | activities | String | Only if ($sht_node/sht_text[10]) | |||
validServiceHistoryTypes | String | wam_valid_service_history_types | activities | String | Function : get-content-as-string(/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:validServiceHistoryTypes) | ||||
enable_lock_plugin | activities | Field | Function : nsmpr3:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "lock.functionality", "Value", "" ) | ||||||
assetLocationAssetList | assetLocationAssets | Field | inventories | activities | Activities.definitions.activityinventories | Only if (((/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:assetLocationAssets/nsmpr0:assetLocationAssetList != '') or (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:issuedAssets/nsmpr0:issuedAsset != ''))) | |||
items | inventories | Group | |||||||
inventoryType | items | String | WAMOFSC_ConfigProps | PropertyName : asset.inventory.type | Value : asset.inventory.type.error | Only if (((/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:assetLocationAssets/nsmpr0:assetLocationAssetList != '') or (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:issuedAssets/nsmpr0:issuedAsset != ''))) | |||
assetId | String | serialNumber | items | String | When (nsmpr0:assetId) and Only if (((/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:assetLocationAssets/nsmpr0:assetLocationAssetList != '') or (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:issuedAssets/nsmpr0:issuedAsset != ''))) | ||||
nodeId | String | Otherwise and Only if (((/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:assetLocationAssets/nsmpr0:assetLocationAssetList != '') or (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:issuedAssets/nsmpr0:issuedAsset != ''))) | |||||||
activityId | activity | String | wam_activity_id | items | Field | Only if (((/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:assetLocationAssets/nsmpr0:assetLocationAssetList != '') or (/nssrcmpr:OFSC_INT_WO_PA/nsmpr0:sendDetails/nsmpr0:activity/nsmpr0:activityDetails/nsmpr0:issuedAssets/nsmpr0:issuedAsset != ''))) | |||
validMeasurementTypes | String | wam_valid_measurement_types | items | String | Function : get-content-as-string(nsmpr0:validMeasurementTypes) | ||||
assetDetails | Group | ||||||||
serialNo | assetDetails | String | ITEM_NUMBER | items | String | Only if (nsmpr0:validMeasurementTypes != '') | |||
nodeId | String | wam_node_id | items | String | Only if (nsmpr0:validMeasurementTypes != '') | ||||
seq | Decimal | wam_asset_seq | items | Field | Only if (nsmpr0:validMeasurementTypes != '') | ||||
attachedToAssetId | assetDetails | Field | wam_attached_to_asset_id | items | Field | Only if (nsmpr0:validMeasurementTypes != '') | |||
wam_asset_installed_in_ofsc | items | Field | Hardcoded as 'NO' | ||||||
wam_asset_or_component | items | Field | When (nsmpr0:assetDetails/nsmpr0:isComponent='W1YS') and Only if (nsmpr0:validMeasurementTypes != '') Hardcoded as 'C' | ||||||
Otherwise and Only if (nsmpr0:validMeasurementTypes != '') Hardcoded as 'A' | |||||||||
otherAssetsAtLocation | String | wam_other_assets | items | Field | Function : get-content-as-string(nsmpr0:otherAssetsAtLocation) | ||||
locationInformation | Group | ||||||||
isAssetLocation | locationInformation | Field | wam_is_asset_location | items | Field | Only if (nsmpr0:otherAssetsAtLocation/nsmpr0:assetList) | |||
attachedToAssetId | assetDetails | Field | $wamAttachedToAssetId | items | Field | Only if (nsmpr0:otherAssetsAtLocation/nsmpr0:assetList) | |||
assetId= $wamAttachedToAssetId] | assetLocationAssets | Group | |||||||
assetDetails | assetId= $wamAttachedToAssetId] | Group | |||||||
info | assetDetails | String | wam_attached_to_asset_info | items | Field | Only if (nsmpr0:otherAssetsAtLocation/nsmpr0:assetList) | |||
maybeLeftInPlace | assetDetails | Field | wam_asset_maybeLeftInPlace | items | Field | Only if (nsmpr0:otherAssetsAtLocation/nsmpr0:assetList) | |||
info | assetDetails | String | wam_asset_info | items | String | Only if (nsmpr0:otherAssetsAtLocation/nsmpr0:assetList) | |||
badgeNo | String | wam_badge_number | items | String | Only if (nsmpr0:otherAssetsAtLocation/nsmpr0:assetList) | ||||
validServiceHistoryTypes | String | wam_asset_valid_service_history_types | items | String | Function : get-content-as-string(nsmpr0:validServiceHistoryTypes) | ||||
failureInformation | String | wam_failure_info | items | String | Function : get-content-as-string(nsmpr0:failureInformation) | ||||
info | locationInformation | String | wam_asset_location_info | items | String | Only if (nsmpr0:otherAssetsAtLocation/nsmpr0:assetList) | |||
building | locationInformation | String | wam_asset_location_building | items | String | Only if (nsmpr0:otherAssetsAtLocation/nsmpr0:assetList) | |||
room | locationInformation | String | wam_asset_location_room | items | String | Only if (nsmpr0:otherAssetsAtLocation/nsmpr0:assetList) | |||
runToFailure | locationInformation | String | wam_asset_location_runToFailure | items | String | Only if (nsmpr0:locationInformation/nsmpr0:runToFailure and nsmpr0:otherAssetsAtLocation/nsmpr0:assetList) | |||
siteLocation | locationInformation | String | wam_asset_location_siteLocation | items | String | Only if (nsmpr0:locationInformation/nsmpr0:runToFailure) | |||
pointId | locationInformation | String | wam_asset_location_pointId | items | String | Only if (nsmpr0:locationInformation/nsmpr0:runToFailure) | |||
serviceAreaDescription | locationInformation | String | wam_asset_location_serviceArea | items | String | Only if (nsmpr0:locationInformation/nsmpr0:runToFailure) | |||
assetId | String | wam_asset_id | items | String | Only if (nsmpr0:locationInformation/nsmpr0:runToFailure) | ||||
description | assetDetails | String | wam_asset_desc | items | String | Only if (nsmpr0:locationInformation/nsmpr0:runToFailure) | |||
assetType | assetDetails | String | wam_asset_type | items | String | Only if (nsmpr0:locationInformation/nsmpr0:runToFailure) | |||
issuedAsset | issuedAssets | Field | wam_asset_worked | items | String | WAMOFSC_ConfigProps | PropertyName : issuedComponent.inventory.type | Value : issuedComponent.inventory.type.error | When (nsmpr0:assetDetails/nsmpr0:isComponent='W1YS') and Only if (nsmpr0:locationInformation/nsmpr0:runToFailure) |
assetId | String | String | WAMOFSC_ConfigProps | PropertyName : issuedAsset.inventory.type | Value : issuedAsset.inventory.type.error | When (nsmpr0:assetId) and Only if (nsmpr0:locationInformation/nsmpr0:runToFailure) | |||
assetType | assetDetails | String | Field | When (string-length($wam_SHT_ip) < 65536) Hardcoded as | |||||
$wam_SHT_ip | Field | Field | When (string-length($wam_SHT_ip) < 65536) | ||||||
Field | When (string-length($wam_SHT_ip) > 65535) Hardcoded as | ||||||||
$wam_SHT_ip,1,65535 | Field | Field | When (string-length($wam_SHT_ip) > 65535) | ||||||
Oracle Utilities Work and Asset 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 | put_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_activities_0x736c68__0x6c6362_activityId_0x726362__0x736c68__0x6c6362_propertyLabel_0x726362_ | Outermosttag | |||||||
HTTPHeaders | put_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_activities_0x736c68__0x6c6362_activityId_0x726362__0x736c68__0x6c6362_propertyLabel_0x726362_ | Group | |||||||
StandardHTTPHeaders | HTTPHeaders | Group | |||||||
Content-Disposition | StandardHTTPHeaders | String | concat ("attachment; filename=", $AttachmentList/ns1:attachmentList/ns1:attachmentFileName ) | ||||||
$ofscActivityResp | Group | TemplateParameters | put_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_activities_0x736c68__0x6c6362_activityId_0x726362__0x736c68__0x6c6362_propertyLabel_0x726362_ | Group | |||||
bulkUpdate_POSTResponse | $ofscActivityResp | Group | |||||||
activities.definitions.customActionActivityBulkUpdateSchemaResponse | bulkUpdate_POSTResponse | Group | |||||||
results | activities.definitions.customActionActivityBulkUpdateSchemaResponse | Group | |||||||
activityKeys | results | Group | |||||||
activityId | activityKeys | Integer | activityId | TemplateParameters | String | ||||
propertyLabel | TemplateParameters | String | concat ("wam_attachment_", $LoopCounter ) | ||||||
attachmentData | String | streamReference | put_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_activities_0x736c68__0x6c6362_activityId_0x726362__0x736c68__0x6c6362_propertyLabel_0x726362_ | String | Function : decodeBase64ToReference (oraext:encodeBase64 ($AttachmentList/ns1:attachmentList/ns1:attachmentData ) ) | ||||
attachmentData | String | Function : decodeBase64ToReference ($AttachmentList/ns1:attachmentList/ns1:attachmentData ) | |||||||
Oracle Utilities Work and Asset Cloud Service | Oracle Field Service Cloud | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM | Column 1 | Column 2 | |
$ofscActivityResp | Outermosttag | update_PATCH | Outermosttag | ||||||
bulkUpdate_POSTResponse | $ofscActivityResp | Group | TemplateParameters | update_PATCH | Group | ||||
activities.definitions.customActionActivityBulkUpdateSchemaResponse | bulkUpdate_POSTResponse | Group | |||||||
results | activities.definitions.customActionActivityBulkUpdateSchemaResponse | Group | |||||||
activityKeys | results | Group | |||||||
activityId | activityKeys | Integer | activityId | TemplateParameters | Integer | ||||
activities.definitions.updateActivitySchema | update_PATCH | Group | |||||||
$elemName | activities.definitions.updateActivitySchema | Field | concat('W_', $LaborList/nsmpr0:laborList/nsmpr0:craftCode, '_Nd') | ||||||
$LaborList | Group | ||||||||
laborList | $LaborList | Group | |||||||
quantity | laborList | Double | element | activities.definitions.updateActivitySchema | Field | Function : number(ceiling($LaborList/nsmpr0:laborList/nsmpr0:quantity)) | |||
Oracle Utilities Work and Asset Cloud Service | Oracle Field Service Cloud | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM | Column 1 | Column 2 | |
$ofscActivityResp | Outermosttag | Fault | Outermosttag | ||||||
bulkUpdate_POSTResponse | $ofscActivityResp | Group | |||||||
activities.definitions.customActionActivityBulkUpdateSchemaResponse | bulkUpdate_POSTResponse | Group | |||||||
results | activities.definitions.customActionActivityBulkUpdateSchemaResponse | Group | |||||||
operationsPerformed | results | String | $PerformedCount | Fault | Field | Function : count($ofscActivityResp/nsmpr0:bulkUpdate_POSTResponse/nsmpr0:activities.definitions.customActionActivityBulkUpdateSchemaResponse/ns22:results/ns22:operationsPerformed) | |||
operationsFailed | results | String | $FailedCount | Fault | Field | Function : count($ofscActivityResp/nsmpr0:bulkUpdate_POSTResponse/nsmpr0:activities.definitions.customActionActivityBulkUpdateSchemaResponse/ns22:results/ns22:operationsFailed) and Only if ($FailedCount='0' and $PerformedCount ='0') Hardcoded as N | |||
Fault/ResponseCode | Field | Hardcoded as "RESPONSECODE" | |||||||
errors | results | Group | |||||||
errorDetail | errors | String | Fault/ResponseText | Field | |||||