Storeroom Sync (Oracle Field Service Initiated)
This section describes data mapping for the following:
Update Resource Last Sync Datetime
Mapping details for “Update Resource Last Sync Datetime” 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
 
 
 
 
resourceId
request-wrapper
String
resourceId
TemplateParameters
String
 
 
 
 
 
 
 
resources.definitions.resource
update_PATCH
Group
 
 
 
 
resourceId
request-wrapper
Field
resourceId
resources.definitions.resource
String
 
 
 
 
 
 
 
wam_resource_lastUpdateDttm
resources.definitions.resource
String
 
 
 
Function : fn:current-dateTime ()
Get Storeroom Inventory from WACS
Mapping details for “Get Storeroom Inventory 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
W1-MobileStoreroomInventory
 
Outermosttag
 
 
 
 
request-wrapper
execute
Group
W1-MobileStoreroomInventory
W1-MobileStoreroomInventory
Group
 
 
 
 
resourceId
request-wrapper
String
storeroomId
W1-MobileStoreroomInventory
String
 
 
 
 
lastSyncDateTime
request-wrapper
String
transferDateTime
W1-MobileStoreroomInventory
Datetime
 
 
 
Only if (/nssrcmpr:execute/ns29:request-wrapper/ns29:lastSyncDateTime != " ")
Sync Storeroom
Mapping details for “Sync Storeroom” 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
 
 
 
 
resourceId
request-wrapper
String
resourceId
response-wrapper
String
 
 
 
 
resourceType
request-wrapper
String
resourceType
response-wrapper
String
 
 
 
 
lastSyncDateTime
request-wrapper
String
lastSyncDateTime
response-wrapper
String
 
 
 
 
 
 
 
status
response-wrapper
String
 
 
 
Hardcoded as "Success"
Get Resource Inventories
Mapping details for “Get Resource Inventories” 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_resources_0x736c68__0x6c6362_resourceId_0x726362__0x736c68_inventories
 
Outermosttag
 
 
 
 
request-wrapper
execute
Group
TemplateParameters
get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_resources_0x736c68__0x6c6362_resourceId_0x726362__0x736c68_inventories
Group
 
 
 
 
resourceId
request-wrapper
String
resourceId
TemplateParameters
String
 
 
 
 
Resource Inventory Bulk
Mapping details for “Resource Inventory Bulk” 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
execute
 
Outermosttag
 
 
 
 
request-wrapper
execute
Group
request-wrapper
execute
Group
 
 
 
 
 
 
 
resources
request-wrapper
Group
 
 
 
 
inventory
W1-MobileStoreroomInventory
Field
resourceId
resources
Field
 
 
 
Only if (($GetStoreroomInventoryFromWACS/nsmpr2:W1-MobileStoreroomInventoryResponse/tns:W1-MobileStoreroomInventory/tns:inventory != ''))
$GetStoreroomInventoryFromWACS
 
Group
inventories
resources
Group
 
 
 
 
W1-MobileStoreroomInventoryResponse
$GetStoreroomInventoryFromWACS
Group
inventoryType
inventories
String
 
 
 
When (tns:assetId)
and Only if (($GetStoreroomInventoryFromWACS/nsmpr2:W1-MobileStoreroomInventoryResponse/tns:W1-MobileStoreroomInventory/tns:inventory != '')) Hardcoded as 'StockAsset'
W1-MobileStoreroomInventory
W1-MobileStoreroomInventoryResponse
Group
 
 
 
 
 
 
Otherwise and Only if (($GetStoreroomInventoryFromWACS/nsmpr2:W1-MobileStoreroomInventoryResponse/tns:W1-MobileStoreroomInventory/tns:inventory != '')) Hardcoded as 'StockItem'
 
 
 
wam_material_id
inventories
String
 
 
 
concat (tns:stockItemDetailId, "-", tns:assetId )
stockItemDetailId
 
String
 
 
 
 
 
 
Otherwise and Only if (($GetStoreroomInventoryFromWACS/nsmpr2:W1-MobileStoreroomInventoryResponse/tns:W1-MobileStoreroomInventory/tns:inventory != ''))
stockItemDetailId
 
String
wam_material_stockItemDetailId
inventories
String
 
 
 
Only if (($GetStoreroomInventoryFromWACS/nsmpr2:W1-MobileStoreroomInventoryResponse/tns:W1-MobileStoreroomInventory/tns:inventory != ''))
lotId
 
String
wam_material_lotId
inventories
String
 
 
 
Only if (($GetStoreroomInventoryFromWACS/nsmpr2:W1-MobileStoreroomInventoryResponse/tns:W1-MobileStoreroomInventory/tns:inventory != ''))
stockCode
 
String
wam_material_stockCode
inventories
String
 
 
 
Only if (tns:stockCode and ($GetStoreroomInventoryFromWACS/nsmpr2:W1-MobileStoreroomInventoryResponse/tns:W1-MobileStoreroomInventory/tns:inventory != ''))
masterStockItemDetailId
 
String
wam_material_masterStockItemDetailId
inventories
String
 
 
 
Only if (tns:stockCode)
stockItemId
 
String
wam_material_stockItemId
inventories
String
 
 
 
Only if (tns:stockCode)
stockItemCategory
 
String
wam_material_stockItemCategory
inventories
String
 
 
 
Only if (tns:stockItemCategory and tns:stockCode)
stockItemDetailInfo
 
String
wam_material_stockItemDetailInfo
inventories
String
 
 
 
Only if (tns:stockItemCategory)
quantity
 
Decimal
quantity
inventories
Double
 
 
 
Only if (tns:stockItemCategory)
validServiceHistoryTypes
 
String
wam_asset_valid_service_history_types
inventories
String
 
 
 
Function : get-content-as-string (tns:assetInformation/tns:validServiceHistoryTypes )
validMeasurementTypes
 
String
wam_valid_measurement_types
inventories
String
 
 
 
Function : get-content-as-string (tns:assetInformation/tns:validMeasurementTypes )
assetId
 
String
wam_asset_id
inventories
String
 
 
 
Only if (tns:assetInformation/tns:validMeasurementTypes/tns:measurementTypeList)
badgeNumber
 
String
wam_badge_number
inventories
String
 
 
 
Only if (tns:assetInformation/tns:validMeasurementTypes/tns:measurementTypeList)
stockItemInfo
 
String
wam_material_stockItemInfo
inventories
String
 
 
 
Only if (tns:assetInformation/tns:validMeasurementTypes/tns:measurementTypeList)
uom
 
String
wam_material_uom
inventories
String
 
 
 
Only if (tns:uom and tns:assetInformation/tns:validMeasurementTypes/tns:measurementTypeList)
isComponent
 
String
wam_material_isComponent
inventories
String
 
 
 
Only if (tns:uom)
Bulk Update Inventories
Mapping details for “Bulk Update Inventories” 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
execute
 
Outermosttag
 
 
 
 
request-wrapper
execute
Group
request-wrapper
execute
Group
 
 
 
 
 
 
 
resources
request-wrapper
Group
 
 
 
 
inventories
resources
Field
resourceId
resources
Field
 
 
 
 
$buildInventoryNew
 
Group
inventories
resources
Group
 
 
 
 
resources
$buildInventoryNew
Group
inventoryType
inventories
String
 
 
 
When (nstrgdfl:wam_asset_id)
Hardcoded as "StockAsset"
 
Otherwise, hardcoded as "StockItem"
 
 
 
wam_material_id
inventories
String
 
 
 
concat (nstrgdfl:wam_material_stockItemDetailId, "-", nstrgdfl:wam_asset_id )
wam_material_stockItemDetailId
 
String
 
 
 
 
 
 
Otherwise
wam_material_stockItemDetailId
 
String
wam_material_stockItemDetailId
inventories
String
 
 
 
 
wam_material_stockItemDetailInfo
 
String
wam_material_stockItemDetailInfo
inventories
String
 
 
 
 
wam_material_stockCode
 
String
wam_material_stockCode
inventories
String
 
 
 
 
wam_material_masterStockItemDetailId
 
String
wam_material_masterStockItemDetailId
inventories
String
 
 
 
 
wam_material_lotId
 
String
wam_material_lotId
inventories
String
 
 
 
 
wam_material_stockItemId
 
String
wam_material_stockItemId
inventories
String
 
 
 
 
wam_material_stockItemCategory
 
String
wam_material_stockItemCategory
inventories
String
 
 
 
Only if (nstrgdfl:wam_material_stockItemCategory)
quantity
 
Double
quantity
inventories
Double
 
 
 
 
wam_asset_valid_service_history_types
 
String
wam_asset_valid_service_history_types
inventories
String
 
 
 
 
wam_valid_measurement_types
 
String
wam_valid_measurement_types
inventories
String
 
 
 
 
wam_asset_id
 
String
wam_asset_id
inventories
String
 
 
 
 
wam_badge_number
 
String
wam_badge_number
inventories
String
 
 
 
 
wam_material_stockItemInfo
 
String
wam_material_stockItemInfo
inventories
String
 
 
 
 
wam_material_uom
 
String
wam_material_uom
inventories
String
 
 
 
Only if (nstrgdfl:wam_material_uom)
wam_material_isComponent
 
String
wam_material_isComponent
inventories
String