Oracle Utilities Customer Cloud Service | Oracle Field Service Cloud | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM | Column 1 | Column 2 | |
$GlobalFaultObject | Outermosttag | APIInvocationError | Outermosttag | ||||||
fault | $GlobalFaultObject | Group | |||||||
details | fault | Field | detail | APIInvocationError | String | Function : substring-before(substring-after($GlobalFaultObject/nsmpr0:fault/nsmpr0:details, '<ResponseText>'), '</ResponseText>') | |||
errorCode | fault | String | errorCode | APIInvocationError | String | ||||
Oracle Utilities Customer 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 | D1-FieldWorkSPQuery | Outermosttag | |||||||
D1-FieldWorkSPQuery | D1-FieldWorkSPQuery | Group | |||||||
input | D1-FieldWorkSPQuery | Group | |||||||
maximumRowsToReturn | input | Decimal | SOMOFSC_ConfigProps | PropertyName : sp.maximumrowstoreturn | Value : true | Maps PropertyName Cloumn to the respective Value Column. Do not change the values in PropertyName column. | |||
execute | Group | ||||||||
QueryParameters | execute | Group | |||||||
streetAddress | QueryParameters | String | address1 | input | String | Only if (/nssrcmpr:execute/nssrcmpr:QueryParameters/nsmpr1:streetAddress) | |||
city | QueryParameters | String | city | input | String | Only if (/nssrcmpr:execute/nssrcmpr:QueryParameters/nsmpr1:city) | |||
postalCode | QueryParameters | String | postal | input | String | Only if (/nssrcmpr:execute/nssrcmpr:QueryParameters/nsmpr1:postalCode!='Unavailable') | |||
acoord_x | QueryParameters | String | latitude | input | Decimal | Only if (/nssrcmpr:execute/nssrcmpr:QueryParameters/nsmpr1:acoord_x) | |||
acoord_y | QueryParameters | String | longitude | input | Decimal | Only if (/nssrcmpr:execute/nssrcmpr:QueryParameters/nsmpr1:acoord_y) | |||
includeAbolishFlag | input | String | SOMOFSC_ConfigProps | PropertyName : som.includeabolishflag | Value : true | Maps PropertyName Cloumn to the respective Value Column. Do not change the values in PropertyName column. | |||
Oracle Utilities Customer Cloud Service | Oracle Field Service Cloud | DVM Mapping | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM | Column 1 | Column 2 | |
$invokeSOMServicePoint | Outermosttag | executeResponse | Outermosttag | ||||||
D1-FieldWorkSPQueryResponse | $invokeSOMServicePoint | Group | |||||||
D1-FieldWorkSPQuery | D1-FieldWorkSPQueryResponse | Group | |||||||
output | D1-FieldWorkSPQuery | Group | |||||||
servicePoints | output | Group | |||||||
servicePointsList | servicePoints | Field | response-wrapper | executeResponse | Field | ||||
servicePointQueryData | Group | resultSet | response-wrapper | Group | |||||
customerInformation | servicePointQueryData | Group | |||||||
customerName | customerInformation | String | customer_name | resultSet | String | Only if (tns:servicePointQueryData/tns:customerInformation/tns:customerName) | |||
address | resultSet | String | Only if (tns:servicePointQueryData/tns:location/tns:siteAddress/tns:address1) and Function : nsmpr4:SOMOFSC_addressFormat(tns:servicePointQueryData/tns:location/tns:siteAddress/tns:address1,tns:servicePointQueryData/tns:location/tns:siteAddress/tns:address2,tns:servicePointQueryData/tns:location/tns:siteAddress/tns:address3,tns:servicePointQueryData/tns:location/tns:siteAddress/tns:address4,nsmpr2:lookupValue('tenant/resources/dvms/SOMOFSC_ConfigProps', 'PropertyName', 'ofsc.address.delimiter', 'Value', ',')) | ||||||
location | servicePointQueryData | Group | |||||||
siteAddress | location | Group | |||||||
city | siteAddress | String | city | resultSet | String | Only if (tns:servicePointQueryData/tns:location/tns:siteAddress/tns:city) | |||
state | siteAddress | String | state_province | resultSet | String | Only if (tns:servicePointQueryData/tns:location/tns:siteAddress/tns:state) | |||
country | siteAddress | String | country_code | resultSet | String | SOMOFSC_CountryCode | SOM_CountryCode | OFSC_CountryCode | Only if (tns:servicePointQueryData/tns:location/tns:siteAddress/tns:country) |
postal | siteAddress | String | postal_code | resultSet | String | Only if (tns:servicePointQueryData/tns:location/tns:siteAddress/tns:postal) | |||
timeZone | location | String | timeZone | resultSet | String | SOMOFSC_TimeZone | SOM_TimeZone | SOM_TimeZoneIANA | Only if (tns:servicePointQueryData/tns:location/tns:timeZone) |
servicePointDataDetails | servicePointQueryData | Group | |||||||
servicePointId | servicePointDataDetails | String | service_point_id | resultSet | String | Only if (tns:servicePointQueryData/tns:servicePointDataDetails/tns:servicePointId) | |||
servicePointTypeCode | servicePointQueryData | String | service_pt_type | resultSet | String | Only if (tns:servicePointQueryData/tns:servicePointTypeCode) | |||
meterDataDetails | servicePointQueryData | Group | |||||||
badgeNumber | meterDataDetails | String | meter1_number | resultSet | String | Only if (tns:servicePointQueryData/tns:meterDataDetails/tns:badgeNumber) | |||
meter1_type | resultSet | String | SOMOFSC_MeterConfigurationType | SOM_MeterConfigurationType : tns:servicePointQueryData/tns:meterDataDetails/tns:meterConfigurationType | OFSC_MeterConfigurationType : tns:servicePointQueryData/tns:meterDataDetails/tns:meterConfigurationType | Only if (tns:servicePointQueryData/tns:meterDataDetails/tns:meterConfigurationType) | |||
itemDataDetails | servicePointQueryData | Group | |||||||
badgeNumber | itemDataDetails | String | item_nbr | resultSet | String | Only if (tns:servicePointQueryData/tns:itemDataDetails/tns:badgeNumber) | |||
servicePointTypeDescription | servicePointQueryData | String | sp_type_desc | resultSet | String | Only if (tns:servicePointQueryData/tns:servicePointTypeDescription) | |||
sp_src_status_code | resultSet | String | When (tns:servicePointQueryData/tns:servicePointSourceStatusCode = 'D1CN') and Only if (tns:servicePointQueryData/tns:servicePointSourceStatusCode), hardcoded as 'CN' Otherwise and only if (tns:servicePointQueryData/tns:servicePointSourceStatusCode), hardcoded as 'DC' | ||||||
servicePointSourceStatusDescription | servicePointQueryData | String | sp_src_status_desc | resultSet | String | Only if (tns:servicePointQueryData/tns:servicePointSourceStatusDescription) | |||
servicePointStatusCode | servicePointQueryData | String | sp_status_code | resultSet | String | Only if (tns:servicePointQueryData/tns:servicePointStatusCode) | |||
servicePointStatusDescription | servicePointQueryData | String | sp_status_desc | resultSet | String | Only if (tns:servicePointQueryData/tns:servicePointStatusDescription) | |||
moreRowsAvailable | response-wrapper | String | When ($invokeSOMServicePoint/nsmpr0:D1-FieldWorkSPQueryResponse/tns:D1-FieldWorkSPQuery/tns:output/tns:moreRowsAvailable = 'D1YS') and only if ($invokeSOMServicePoint/nsmpr0:D1-FieldWorkSPQueryResponse/tns:D1-FieldWorkSPQuery/tns:output/tns:moreRowsAvailable), hardcoded as 'Yes' Otherwise and only if ($invokeSOMServicePoint/nsmpr0:D1-FieldWorkSPQueryResponse/tns:D1-FieldWorkSPQuery/tns:output/tns:moreRowsAvailable), hardcoded as 'No' | ||||||
errorText | output | String | errorText | response-wrapper | String | When ($invokeSOMServicePoint/nsmpr0:D1-FieldWorkSPQueryResponse/tns:D1-FieldWorkSPQuery/tns:output/tns:errorText) Otherwise, hardcoded as 'NE' | |||