Admin Sync (Oracle Integration Cloud Initiated)

This section describes data mapping for the following:

• Request Mappings

• Service Point Data Mappings

• Activity Types Mappings

• Activity Data Mappings

• Device Data Mappings

• Register Data Mappings

Request Mappings

The request mapping details in the Admin Sync integration point are shown in the table below.

Oracle Utilities Service Order Management Inbound Request Message			DVM Mapping			Comments
Element Name	Parent Element	Type	DVM	Oracle Field Service Column	Oracle Utilities Service Order Management Column
X1-RequestAdminData		OutermostTag
input		Group
languageCd	input	Field	SOMOFSC_ ConfigProps	PropertyName	Value	Hard code the property name as "som.adminsync.languagecode"
table	input	Group
tableList	table	Group
tableName	tableList	Field				Hard code the tablename with "CI_PREM_TYPE"
tableList	table	Group
tableName	tableList	Field				Hard code the tablename with "D1_SVC_TYPE"
standardLookup	input	Group
standardLookupList	standardLookup	Group
lookupField	standardLookupList	Field				Hard code the lookupField with "DISCONN_LOC_FLG"
extendableLookup	input	Group
extendableLookupList	extendableLookup	Group
extendableLookupBO	extendableLookupList	Field				Hard code the extendable look up BO with "D1-SPInstructionLookup"
extendableLookupList	extendableLookup	Group
extendableLookupBO	extendableLookupList	Field				Hard code the extendable look up BO with "D1-SPWarningLookup"
extendableLookupList	extendableLookup	Group
extendableLookupBO	extendableLookupList	Field				Hard code the extendable look up BO with "D1-FieldTaskTypeLookup"
Mappings for Getting Activity, Device and Register Admin Data from Oracle Utilities Customer Cloud Service
X1-RequestAdminData		OutermostTag
input		Group
languageCd	input	Field	SOMOFSC_ ConfigProps	PropertyName	Value	Hard code the property name as "som.adminsync.languagecode"
table	input	Group
tableList	table	Group
tableName	tableList	Field				Hard code the tablename with "CI_CC_TYPE"
tableList	table	Group
tableName	tableList	Field				Hard code the tablename with "D1_UOM"
tableList	table	Group
tableName	tableList	Field				Hard code the tablename with "D1_TOU"
tableList	table	Group
tableName	tableList	Field				Hard code the tablename with "D1_SQI"
tableList	table	Group
tableName	tableList	Field				Hard code the tablename with "D1_DVC_TYPE"
tableList	table	Group
tableName	tableList	Field				Hard code the tablename with "D1_DVC_CFG_TYPE"
tableList	table	Group
tableName	tableList	Field				Hard code the tablename with "D1_SPR"
tableList	table	Group
tableName	tableList	Field				Hard code the tablename with "D1_MANUFACTURER"
extendableLookup	input	Group
extendableLookupList	extendableLookup	Group
extendableLookupBO	extendableLookupList	Field				Hard code the extendable look up BO with "D1-FARemarkTypeLookup"
extendableLookupList	extendableLookup	Group
extendableLookupBO	extendableLookupList	Field				Hard code the extendable look up BO with "D1-CancelReasonLookup"

Service Point Data Mappings

The mapping details in the Service Point integration point are shown in the table below.

Oracle Utilities Service Order Management Response		Oracle Field Service Enum Request			DVM Mapping			Comments
Element Name	Parent Element	Element Name	Parent Element	Type	DVM	Oracle Field Service Column	Oracle Utilities Service Order Management Column
		Label	Template Parameters	outermosttag				Gets the Sp property label from "SOMOFSC_Sync_ServicePointData" look up and assign it to the element
		Request Wrapper
		Items	Request Wrapper	List
code	/standard LookupList/codeDescription List	Label	Items	Field
		Active	Items					Hardcode as "true"
		translations	Items	List
		language	translations		SOM_ Language Code	OFSC_ LanguageCode	SOM_ LanguageCode
description	/standardLookup List/codeDescription List	name	translations	Field

Activity Types Mappings

The mapping details in the Activity Type integration point are shown in the table below.

Oracle Utilities Service Order Management Response		Oracle Field Service Enum Request			DVM Mapping			Comments
Element Name	Parent Element	Element Name	Parent Element	Type	DVM	Oracle Field Service Column	Oracle Utilities Service Order Management Column
code	codeDescription List	Label	Template Parameters	outermosttag	SOMOFSC_ActivityType	OFSC_ActivityType	SOM_ TaskType
code	codeDescription List	Label	Request Wrapper		SOMOFSC_ActivityType	OFSC_ActivityType	SOM_ TaskType
description	codeDescription List	Name	Request Wrapper
		Active	Request Wrapper		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "activityType.active"
		Group Label	Request Wrapper		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "groupLabel"
		Default Duration	Request Wrapper		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "duration"
		Time Slots	Request Wrapper	List
		Label	Time Slots		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "timeslots.label"
		Colors	Request Wrapper
		Pending	Colors		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "colors.pending"
		Started	Colors		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "colors.started"
		Suspended	Colors		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "colors.suspended"
		Cancelled	Colors		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "colors.cancelled"
		Notdone	Colors		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "colors.notdone"
		Not Ordered	Colors		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "colors.notOrdered"
		Warning	Colors		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "colors.warning"
		Completed	Colors		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "colors.completed"
		Features	Request Wrapper
		Is Teamwork Available	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.isTeamworkAvailable"
		Is Segmenting Enabled	Features					Hard code the value as "false"
		Allow Move Between Resources	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.allowMoveBetweenResources"
		Allow Creation In Buckets	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.allowCreationInBuckets"
		Allow Reschedule	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.allowReschedule"
		Support Of Not Ordered Activities	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.supportOfNotOrderedActivities"
		Allow Non Scheduled	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.allowNonScheduled"
		Support Of Work Zones	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.supportOfWorkZones"
		Support Of Work Skills	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.supportOfWorkSkills"
		Support Of Time Slots	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.supportOfTimeSlots"
		Support Of Inventory	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.supportOfInventory"
		Support Of Links	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.supportOfLinks"
		Support Of Preferred Resources	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.supportOfPreferredResources"
		Allow Repeating Activities	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.allowRepeatingActivities"
		Calculate Travel	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.calculateTravel"
		Allow To Search	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.allowToSearch"
		Allow To Create From Incoming Interface	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.allowToCreateFromIncomingInterface"
		Calculate Delivery Window	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.calculateDeliveryWindow"
		Sla And Service Window Use Customer Time Zone	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.slaAndServiceWindowUseCustomerTimeZone"
		Support Of Required Inventory	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.supportOfRequiredInventory"
		Disable Location Tracking	Features		SOMOFSC_ActivityTypeConfigProps	Value	PropertyName	Hard code the property name as "features.disableLocationTracking"
		language	translations		SOM_LanguageCode	OFSC_LanguageCode	SOM_LanguageCode
description	codeDescription List	name	translations	Field

Activity Data Mappings

The mapping details in the Activity Data integration point are shown in the table below.

Oracle Utilities Service Order Management Response		Oracle Field Service Enum Request			DVM Mapping			Comments
Element Name	Parent Element	Element Name	Parent Element	Type	DVM	Oracle Field Service Column	Oracle Utilities Service Order Management Column
		Label	Template Parameters	outermosttag				Gets the activity data property label from "SOMOFSC_Sync_ActivityData" look up and assign it to the element
		Request Wrapper
		Items	Request Wrapper	List
code	/standardLookup List/code DescriptionList	Label	Items	Field
		Active	Items					Hardcode as "true"
		translations	Items	List
		language	translations		SOM_ LanguageCode	OFSC_ LanguageCode	SOM_ LanguageCode
description	/standardLookup List/code DescriptionList	name	translations	Field

Device Data Mappings

The mapping details in the Device Data integration point are shown in the table below.

Oracle Utilities Service Order Management Response		Oracle Field Service Enum Request			DVM Mapping			Comments
Element Name	Parent Element	Element Name	Parent Element	Type	DVM	Oracle Field Service Column	Oracle Utilities Service Order Management Column
Device Type Mappings
		Label	Template Parameters	outermosttag				Gets the Device Type property label from “SOMOFSC_Sync_DeviceTypesData” look up and assign it to the element
		Request Wrapper
		Items	Request Wrapper	List
code	codeDescription List	Label	Items	Field
		Active	Items					Hardcode as "true"
		translations	Items	List
		language	translations		SOM_ LanguageCode	OFSC_ LanguageCode	SOM_ LanguageCode
description	codeDescription List	name	translations	Field
Device Configuration Type Mappings
		Label	Template Parameters	outermosttag				Gets the Device Configuration type property label from "SOMOFSC_Sync_DeviceConfigurationData" look up and assign it to the element
		Request Wrapper
		Items	Request Wrapper	List
code	codeDescription List	Label	Items	Field
		Active	Items					Hardcode as "true"
		translations	Items	List
		language	translations		SOM_ LanguageCode	OFSC_ LanguageCode	SOM_ LanguageCode
description	codeDescription List	name	translations	Field
Device Manufacturer Mappings
		Label	Template Parameters	outermosttag				Gets the Device Manufacturer property label from "SOMOFSC_Sync_DeviceManufacturerData" look up and assign it to the element
		Request Wrapper
		Items	Request Wrapper	List
code	codeDescription List	Label	Items	Field
		Active	Items					Hardcode as "true"
		translations	Items	List
		language	translations		SOM_ LanguageCode	OFSC_ LanguageCode	SOM_ LanguageCode
description	codeDescription List	name	translations	Field
Device Model Mappings
		Label	Template Parameters	outermosttag				Gets the Device Model property label from "SOMOFSC_Sync_DeviceModelData" look up and assign it to the element
		Request Wrapper
		Items	Request Wrapper	List
code	codeDescription List	Label	Items	Field
		Active	Items					Hardcode as "true"
		translations	Items	List
		language	translations		SOM_ LanguageCode	OFSC_ LanguageCode	SOM_ LanguageCode
description	codeDescription List	name	translations	Field
Device Head End Mappings
		Label	Template Parameters	outermosttag				Gets the Device Head End property label from "SOMOFSC_Sync_DeviceHeadEndSystemData" look up and assign it to the element
		Request Wrapper
		Items	Request Wrapper	List
code	codeDescription List	Label	Items	Field
		Active	Items					Hardcode as "true"
		translations	Items	List
		language	translations		SOM_ LanguageCode	OFSC_ LanguageCode	SOM_ LanguageCode
description	codeDescription List	name	translations	Field

The mapping details in the Register Data integration point are shown in the table below.

Oracle Utilities Service Order Management Response		Oracle Field Service Enum Request			DVM Mapping			Comments
Element Name	Parent Element	Element Name	Parent Element	Type	DVM	Oracle Field Service Column	Oracle Utilities Service Order Management Column
Register UOM Mappings
		Label	Template Parameters	outermosttag				Gets the Register UOM property label from "SOMOFSC_Sync_RegisterUOMData" look up and assign it to the element
		Request Wrapper
		Items	Request Wrapper	List
code	codeDescription List	Label	Items	Field
		Active	Items					Hardcode as "true"
		translations	Items	List
		language	translations		SOM_ LanguageCode	OFSC_ LanguageCode	SOM_ LanguageCode
description	codeDescription List	name	translations	Field
Register SQI Mappings
		Label	Template Parameters	outermosttag				Gets the Register UOM property label from "SOMOFSC_Sync_RegisterSQIData" look up and assign it to the element
		Request Wrapper
		Items	Request Wrapper	List
code	codeDescription List	Label	Items	Field
		Active	Items					Hardcode as "true"
		translations	Items	List
		language	translations		SOM_ LanguageCode	OFSC_ LanguageCode	SOM_ LanguageCode
description	codeDescription List	name	translations	Field
Register TOU Mappings
		Label	Template Parameters	outermosttag				Gets the Register TOU property label from "SOMOFSC_Sync_RegisterTOUData" look up and assign it to the element
		Request Wrapper
		Items	Request Wrapper	List
code	codeDescription List	Label	Items	Field
		Active	Items					Hardcode as "true"
		translations	Items	List
		language	translations		SOM_ LanguageCode	OFSC_ LanguageCode	SOM_ LanguageCode
description	codeDescription List	name	translations	Field