Oracle Field Service Request Message | Oracle Utilities Service Order Management Request 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 | |
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 |
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 |
Oracle Integration Cloud Global Fault | Oracle Field Service API Invocation Error | Comments | ||||
---|---|---|---|---|---|---|
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 |