Query Service Call
This section describes data mapping for the following:
Oracle Cloud Infrastructure Fault Mappings
The “FaultMappings” integration point details are as shown in the table below:
Oracle Cloud Infrastructure Fault Message
API Invocation Request Message
DVM Mapping
Comments
 
 
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM
Column 1
Column 2
fault
$queryServiceCallFaultObject
Group
 
 
 
 
 
 
 
errorCode
fault
string
errorCode
APIInvocationError
string
 
 
 
 
 
 
 
errorDetails
APIInvocationError
Group
 
 
 
 
$errorDetails
 
Field
instance
errorDetails
string
 
 
 
 
$errorCode
 
Field
errorCode
errorDetails
string
 
 
 
 
Oracle Utilities Customer Cloud Service Query Service Call Request
The “QueryServiceCallReq” integration point details are as shown in the table below:
Oracle Utilities Customer Cloud Service Request Message
Oracle Utilities Work and Asset Cloud Service Request Message
DVM Mapping
Comments
 
 
 
 
 
 
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM
Oracle Utilities Customer Cloud Service Column
Oracle Utilities Work and Asset Cloud Service Column
requestMessage
components.schemas.requestMessage_request
Group
 
 
 
 
 
 
 
searchLimit
requestMessage
decimal
limit
QueryParameters
string
 
 
 
 
 
 
 
SEARCHSERVICECALL_request
searchServiceCall
Group
 
 
 
 
serviceCallNumber
requestMessage
string
serviceCallNumber
SEARCHSERVICECALL_request
string
 
 
 
 
description
requestMessage
string
description
SEARCHSERVICECALL_request
string
 
 
 
 
serviceCategory
requestMessage
string
serviceCategory
SEARCHSERVICECALL_request
string
OUTL-BRT-CCS_WACS_ServiceCategory
CCS_ServiceCategory
WACS_ServiceCategory
This lookup transforms CCS service category to WACS service category and vice versa.
serviceCode
requestMessage
string
serviceCode
SEARCHSERVICECALL_request
string
OUTL-BRT-CCS_WACS_ServiceCode
CCS_ServiceCode
WACS_ServiceCode
This lookup transforms CCS service code to WACS service code and vice versa.
contactFirstName
requestMessage
string
firstName
SEARCHSERVICECALL_request
string
 
 
 
 
contactLastName
requestMessage
string
lastName
SEARCHSERVICECALL_request
string
 
 
 
 
phone
requestMessage
string
phoneNumber
SEARCHSERVICECALL_request
string
 
 
 
 
address1
requestMessage
string
address
SEARCHSERVICECALL_request
string
 
 
 
 
city
requestMessage
string
city
SEARCHSERVICECALL_request
string
 
 
 
 
postal
requestMessage
string
postal
SEARCHSERVICECALL_request
string
 
 
 
 
Oracle Utilities Work and Asset Cloud Service Query Service Call Response
The “QueryServiceCallResponse” integration point details are as shown in the table below:
Oracle Utilities Work and Asset Cloud Service Response Message
Oracle Utilities Customer Cloud Service Request Message
DVM Mapping
Comments
 
 
 
 
 
 
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM
Oracle Utilities Work and Asset Cloud Service Column
Oracle Utilities Customer Cloud Service Column
SEARCHSERVICECALL_response
searchServiceCallResponse
Group
 
 
 
 
 
 
 
serviceCalls
SEARCHSERVICECALL_response
Field
responseMessage
components.schemas.responseMessage_response
responseMessage
 
 
 
 
creationDateTime
 
string
createDateTime
serviceCallsResult
dateTime
 
 
 
 
serviceCall
 
Group
 
 
 
 
 
 
 
serviceCallId
serviceCall
string
serviceCallId
serviceCallsResult
string
 
 
 
 
serviceCallNumber
 
string
serviceCallNumber
serviceCallsResult
string
 
 
 
 
description
 
string
description
serviceCallsResult
string
 
 
 
 
serviceCategory
serviceCategory
string
serviceCategory
serviceCallsResult
string
OUTL-BRT-CCS_WACS_ServiceCategory
WACS_ServiceCategory
CCS_ServiceCategory
This lookup transforms CCS service category to WACS service category and vice versa
serviceCode
serviceCode
string
serviceCode
serviceCallsResult
string
OUTL-BRT-CCS_WACS_ServiceCode
WACS_ServiceCode
CCS_ServiceCode
This lookup transforms CCS service code to WACS service code and vice versa
status
 
string
serviceCallStatusDescription
serviceCallsResult
string
 
 
 
 
requiredByDate
 
string
requiredByDate
serviceCallsResult
date
 
 
 
 
callbackRequired
 
string
callBackRequired
serviceCallsResult
string
OUTL-BRT-CCS_WACS_CallBackCode
WACS_CallBackCode
CCS_CallBackCode
This lookup transforms CCS call back to WACS call back and vice versa
country
 
string
country
serviceCallsResult
string
 
 
 
 
postal
 
string
postal
serviceCallsResult
string
 
 
 
 
address1
 
string
address1
serviceCallsResult
string
 
 
 
 
geographicCode
 
string
geoCode
serviceCallsResult
string
 
 
 
 
geocodeLatitude
 
decimal
latitude
serviceCallsResult
decimal
 
 
 
 
geocodeLongitude
 
decimal
longitude
serviceCallsResult
decimal
 
 
 
 
firstName
 
string
contactFirstName
serviceCallsResult
string
 
 
 
 
lastName
 
string
contactLastName
serviceCallsResult
string
 
 
 
 
primaryPhone
 
string
contactPrimaryPhone
serviceCallsResult
string
 
 
 
 
mobilePhone
 
string
contactMobilePhone
serviceCallsResult
string
 
 
 
 
homePhone
 
string
contactHomePhone
serviceCallsResult
string