Storeroom Admin Sync (Oracle Field Service Initiated)
This section describes data mapping for the following:
Update Oracle Field Service Cloud Resource as Inactive
Mapping details for “Update Oracle Field Service Cloud Resource as Inactive” 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
 
$ofscResourceItem
 
Outermosttag
update_PATCH
 
Outermosttag
 
 
 
 
items
$ofscResourceItem
Group
TemplateParameters
update_PATCH
Group
 
 
 
 
resourceId
items
Field
resourceId
TemplateParameters
String
 
 
 
 
 
 
 
resources.definitions.resource
update_PATCH
Group
 
 
 
 
resourceId
items
Field
resourceId
resources.definitions.resource
String
 
 
 
 
 
 
 
status
resources.definitions.resource
String
 
 
 
Hardcoded as 'inactive'
Oracle Field Service Cloud Resource List
Mapping details for “Oracle Field Service Cloud Resource List” 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
get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_resources_0x736c68__0x6c6362_resourceId_0x726362__0x736c68_descendants
 
Outermosttag
 
 
 
 
 
 
 
TemplateParameters
get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_resources_0x736c68__0x6c6362_resourceId_0x726362__0x736c68_descendants
Group
 
 
 
 
 
 
 
resourceId
TemplateParameters
String
 
 
 
Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "ofsc.bucket", "Value", "ofsc.bucket.error" )
 
 
 
QueryParameters
get_0x737063__0x736c68_rest_0x736c68_ofscCore_0x736c68_v1_0x736c68_resources_0x736c68__0x6c6362_resourceId_0x726362__0x736c68_descendants
Group
 
 
 
 
$Offset
 
Field
offset
QueryParameters
Integer
 
 
 
 
$Limit
 
Field
limit
QueryParameters
Integer
 
 
 
 
Update Oracle Field Service Cloud Resource
Mapping details for “Update Oracle Field Service Cloud Resource” 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
 
$wacsMobileStoreroom
 
Outermosttag
update_PATCH
 
Outermosttag
 
 
 
 
mobileStoreroom
$wacsMobileStoreroom
Group
TemplateParameters
update_PATCH
Group
 
 
 
 
storeroomId
mobileStoreroom
String
resourceId
TemplateParameters
String
 
 
 
 
 
 
 
resources.definitions.resource
update_PATCH
Group
 
 
 
 
storeroomId
mobileStoreroom
String
resourceId
resources.definitions.resource
String
 
 
 
 
 
 
 
status
resources.definitions.resource
String
 
 
 
Set default value to "active"
 
 
 
resourceType
resources.definitions.resource
String
 
 
 
Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "mobileStoreroom.resource.type", "Value", "mobileStoreroom.resource.type.error" )
description
mobileStoreroom
String
name
resources.definitions.resource
String
 
 
 
 
address1,address2,address3,address4
 
Field
wam_resource_address
resources.definitions.resource
String
 
 
 
User Defined Func: WAMOFSC_ConcatAddress(address1,address2,address3,address4)
 
 
 
wam_resource_source
resources.definitions.resource
String
 
 
 
Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "mobileStoreroom.resource.source", "Value", "mobileStoreroom.resource.source.error" )
Create Resource in Oracle Field Service Cloud
Mapping details for “Create Resource in 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
 
$wacsMobileStoreroom
 
Outermosttag
replace_PUT
 
Outermosttag
 
 
 
 
mobileStoreroom
$wacsMobileStoreroom
Group
TemplateParameters
replace_PUT
Group
 
 
 
 
storeroomId
mobileStoreroom
String
resourceId
TemplateParameters
String
 
 
 
 
 
 
 
resources.definitions.resource
replace_PUT
Group
 
 
 
 
storeroomId
mobileStoreroom
String
resourceId
resources.definitions.resource
String
 
 
 
 
 
 
 
organization
resources.definitions.resource
String
 
 
 
Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "mobileStoreroom.organization", "Value", "mobileStoreroom.organization.error" )
 
 
 
status
resources.definitions.resource
String
 
 
 
Hardcoded as "active"
 
 
 
parentResourceId
resources.definitions.resource
String
 
 
 
Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "ofsc.bucket", "Value", "ofsc.bucket.error" )
 
 
 
resourceType
resources.definitions.resource
String
 
 
 
Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "mobileStoreroom.resource.type", "Value", "mobileStoreroom.resource.type.error" )
description
mobileStoreroom
String
name
resources.definitions.resource
String
 
 
 
 
 
 
 
language
resources.definitions.resource
String
 
 
 
Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "mobileStoreroom.language.default", "Value", "mobileStoreroom.language.default.error" )
 
 
 
timeZone
resources.definitions.resource
String
 
 
 
Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "mobileStoreroom.timeZone.default", "Value", "mobileStoreroom.timeZone.default.error" )
address1,address2,address3,address4
 
Field
wam_resource_address
resources.definitions.resource
String
 
 
 
User Defined Func: WAMOFSC_ConcatAddress(address1,address2,address3,address4)
 
 
 
wam_resource_source
resources.definitions.resource
String
 
 
 
Function : dvm:lookupValue ("tenant/resources/dvms/WAMOFSC_ConfigProps", "PropertyName", "mobileStoreroom.resource.source", "Value", "mobileStoreroom.resource.source.error" )
Storeroom Synchronization with Work and Asset Cloud Service
Mapping details for “Storeroom Synchronization with Work and Asset Cloud Service” 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
W1-SynchronizeMobileStoreroomDetails
 
Outermosttag
 
 
 
 
 
 
 
W1-SynchronizeMobileStoreroomDetails
W1-SynchronizeMobileStoreroomDetails
Group
 
 
 
 
 
 
 
tempElement
W1-SynchronizeMobileStoreroomDetails
Field
 
 
 
Set default value to "WillBeDeletedAfterOUAdapterFix"