Query Service Point (Oracle Field Service Initiated)

This section describes data mapping for the following:

Request Mappings

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

Oracle Field Service Request Message			Oracle Utilities Service Order Management Request Message			DVM Mapping
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Service Order Management Column	Oracle Field Service Column
QueryParameters		outermosttag	D1-FieldWorkSPQuery		outermosttag
			input	D1-FieldWorkSPQuery
			maximumRowsToReturn	input		SOMOFSC_ConfigProps	PropertyName=sp.maximumrowstoreturn	Value = 15
			lastSPIDReturned	input
streetAddress	QueryParameters		address1	input
city	QueryParameters		city	input
postalCode	QueryParameters		postal	input
			customerName	input
			badgeNumber	input
acoord_x	QueryParameters		latitude	input
acoord_y	QueryParameters		longitude	input
			includeAbolishFlag	input		SOMOFSC_ConfigProps	PropertyName=som.includeabolishflag	Value=D1YS

Response Mappings

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

Oracle Utilities Service Order Management Response Message			Oracle Field Service Message			DVM Mapping			Comments
Element Name	Parent Element	Type	Element Name	Parent Element	Type	DVM	Oracle Utilities Service Order Management Column	Oracle Field Service Column
D1-FieldWorkSPQuery			response-wrapper
output	D1-FieldWorkSPQuery
servicePoints	output	group
servicePointsList	servicePoints	List	resultSet	response-wrapper	List
servicePointQueryData	servicePointsList	group
customerInformation	servicePointQueryData	group
customerName	customerInformation	field	customer_name	resultSet
location	servicePointQueryData	group
siteAddress	location	group
address1	siteAddress	field	address	resultSet					Concatenate address1, address2, address3 and address4 values using SOMOFSC_addressFormat extenion library function
address2	siteAddress	field	address	resultSet
address3	siteAddress	field	address	resultSet
address4	siteAddress	field	address	resultSet
city	siteAddress	field	city	resultSet
suburb	siteAddress	field
crossStreet	siteAddress	field
state	siteAddress	field	state_province	resultSet
county	siteAddress	field
country	siteAddress	field	country_code	resultSet		SOMOFSC_CountryCode	SOM_CountryCode	OFSC_CountryCode
postal	siteAddress	field	postal_code	resultSet
serviceArea	location	field
timeZone	location	field	timeZone	resultSet		SOMOFSC_TimeZone.dvm	SOM_TimeZone	OFSC_TimeZone	Map this element only when the source element is present
servicePointDataDetails	servicePointQueryData	group
servicePointId	servicePointDataDetails	field	service_point_id	resultSet
meterDataDetails	servicePointQueryData	group
badgeNumber	meterDataDetails	field	meter1_number	resultSet
meterConfigurationType	meterDataDetails	field	meter1_type	resultSet		SOMOFSC_MeterConfigurationType	SOM_MeterConfigurationType	OFSC_MeterConfigurationType	Map this element only when the source element is present
itemDataDetails	servicePointQueryData	group
badgeNumber	itemDataDetails	field	item_nbr	resultSet
servicePointTypeCode	servicePointQueryData	field	service_pt_type	resultSet
servicePointTypeDescription	servicePointQueryData	field	sp_type_desc
servicePointStatusCode	servicePointQueryData	field	sp_status_code
servicePointStatusDescription	servicePointQueryData	field	sp_status_desc
servicePointSourceStatusCode	servicePointQueryData	field	sp_src_status_code						If servicePointSourceStatusCode='D1CN', map CN else map DC
servicePointSourceStatusDescription	servicePointQueryData	field	sp_src_status_desc
moreRowsAvailable	output	field	moreRowsAvailable	response-wrapper					If moreRowsAvailable=D1YS then map 'Yes' else map 'No'
errorCode	output	field
errorText	output	field	errorText	response-wrapper					Map the source value only when the source element is present else map 'NE' Example: No Error

Fault Mappings

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

Oracle Integration Cloud Global Fault			Oracle Field Service API Invocation Error
Element Name	Parent Element	Type	Element Name	Parent Element	Type
fault		OutermostTag	APIInvocationError		OutermostTag
			type	APIInvocationError	String
			title	APIInvocationError	String
details	fault	String	detail	APIInvocationError	String
errorCode	fault	String	errorCode	APIInvocationError	String
reason	fault	String
			errorDetails	APIInvocationError	List
			type	errorDetails	String
			instance	errorDetails	String
			title	errorDetails	String
			errorPath	errorDetails	String
			errorCode	errorDetails	String