Activity Pull Update (Oracle Field Service Initiated)
This section describes data mapping for the following:
Update Oracle Field Service Cloud Activity
Mapping details for “Update Oracle Field Service Cloud Activity” are as shown in the table below:
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
 
 
 
 
 
 
 
activities
activities.definitions.customActionActivityBulkUpdateSchema
Group
 
 
 
 
$xml
 
String
wam_service_history_types
activities
String
 
 
 
Function : get-content-as-string($xml/*)
Get Inventories from Oracle Field Service Cloud
Mapping details for “Get Inventories from Oracle Field Service Cloud” activity are as shown in the table below:
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
 
execute
 
Outermosttag
get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_activities_0x736c68__0x6c6362_activityId_0x726362__0x736c68_installedInventories
 
Outermosttag
 
 
 
 
request-wrapper
execute
Group
TemplateParameters
get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_activities_0x736c68__0x6c6362_activityId_0x726362__0x736c68_installedInventories
Group
 
 
 
 
activityId
request-wrapper
String
activityId
TemplateParameters
String
 
 
 
 
Get De-installed Inventory Oracle Field Service Cloud
Mapping details for “Get De-installed Inventory Oracle Field Service Cloud” activity are as shown in the table below:
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
 
execute
 
Outermosttag
get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_activities_0x736c68__0x6c6362_activityId_0x726362__0x736c68_deinstalledInventories
 
Outermosttag
 
 
 
 
request-wrapper
execute
Group
TemplateParameters
get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_activities_0x736c68__0x6c6362_activityId_0x726362__0x736c68_deinstalledInventories
Group
 
 
 
 
activityId
request-wrapper
String
activityId
TemplateParameters
String
 
 
 
 
Target Oracle Field Service Cloud Equipment
Mapping details for “Target Oracle Field Service Cloud Equipment” activity are as shown in the table below:
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
 
execute
 
Outermosttag
update_PATCH
 
Outermosttag
 
 
 
 
request-wrapper
execute
Group
TemplateParameters
update_PATCH
Group
 
 
 
 
activityId
request-wrapper
String
activityId
TemplateParameters
Integer
 
 
 
 
 
 
 
activities.definitions.updateActivitySchema
update_PATCH
Group
 
 
 
 
 
 
 
$elemName
activities.definitions.updateActivitySchema
Field
 
 
 
concat('WE_', $currentEquipment/nsmpr3:equipmentList/nsmpr3:equipmentCode, '_Nd')
$currentEquipment
 
Group
 
 
 
 
 
 
 
equipmentList
$currentEquipment
Group
 
 
 
 
 
 
 
quantity
equipmentList
Field
element
activities.definitions.updateActivitySchema
Field
 
 
 
Function : number(ceiling($currentEquipment/nsmpr3:equipmentList/nsmpr3:quantity))
Target Oracle Field Service Cloud Labor
Mapping details for “Target Oracle Field Service Cloud Labor” activity are as shown in the table below:
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
 
execute
 
Outermosttag
update_PATCH
 
Outermosttag
 
 
 
 
request-wrapper
execute
Group
TemplateParameters
update_PATCH
Group
 
 
 
 
activityId
request-wrapper
String
activityId
TemplateParameters
Integer
 
 
 
 
 
 
 
activities.definitions.updateActivitySchema
update_PATCH
Group
 
 
 
 
 
 
 
$elemName
activities.definitions.updateActivitySchema
Field
 
 
 
concat('W_', $currLabor/nsmpr3:laborList/nsmpr3:craftCode, '_Nd')
$currLabor
 
Group
 
 
 
 
 
 
 
laborList
$currLabor
Group
 
 
 
 
 
 
 
quantity
laborList
Field
element
activities.definitions.updateActivitySchema
Field
 
 
 
Function : number(ceiling($currLabor/nsmpr3:laborList/nsmpr3:quantity))
Get Activity Details
Mapping details for “Get Activity Details” activity are as shown in the table below:
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
 
$GetActivityDetailsFromOFSC
 
Outermosttag
W1-WOActivityDetails
 
Outermosttag
 
 
 
 
canonical_GETResponse
$GetActivityDetailsFromOFSC
Group
W1-WOActivityDetails
W1-WOActivityDetails
Group
 
 
 
 
activities.definitions.getActivitySchema
canonical_GETResponse
Group
input
W1-WOActivityDetails
Group
 
 
 
 
apptNumber
activities.definitions.getActivitySchema
String
activityId
input
String
 
 
 
 
Get Activity Updates from WACS
Mapping details for “Get Activity Updates from WACS” activity are as shown in the table below:
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
 
execute
 
Outermosttag
executeResponse
 
Outermosttag
 
 
 
 
request-wrapper
execute
Group
response-wrapper
executeResponse
Group
 
 
 
 
activityId
request-wrapper
String
activityId
response-wrapper
String
 
 
 
 
wamActivityId
request-wrapper
String
wamActivityId
response-wrapper
String
 
 
 
 
$responseStatus
 
Field
status
response-wrapper
String
 
 
 
 
$errorText
 
Field
errorText
response-wrapper
String
 
 
 
Only if ($errorText)
Update Oracle Field Service Cloud Activity 1
Mapping details for “Update Oracle Field Service Cloud Activity 1” activity are as shown in the table below:
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
Activities.definitions.customactionactivitybulkupdateschema.updateparameters
 
 
 
Set Default value to "doNothing"
 
 
 
inventoryPropertiesUpdateMode
updateParameters
Field
 
 
 
Set Default value to "keepProperties"
$GetActivityDetails
 
Group
activities
activities.definitions.customActionActivityBulkUpdateSchema
Group
 
 
 
 
W1-WOActivityDetailsResponse
$GetActivityDetails
Group
 
 
 
 
 
 
 
W1-WOActivityDetails
W1-WOActivityDetailsResponse
Group
 
 
 
 
 
 
 
output
W1-WOActivityDetails
Group
 
 
 
 
 
 
 
activity
output
Group
 
 
 
 
 
 
 
activityId
activity
Integer
apptNumber
activities
String
 
 
 
 
 
 
 
activityType
activities
String
 
 
 
Only if ($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:activityType) and Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ActivityType", "WAM_ActType", $GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:activityType, "OFSC_ActType", $GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:activityType )
activityDetails
activity
Group
 
 
 
 
 
 
 
locationInformation
activityDetails
Group
 
 
 
 
 
 
 
nodeId
locationInformation
String
wam_activity_node_id
activities
Field
 
 
 
 
address1,address2,address3,address4
 
Field
streetAddress
activities
String
 
 
 
User Defined Func: WAMOFSC_ConcatAddress(address1,address2,address3,address4)
location
locationInformation
Group
 
 
 
 
 
 
 
city
location
String
city
activities
String
 
 
 
 
postal
location
String
postalCode
activities
String
 
 
 
 
state
location
String
stateProvince
activities
String
 
 
 
 
 
 
 
timeZone
activities
String
 
 
 
Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "wam.timeZoneIANA", "Value", "wam.timeZoneIANA.error" )
geocodeLongitude
locationInformation
Decimal
longitude
activities
Double
 
 
 
Only if ($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:locationInformation/nsmpr2:geocodeLatitude and $GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:locationInformation/nsmpr2:geocodeLongitude and not(number($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:locationInformation/nsmpr2:geocodeLatitude) = 0 and number($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:locationInformation/nsmpr2:geocodeLongitude) = 0))
geocodeLatitude
locationInformation
Decimal
latitude
activities
Double
 
 
 
Only if ($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:locationInformation/nsmpr2:geocodeLatitude and $GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:locationInformation/nsmpr2:geocodeLongitude and not(number($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:locationInformation/nsmpr2:geocodeLatitude) = 0 and number($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:locationInformation/nsmpr2:geocodeLongitude) = 0))
windowStartDateTime, 0, 20
activityDetails
Field
slaWindowStart
activities
String
 
 
 
Only if ($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:windowStartDateTime) and Function : translate (substring ($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:windowStartDateTime, 0, 20 ), "T", " " )
windowEndDateTime, 0, 20
activityDetails
Field
slaWindowEnd
activities
String
 
 
 
Only if ($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:windowEndDateTime) and Function : translate (substring ($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:windowEndDateTime, 0, 20 ), "T", " " )
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'
 
 
 
wam_activity_location_info
activities
String
 
 
 
Hardcoded as 'Yes'
totalPriority
activityDetails
Decimal
wam_total_priority
activities
String
 
 
 
 
requiredByDate
activityDetails
Date
wam_required_by_date
activities
String
 
 
 
Only if ($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2: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
assetLocationAssets
Group
 
 
 
 
 
 
 
assetDetails
assetLocationAssetList
Group
 
 
 
 
 
 
 
info
assetDetails
String
wam_activity_asset_info
activities
String
 
 
 
 
 
 
 
common_utilities_product_code
activities
String
 
 
 
Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "source.system", "Value", "source.system.error" )
equipmentGroup
 
String
$atemp
activities
Field
 
 
 
Function : get-content-as-string($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:equipmentGroup)
laborGroup
 
String
wam_equipment_group
activities
Field
 
 
 
Function : get-content-as-string($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:laborGroup)
otherGroup
 
String
wam_labor_group
activities
Field
 
 
 
Function : get-content-as-string($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:otherGroup)
storeroomGroup
 
String
wam_other_group
activities
Field
 
 
 
Function : get-content-as-string($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:storeroomGroup)
 
 
 
wam_storeroom_group
activities
String
 
 
 
concat (substring-before ($atemp, "http://ouaf.oracle.com/webservices/w1/W1-WOActivityDetails" ), "http://ouaf.oracle.com/outbound/W1-WOActivityActiveOutboundMsg", substring-after ($atemp, "http://ouaf.oracle.com/webservices/w1/W1-WOActivityDetails" ) )
 
 
 
$wamSHTStr
activities
Field
 
 
 
concat (substring-before ($newSHTypeString, "http://ouaf.oracle.com/webservices/w1/W1-WOActivityDetails" ), "http://ouaf.oracle.com/outbound/W1-WOActivityActiveOutboundMsg", substring-after ($newSHTypeString, "http://ouaf.oracle.com/webservices/w1/W1-WOActivityDetails" ) )
$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
 
 
 
 
sht_text[2]
$sht_node
Field
wam_service_history_types2
activities
String
 
 
 
 
sht_text[3]
$sht_node
Field
wam_service_history_types3
activities
String
 
 
 
 
sht_text[4]
$sht_node
Field
wam_service_history_types4
activities
String
 
 
 
 
sht_text[5]
$sht_node
Field
wam_service_history_types5
activities
String
 
 
 
 
sht_text[6]
$sht_node
Field
wam_service_history_types6
activities
String
 
 
 
 
sht_text[7]
$sht_node
Field
wam_service_history_types7
activities
String
 
 
 
 
sht_text[8]
$sht_node
Field
wam_service_history_types8
activities
String
 
 
 
 
sht_text[9]
$sht_node
Field
wam_service_history_types9
activities
String
 
 
 
 
validServiceHistoryTypes
$sht_node
String
wam_service_history_types10
activities
Field
 
 
 
Function : get-content-as-string($GetActivityDetails/nsmpr1:W1-WOActivityDetailsResponse/nsmpr2:W1-WOActivityDetails/nsmpr2:output/nsmpr2:activity/nsmpr2:activityDetails/nsmpr2:validServiceHistoryTypes)
 
 
 
wam_valid_service_history_types
activities
String
 
 
 
concat (substring-before ($atemp, "http://ouaf.oracle.com/webservices/w1/W1-WOActivityDetails" ), "http://ouaf.oracle.com/outbound/W1-WOActivityActiveOutboundMsg", substring-after ($atemp, "http://ouaf.oracle.com/webservices/w1/W1-WOActivityDetails" ) )
$GetActivityDetailsFromOFSC
 
Group
 
 
 
 
 
 
 
canonical_GETResponse
$GetActivityDetailsFromOFSC
Group
 
 
 
 
 
 
 
activities.definitions.getActivitySchema
canonical_GETResponse
Group
 
 
 
 
 
 
 
masterActivityId
activities.definitions.getActivitySchema
Integer
activityId
activities
Integer
 
 
 
When ($GetActivityDetailsFromOFSC/nsmpr4:canonical_GETResponse/nsmpr4:activities.definitions.getActivitySchema/ns77:masterActivityId != '')
activityId
request-wrapper
Integer
 
 
 
 
 
 
Otherwise
$inventoryList
 
Group
 
 
 
 
 
 
 
assetLocationAssets
$inventoryList
Group
 
 
 
 
 
 
 
assetLocationAssetList
assetLocationAssets
Field
inventories
activities
Activities.definitions.activityinventories
 
 
 
Only if ($inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList !='' and (($inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList != '') or ($issuedAssetsList/nsmpr2:issuedAssets/nsmpr2:issuedAsset != '')))
request-wrapper
execute
Group
items
inventories
Group
 
 
 
 
 
 
 
inventoryType
items
String
 
 
 
Only if ($inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList !='' and (($inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList != '') or ($issuedAssetsList/nsmpr2:issuedAssets/nsmpr2:issuedAsset != ''))) and Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "asset.inventory.type", "Value", "asset.inventory.type.error" )
assetId
 
String
serialNumber
items
String
 
 
 
When (nsmpr2:assetId != '')
and Only if ($inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList !='' and (($inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList != '') or ($issuedAssetsList/nsmpr2:issuedAssets/nsmpr2:issuedAsset != '')))
nodeId
 
String
 
 
 
 
 
 
Otherwise and Only if ($inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList !='' and (($inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList != '') or ($issuedAssetsList/nsmpr2:issuedAssets/nsmpr2:issuedAsset != '')))
activityId
activity
Integer
wam_activity_id
items
String
 
 
 
Only if ($inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList !='' and (($inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList != '') or ($issuedAssetsList/nsmpr2:issuedAssets/nsmpr2:issuedAsset != '')))
validMeasurementTypes
 
String
$atemp
items
Field
 
 
 
Function : get-content-as-string(nsmpr2:validMeasurementTypes)
 
 
 
wam_valid_measurement_types
items
String
 
 
 
concat (substring-before ($atemp, "http://ouaf.oracle.com/webservices/w1/W1-WOActivityDetails" ), "http://ouaf.oracle.com/outbound/W1-WOActivityActiveOutboundMsg", substring-after ($atemp, "http://ouaf.oracle.com/webservices/w1/W1-WOActivityDetails" ) )
assetDetails
 
Group
 
 
 
 
 
 
 
serialNo
assetDetails
String
ITEM_NUMBER
items
String
 
 
 
Only if (nsmpr2:validMeasurementTypes/nsmpr2:measurementTypeList and $inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList !='')
nodeId
 
String
wam_node_id
items
String
 
 
 
Only if (nsmpr2:validMeasurementTypes/nsmpr2:measurementTypeList and $inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList !='')
seq
 
Decimal
wam_asset_seq
items
String
 
 
 
Only if (nsmpr2:validMeasurementTypes/nsmpr2:measurementTypeList and $inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList !='')
attachedToAssetId
assetDetails
String
wam_attached_to_asset_id
items
String
 
 
 
Only if (nsmpr2:validMeasurementTypes/nsmpr2:measurementTypeList and $inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList !='')
 
 
 
wam_asset_installed_in_ofsc
items
String
 
 
 
Hardcoded as 'NO'
 
 
 
wam_asset_or_component
items
String
 
 
 
When (nsmpr2:assetDetails/nsmpr2:isComponent='W1YS')
and Only if (nsmpr2:validMeasurementTypes/nsmpr2:measurementTypeList and $inventoryList/nsmpr2:assetLocationAssets/nsmpr2:assetLocationAssetList !='') Hardcoded as 'C'
otherAssetsAtLocation
 
String
 
 
Field
 
 
 
Function : get-content-as-string(nsmpr2:otherAssetsAtLocation)
 
 
 
wam_other_assets
items
String
 
 
 
concat (substring-before ($atemp, "http://ouaf.oracle.com/webservices/w1/W1-WOActivityDetails" ), "http://ouaf.oracle.com/outbound/W1-WOActivityActiveOutboundMsg", substring-after ($atemp, "http://ouaf.oracle.com/webservices/w1/W1-WOActivityDetails" ) )
locationInformation
 
Group
 
 
 
 
 
 
 
isAssetLocation
locationInformation
String
wam_is_asset_location
items
String
 
 
 
Only if (nsmpr2:otherAssetsAtLocation/nsmpr2:assetList and nsmpr2:validMeasurementTypes/nsmpr2:measurementTypeList)
attachedToAssetId
assetDetails
String
$wamAttachedToAssetId
items
Field
 
 
 
Only if (nsmpr2:otherAssetsAtLocation/nsmpr2:assetList and nsmpr2:validMeasurementTypes/nsmpr2:measurementTypeList)
assetId= $wamAttachedToAssetId]
assetLocationAssets
Group
 
 
 
 
 
 
 
assetDetails
assetId= $wamAttachedToAssetId]
Group
 
 
 
 
 
 
 
info
assetDetails
String
wam_attached_to_asset_info
items
String
 
 
 
Only if (nsmpr2:otherAssetsAtLocation/nsmpr2:assetList and nsmpr2:validMeasurementTypes/nsmpr2:measurementTypeList)
maybeLeftInPlace
assetDetails
String
wam_asset_maybeLeftInPlace
items
String
 
 
 
Only if (nsmpr2:otherAssetsAtLocation/nsmpr2:assetList and nsmpr2:validMeasurementTypes/nsmpr2:measurementTypeList)
info
assetDetails
String
wam_asset_info
items
String
 
 
 
Only if (nsmpr2:otherAssetsAtLocation/nsmpr2:assetList and nsmpr2:validMeasurementTypes/nsmpr2:measurementTypeList)
validServiceHistoryTypes
 
String
wam_badge_number
items
Field
 
 
 
Function : get-content-as-string(nsmpr2:validServiceHistoryTypes)
failureInformation
 
String
wam_asset_valid_service_history_types
items
Field
 
 
 
Function : get-content-as-string(nsmpr2:failureInformation)
 
 
 
wam_failure_info
items
String
 
 
 
concat(substring-before($atemp, 'http://ouaf.oracle.com/webservices/w1/W1-WOActivityDetails'),'http://ouaf.oracle.com/outbound/W1-WOActivityActiveOutboundMsg',substring-after($atemp, 'http://ouaf.oracle.com/webservices/w1/W1-WOActivityDetails'))
info
locationInformation
String
wam_asset_location_info
items
String
 
 
 
Only if (nsmpr2:failureInformation/* and nsmpr2:validServiceHistoryTypes/nsmpr2:serviceHistoryTypeList)
building
locationInformation
String
wam_asset_location_building
items
String
 
 
 
Only if (nsmpr2:failureInformation/* and nsmpr2:validServiceHistoryTypes/nsmpr2:serviceHistoryTypeList)
room
locationInformation
String
wam_asset_location_room
items
String
 
 
 
Only if (nsmpr2:failureInformation/* and nsmpr2:validServiceHistoryTypes/nsmpr2:serviceHistoryTypeList)
runToFailure
locationInformation
String
wam_asset_location_runToFailure
items
String
 
 
 
Only if (nsmpr2:locationInformation/nsmpr2:runToFailure and nsmpr2:failureInformation/* and nsmpr2:validServiceHistoryTypes/nsmpr2:serviceHistoryTypeList)
siteLocation
locationInformation
String
wam_asset_location_siteLocation
items
String
 
 
 
Only if (nsmpr2:locationInformation/nsmpr2:runToFailure and nsmpr2:failureInformation/*)
pointId
locationInformation
String
wam_asset_location_pointId
items
String
 
 
 
Only if (nsmpr2:locationInformation/nsmpr2:runToFailure and nsmpr2:failureInformation/*)
serviceAreaDescription
locationInformation
String
wam_asset_location_serviceArea
items
String
 
 
 
Only if (nsmpr2:locationInformation/nsmpr2:runToFailure and nsmpr2:failureInformation/*)
assetId
 
String
wam_asset_id
items
String
 
 
 
Only if (nsmpr2:locationInformation/nsmpr2:runToFailure and nsmpr2:failureInformation/*)
description
assetDetails
String
wam_asset_desc
items
String
 
 
 
Only if (nsmpr2:locationInformation/nsmpr2:runToFailure and nsmpr2:failureInformation/*)
assetType
assetDetails
String
wam_asset_type
items
String
 
 
 
Only if (nsmpr2:locationInformation/nsmpr2:runToFailure and nsmpr2:failureInformation/*)
issuedAsset
issuedAssets
Field
wam_asset_worked
items
String
WAMOFSC_ConfigProps
PropertyName : issuedComponent.inventory.type
Value : issuedComponent.inventory.type.error
When (nsmpr2:assetDetails/nsmpr2:isComponent='W1YS')
and Only if ($issuedAssetsList/nsmpr2:issuedAssets/nsmpr2:issuedAsset !='' and nsmpr2:locationInformation/nsmpr2:runToFailure)
attachedToAssetId
assetDetails
String
 
 
String
WAMOFSC_ConfigProps
PropertyName : issuedAsset.inventory.type
Value : issuedAsset.inventory.type.error
When (nsmpr2:assetDetails/nsmpr2:isComponent='W1YS')
and Only if (nsmpr2:validMeasurementTypes/nsmpr2:measurementTypeList and $issuedAssetsList/nsmpr2:issuedAssets/nsmpr2:issuedAsset !='') Hardcoded as 'C'
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)
Get Activity Details from Oracle Field Service Cloud
Mapping details for “Get Activity Details from Oracle Field Service Cloud” activity are as shown in the table below:
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
 
execute
 
Outermosttag
canonical_GET
 
Outermosttag
 
 
 
 
request-wrapper
execute
Group
TemplateParameters
canonical_GET
Group
 
 
 
 
activityId
request-wrapper
String
activityId
TemplateParameters
Integer