Create Pickup Orders (Oracle Field Service Initiated)
This section describes data mapping for the following:
Request Mapping
Mapping details regarding pickup orders are shown in the table below.
Oracle Field Service Activity Created Event Message
Oracle Utilities Service Order Management Inbound Field Activity Request Message
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM Name
Oracle Field Service Column
Oracle Utilities Service Order Management Column
 
notify_POST
 
OutermostTag
D1-FARequestSynchronous
 
OutermostTag
 
 
 
 
 
 
 
request
 
Group
 
 
 
 
events.definitions.activityEvent
notify_POST
Group
 
 
 
 
 
 
 
applicationId
events.definitions.activityEvent
string
 
 
 
 
 
 
 
time
events.definitions.activityEvent
string
 
 
 
 
 
 
 
eventType
events.definitions.activityEvent
string
 
 
 
 
 
 
 
activityDetails
events.definitions.activityEvent
Group
 
 
 
 
 
 
 
resourceId
activityDetails
string
 
 
 
 
 
 
 
date
activityDetails
string
 
 
 
 
 
 
 
apptNumber
activityDetails
string
 
 
 
 
 
 
 
customerNumber
activityDetails
string
 
 
 
 
 
 
 
activityChanges
events.definitions.activityEvent
Group
 
 
 
 
 
 
 
 
 
 
sourceSystem
request
string
SOMOFSC_ConfigProps.dvm
PropertyName=som.externalsystem
value= OFSC
 
 
 
 
externalActTypeIdentifier
request
string
 
 
 
 
 
 
 
fieldTaskType
request
string
 
 
 
 
activityType
activityChanges
string
taskType
request
string
SOMOFSC_ActivityType.dvm
OFSC_ActivityType
SOM_TaskType
 
c2m_service_pt_id
activityChanges
string
spId
request
string
 
 
 
 
 
 
 
somStatus
request
string
 
 
 
 
activityId
activityDetails
integer
relatedActivityId
request
string
 
 
 
 
 
 
 
externalReferenceId
request
string
 
 
 
 
 
 
 
externalSPType
request
string
 
 
 
 
 
 
 
custDvcCompatibilityOverride
request
string
 
 
 
 
 
 
 
externalActivityElement
request
List
 
 
 
 
activityId
activityDetails
integer
requesterTransactionId
externalActivityElement
string
 
 
 
 
 
 
 
faType
externalActivityElement
string
 
 
 
 
 
 
 
faStatus
externalActivityElement
string
 
 
 
 
 
 
 
servicePointExternalId
externalActivityElement
string
 
 
 
 
timeOfBooking
activityChanges
string
startDateTime
externalActivityElement
string
SOMOFSC_ConfigProp.dvm
 
OFSCSOM_TimeZone
PropertyName=som.offset
Value=true
Use SOMOFSC_DateTimeZoneConversion extension library function to convert the datetime based on the timezone & offset
user
events.definitions.activityEvent
string
requesterUserId
externalActivityElement
string
 
 
 
 
ACTIVITY_NOTES
activityChanges
string
comments
externalActivityElement
string
 
 
 
 
 
 
 
instructions
externalActivityElement
string
 
 
 
 
 
 
 
customElements
externalActivityElement
anytype
 
 
 
 
 
 
 
addressConstituents
request
group
 
 
 
 
country_code
activityChanges
string
country
addressConstituents
string
OFSCSOM_Country_code.dvm
OFSC_CountryCode
SOM_CountryCode
 
postalCode
activityChanges
string
postal
addressConstituents
string
 
 
 
 
streetAddress
activityChanges
string
address1
addressConstituents
string
 
 
 
Need to split ofsc street address value on delimeter ',' basis and map to som address1,2,3,4 values;
Use "SOMOFSC_NoOfOccurances" extension library function to count the delimeters in the string
 
 
 
address2
addressConstituents
string
 
 
 
 
 
 
 
address3
addressConstituents
string
 
 
 
 
 
 
 
address4
addressConstituents
string
 
 
 
 
city
activityChanges
string
city
addressConstituents
string
 
 
 
 
 
 
 
number1
addressConstituents
string
 
 
 
 
 
 
 
number2
addressConstituents
string
 
 
 
 
 
 
 
county
addressConstituents
string
 
 
 
 
 
 
 
houseType
addressConstituents
string
 
 
 
 
 
 
 
geographic
addressConstituents
string
 
 
 
 
 
 
 
inCityLimit
addressConstituents
string
 
 
 
 
stateProvince
activityChanges
string
state
addressConstituents
string
 
 
 
 
latitude
activityChanges
double
geocodeLatitude
addressConstituents
string
 
 
 
 
longitude
activityChanges
double
geocodeLongitude
addressConstituents
string
 
 
 
 
 
 
 
saList
request
list
 
 
 
 
 
 
 
eventType
saList
string
 
 
 
 
 
 
 
saId
saList
string
 
 
 
 
 
 
 
contactDetails
request
group
 
 
 
 
 
 
 
customerInformation
contactDetails
group
 
 
 
 
customerName
activityChanges
string
customerName
customerInformation
string
 
 
 
 
 
 
 
contactName
customerInformation
string
 
 
 
 
customerPhone
activityChanges
string
mainPhone
customerInformation
string
 
 
 
 
customerCell
activityChanges
string
cellPhone
customerInformation
string
 
 
 
 
 
 
 
accountId
customerInformation
string
 
 
 
 
 
 
 
personId
customerInformation
string
 
 
 
 
 
 
 
isAppointmentNecessary
customerInformation
string
SOMOFSC_ConfigProps.dvm
PropertyName=pickuporder.apptneeded
Value=N
 
 
 
 
cancelReasonCode
customerInformation
string
 
 
 
 
 
 
 
cancelReasonDesc
customerInformation
string
 
 
 
 
activityId
activityChanges
integer
 
 
 
 
 
 
 
masterActivityId
activityChanges
integer
 
 
 
 
 
 
 
resourceId
activityChanges
string
 
 
 
 
 
 
 
accessSchedule
activityChanges
string
 
 
 
 
 
 
 
resourceInternalId
activityChanges
integer
 
 
 
 
 
 
 
date
activityChanges
string
 
 
 
 
 
 
 
apptNumber
activityChanges
string
 
 
 
 
 
 
 
recordType
activityChanges
string
 
 
 
 
 
 
 
status
activityChanges
string
 
 
 
 
 
 
 
workZone
activityChanges
string
 
 
 
 
 
 
 
duration
activityChanges
integer
 
 
 
 
 
 
 
timeDeliveredStart
activityChanges
string
 
 
 
 
 
 
 
timeDeliveredEnd
activityChanges
string
 
 
 
 
 
 
 
travelTime
activityChanges
integer
 
 
 
 
 
 
 
timeSlot
activityChanges
string
 
 
 
 
 
 
 
customerNumber
activityChanges
string
 
 
 
 
 
 
 
customerEmail
activityChanges
string
 
 
 
 
 
 
 
language
activityChanges
string
 
 
 
 
 
 
 
languageISO
activityChanges
string
 
 
 
 
 
 
 
reminderTime
activityChanges
integer
 
 
 
 
 
 
 
timeZone
activityChanges
string
 
 
 
 
 
 
 
timeZoneIANA
activityChanges
string
 
 
 
 
 
 
 
slaWindowStart
activityChanges
string
 
 
 
 
 
 
 
slaWindowEnd
activityChanges
string
 
 
 
 
 
 
 
deliveryWindowStart
activityChanges
string
 
 
 
 
 
 
 
deliveryWindowEnd
activityChanges
string
 
 
 
 
 
 
 
serviceWindowStart
activityChanges
string
 
 
 
 
 
 
 
serviceWindowEnd
activityChanges
string
 
 
 
 
 
 
 
endTime
activityChanges
string
 
 
 
 
 
 
 
positionInRoute
activityChanges
integer
 
 
 
 
 
 
 
teamResourceId
activityChanges
string
 
 
 
 
 
 
 
points
activityChanges
integer
 
 
 
 
 
 
 
timeOfAssignment
activityChanges
string
 
 
 
 
 
 
 
firstManualOperation
activityChanges
string
 
 
 
 
 
 
 
firstManualOperationUser
activityChanges
string
 
 
 
 
 
 
 
resourceTimeZone
activityChanges
string
 
 
 
 
 
 
 
resourceTimeZoneIANA
activityChanges
string
 
 
 
 
 
 
 
resourceTimeZoneDiff
activityChanges
integer
 
 
 
 
 
 
 
multidayTimeToComplete
activityChanges
integer
 
 
 
 
 
 
 
ACTIVITY_TYPE
activityChanges
string
 
 
 
 
 
 
 
WO_TYPE
activityChanges
string
 
 
 
 
 
 
 
WO_CLASS
activityChanges
string
 
 
 
 
 
 
 
JOB_NUMBER
activityChanges
string
 
 
 
 
 
 
 
COD
activityChanges
string
 
 
 
 
 
 
 
WO_COMMENTS
activityChanges
string
 
 
 
 
 
 
 
DISPATCHER_COMMENTS
activityChanges
string
 
 
 
 
 
 
 
PROBLEM_CODE
activityChanges
string
 
 
 
 
 
 
 
MAP_GRID
activityChanges
string
 
 
 
 
 
 
 
NODE_ID
activityChanges
string
 
 
 
 
 
 
 
TAG_NUMBER
activityChanges
string
 
 
 
 
 
 
 
SERVICES
activityChanges
string
 
 
 
 
 
 
 
ICOMS_ETA_STATUS
activityChanges
string
 
 
 
 
 
 
 
ICOMS_MANUAL_ETA_STATUS
activityChanges
string
 
 
 
 
 
 
 
FINDING_CODE
activityChanges
string
 
 
 
 
 
 
 
SOLUTION_CODE
activityChanges
string
 
 
 
 
 
 
 
FAULT_CODE
activityChanges
string
 
 
 
 
 
 
 
CLOSURE_NOTES
activityChanges
string
 
 
 
 
 
 
 
CANCEL_REASON
activityChanges
string
 
 
 
 
 
 
 
CANCEL_HOUSING_TYPE
activityChanges
string
 
 
 
 
 
 
 
CANCEL_HOUSE_COLOR
activityChanges
string
 
 
 
 
 
 
 
CANCEL_DOOR_COLOR
activityChanges
string
 
 
 
 
 
 
 
ASRO_REPLACE_OUTLET
activityChanges
string
 
 
 
 
 
 
 
ASRO_DEDICATE_RR_OUTLET
activityChanges
string
 
 
 
 
 
 
 
ASRO_REPLACE_BURY_FOOTAGE
activityChanges
string
 
 
 
 
 
 
 
ASRO_REPLACE_CABLE
activityChanges
string
 
 
 
 
 
 
 
ASRO_REPLACE_AERIAL_FOOTAGE
activityChanges
string
 
 
 
 
 
 
 
ASRO_REPLACE_AERIAL_CABLE
activityChanges
string
 
 
 
 
 
 
 
ASRO_REPLACE_HR_2_SPLITTER
activityChanges
string
 
 
 
 
 
 
 
ASRO_DRIVEWAY_BORE_NEEDED
activityChanges
integer
 
 
 
 
 
 
 
ASRO_SIDEWALK_BORE_NEEDED
activityChanges
integer
 
 
 
 
 
 
 
ASRO_TMP_CABLE_4_CONTRACT
activityChanges
integer
 
 
 
 
 
 
 
ASRO_DROP_BONDED_TO_POWER
activityChanges
integer
 
 
 
 
 
 
 
ASRO_COMMENTS
activityChanges
string
 
 
 
 
 
 
 
NOT_DONE_CODE
activityChanges
string
 
 
 
 
 
 
 
Points
activityChanges
integer
 
 
 
 
 
 
 
cdaybefore_flag
activityChanges
integer
 
 
 
 
 
 
 
cconfirmed
activityChanges
integer
 
 
 
 
 
 
 
csign
activityChanges
events.definitions.activityChanges.csign
 
 
 
 
 
 
 
PAS1
activityChanges
string
 
 
 
 
 
 
 
PAS2
activityChanges
string
 
 
 
 
 
 
 
PAS3a
activityChanges
string
 
 
 
 
 
 
 
PAS4
activityChanges
string
 
 
 
 
 
 
 
PAS5
activityChanges
string
 
 
 
 
 
 
 
PAS6
activityChanges
string
 
 
 
 
 
 
 
PAS_Recorded_Message
activityChanges
events.definitions.activityChanges.PAS_Recorded_Message
 
 
 
 
 
 
 
PAS3b
activityChanges
string
 
 
 
 
 
 
 
PAS_Recording_CSR_Notes
activityChanges
string
 
 
 
 
 
 
 
pricer
activityChanges
string
 
 
 
 
 
 
 
service_codes
activityChanges
string
 
 
 
 
 
 
 
work_agreement_sign
activityChanges
events.definitions.activityChanges.work_agreement_sign
 
 
 
 
 
 
 
notification_email
activityChanges
string
 
 
 
 
 
 
 
notifications_phone
activityChanges
string
 
 
 
 
 
 
 
Place_of_activity
activityChanges
string
 
 
 
 
 
 
 
I_wear_special_safety_belt
activityChanges
integer
 
 
 
 
 
 
 
I_used_colleague_assistance
activityChanges
integer
 
 
 
 
 
 
 
Made_sure_the_electricity_is_off
activityChanges
integer
 
 
 
 
 
 
 
Authorized_for_high_altitude_work
activityChanges
integer
 
 
 
 
 
 
 
The_weather_is_suitable
activityChanges
integer
 
 
 
 
 
 
 
I_know_the_risks
activityChanges
integer
 
 
 
 
 
 
 
House_or_Door_photo
activityChanges
events.definitions.activityChanges.House_or_Door_photo
 
 
 
 
 
 
 
Dog_photo
activityChanges
events.definitions.activityChanges.Dog_photo
 
 
 
 
 
 
 
Equipment_description
activityChanges
string
 
 
 
 
 
 
 
Issue_reason
activityChanges
string
 
 
 
 
 
 
 
Installation_failures
activityChanges
string
 
 
 
 
 
 
 
Source_of_damage
activityChanges
string
 
 
 
 
 
 
 
Damaged_equipment_description
activityChanges
string
 
 
 
 
 
 
 
What_was_done
activityChanges
string
 
 
 
 
 
 
 
Cable_length
activityChanges
string
 
 
 
 
 
 
 
email_notifications_status
activityChanges
integer
 
 
 
 
 
 
 
phone_notifications_status
activityChanges
integer
 
 
 
 
 
 
 
job_hazards
activityChanges
string
 
 
 
 
 
 
 
hazard_1
activityChanges
string
 
 
 
 
 
 
 
hazard_2
activityChanges
string
 
 
 
 
 
 
 
hazard_3
activityChanges
string
 
 
 
 
 
 
 
complete_code
activityChanges
string
 
 
 
 
 
 
 
plant_code
activityChanges
string
 
 
 
 
 
 
 
snr
activityChanges
string
 
 
 
 
 
 
 
low_ch
activityChanges
string
 
 
 
 
 
 
 
mid_ch
activityChanges
string
 
 
 
 
 
 
 
upper_ch
activityChanges
string
 
 
 
 
 
 
 
no_ports
activityChanges
integer
 
 
 
 
 
 
 
tap_value
activityChanges
integer
 
 
 
 
 
 
 
find_code_1
activityChanges
string
 
 
 
 
 
 
 
find_code_2
activityChanges
string
 
 
 
 
 
 
 
find_code_3
activityChanges
string
 
 
 
 
 
 
 
solution_code_1a
activityChanges
string
 
 
 
 
 
 
 
solution_code_1b
activityChanges
string
 
 
 
 
 
 
 
solution_code_1c
activityChanges
string
 
 
 
 
 
 
 
solution_code_1d
activityChanges
string
 
 
 
 
 
 
 
solution_code_1e
activityChanges
string
 
 
 
 
 
 
 
solution_code_2a
activityChanges
string
 
 
 
 
 
 
 
solution_code_2b
activityChanges
string
 
 
 
 
 
 
 
solution_code_2c
activityChanges
string
 
 
 
 
 
 
 
solution_code_2d
activityChanges
string
 
 
 
 
 
 
 
solution_code_2e
activityChanges
string
 
 
 
 
 
 
 
solution_code_3a
activityChanges
string
 
 
 
 
 
 
 
solution_code_3b
activityChanges
string
 
 
 
 
 
 
 
solution_code_3c
activityChanges
string
 
 
 
 
 
 
 
solution_code_3d
activityChanges
string
 
 
 
 
 
 
 
solution_code_3e
activityChanges
string
 
 
 
 
 
 
 
tech_signature
activityChanges
events.definitions.activityChanges.tech_signature
 
 
 
 
 
 
 
Animal_secured
activityChanges
integer
 
 
 
 
 
 
 
High_winds
activityChanges
integer
 
 
 
 
 
 
 
Ladder_secured
activityChanges
integer
 
 
 
 
 
 
 
Safety_gear
activityChanges
integer
 
 
 
 
 
 
 
Ventillation
activityChanges
integer
 
 
 
 
 
 
 
Electric_line
activityChanges
integer
 
 
 
 
 
 
 
Alternative_route
activityChanges
integer
 
 
 
 
 
 
 
sub_type
activityChanges
string
 
 
 
 
 
 
 
last_tech_out
activityChanges
string
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
XA_CAND_NAME
activityChanges
string
 
 
 
 
 
 
 
XA_MODEL_SITE_TYPE
activityChanges
string
 
 
 
 
 
 
 
XA_SHARING_ID
activityChanges
string
 
 
 
 
 
 
 
XA_COLLOCATION
activityChanges
string
 
 
 
 
 
 
 
XA_CN
activityChanges
string
 
 
 
 
 
 
 
XA_NOMINAL_PLAN
activityChanges
string
 
 
 
 
 
 
 
XA_SALES_REP
activityChanges
string
 
 
 
 
 
 
 
XA_UNIT_MODEL
activityChanges
string
 
 
 
 
 
 
 
XA_BRAND
activityChanges
string
 
 
 
 
 
 
 
XA_SERIAL_NUMBER
activityChanges
string
 
 
 
 
 
 
 
XA_CONTRACT_COVERAGE
activityChanges
string
 
 
 
 
 
 
 
XA_PROBLEM_SUMMARY
activityChanges
string
 
 
 
 
 
 
 
XA_ODOMETER
activityChanges
string
 
 
 
 
 
 
 
XA_GAS_PRESSURE
activityChanges
string
 
 
 
 
 
 
 
XA_PHYSICAL_DAMAGE
activityChanges
integer
 
 
 
 
 
 
 
XA_SAFETY_CHECK
activityChanges
string
 
 
 
 
 
 
 
XA_WORK_ORDER
activityChanges
string
 
 
 
 
 
 
 
XA_SERVICE_LEVEL
activityChanges
string
 
 
 
 
 
 
 
XA_RESTOCK_NEEDED
activityChanges
integer
 
 
 
 
 
 
 
XA_PART_NUMBER
activityChanges
string
 
 
 
 
 
 
 
XA_PART_QUANTITY
activityChanges
string
 
 
 
 
 
 
 
XA_SHIPPING_METHOD
activityChanges
string
 
 
 
 
 
 
 
XA_PART_COST
activityChanges
string
 
 
 
 
 
 
 
XA_LABOR_COST
activityChanges
string
 
 
 
 
 
 
 
XA_TAX
activityChanges
string
 
 
 
 
 
 
 
XA_TOTAL_COST
activityChanges
string
 
 
 
 
 
 
 
XA_TASK_TYPE
activityChanges
string
 
 
 
 
 
 
 
XA_CASE_CONTACT
activityChanges
string
 
 
 
 
 
 
 
XA_CASE_TYPE
activityChanges
string
 
 
 
 
 
 
 
XA_CASE_ACCOUNT
activityChanges
string
 
 
 
 
 
 
 
XA_CASE_REASON
activityChanges
string
 
 
 
 
 
 
 
XA_CASE_PRIORITY
activityChanges
string
 
 
 
 
 
 
 
XA_CASE_SUBJECT
activityChanges
string
 
 
 
 
 
 
 
XA_PRODUCT
activityChanges
string
 
 
 
 
 
 
 
XA_CASE_DESCRIPTION
activityChanges
string
 
 
 
 
 
 
 
XA_CASE_NOTES
activityChanges
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_NAME
activityChanges
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_OWNER
activityChanges
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_AMOUNT
activityChanges
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_STAGE
activityChanges
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_TYPE
activityChanges
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_LEAD_SOURCE
activityChanges
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_NEXT_STEP
activityChanges
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_DESCRIPTION
activityChanges
string
 
 
 
 
 
 
 
XA_LIQUID_PRESSURE
activityChanges
string
 
 
 
 
 
 
 
XA_TEMPERATURE
activityChanges
string
 
 
 
 
 
 
 
XA_RESTOCK_SHIPPING
activityChanges
string
 
 
 
 
 
 
 
XA_RESTOCK_PART_NUMBER
activityChanges
string
 
 
 
 
 
 
 
XA_PART_NEEDED
activityChanges
integer
 
 
 
 
 
 
 
XA_MISC_PART_TYPE
activityChanges
string
 
 
 
 
 
 
 
XA_PART_ORDER_BRAND
activityChanges
string
 
 
 
 
 
 
 
XA_PART_ORDER_NOTES
activityChanges
string
 
 
 
 
 
 
 
XA_DMG_ACK
activityChanges
events.definitions.activityChanges.XA_DMG_ACK
 
 
 
 
 
 
 
XA_DMG_PIC
activityChanges
events.definitions.activityChanges.XA_DMG_PIC
 
 
 
 
 
 
 
XA_ACKNOWLEDGEMENT
activityChanges
integer
 
 
 
 
 
 
 
XA_SAFETY_NOTES
activityChanges
string
 
 
 
 
 
 
 
XA_PART_TYPE
activityChanges
string
 
 
 
 
 
 
 
XA_AC_BRAND
activityChanges
string
 
 
 
 
 
 
 
XA_AH_BRAND
activityChanges
string
 
 
 
 
 
 
 
XA_FURN_BRAND
activityChanges
string
 
 
 
 
 
 
 
XA_TANK_WH_BRAND
activityChanges
string
 
 
 
 
 
 
 
XA_COMP_BRAND
activityChanges
string
 
 
 
 
 
 
 
XA_WH_TYPE
activityChanges
string
 
 
 
 
 
 
 
XA_TNKL_WH_BRAND
activityChanges
string
 
 
 
 
 
 
 
XA_CPL_COMP
activityChanges
string
 
 
 
 
 
 
 
XA_GOODMAN_COMP
activityChanges
string
 
 
 
 
 
 
 
XA_RHM_COMP
activityChanges
string
 
 
 
 
 
 
 
XA_GDM_AH
activityChanges
string
 
 
 
 
 
 
 
XA_LENNOX_AH
activityChanges
string
 
 
 
 
 
 
 
XA_RHM_AH
activityChanges
string
 
 
 
 
 
 
 
XA_TRANE_AH
activityChanges
string
 
 
 
 
 
 
 
XA_GE_TANK_WH
activityChanges
string
 
 
 
 
 
 
 
XA_KENMORE_TNK_WH
activityChanges
string
 
 
 
 
 
 
 
XA_RHM_TNK_WH
activityChanges
string
 
 
 
 
 
 
 
XA_BOSCH_TL_WH
activityChanges
string
 
 
 
 
 
 
 
XA_MAX_TL_WH
activityChanges
string
 
 
 
 
 
 
 
XA_RHM_TL_WH
activityChanges
string
 
 
 
 
 
 
 
XA_GDM_AC
activityChanges
string
 
 
 
 
 
 
 
XA_RHM_AC
activityChanges
string
 
 
 
 
 
 
 
XA_TRANE_AC
activityChanges
string
 
 
 
 
 
 
 
XA_GDM_FURN
activityChanges
string
 
 
 
 
 
 
 
XA_RHM_FURN
activityChanges
string
 
 
 
 
 
 
 
XA_WIL_FURN
activityChanges
string
 
 
 
 
 
 
 
XA_YORK_FURN
activityChanges
string
 
 
 
 
 
 
 
XA_SAFETY_SIG
activityChanges
events.definitions.activityChanges.XA_SAFETY_SIG
 
 
 
 
 
 
 
XA_SAFE_DEBRIS
activityChanges
integer
 
 
 
 
 
 
 
XA_SAFE_WIRES
activityChanges
integer
 
 
 
 
 
 
 
XA_SAFE_WATER
activityChanges
integer
 
 
 
 
 
 
 
XA_SAFE_EQUIP
activityChanges
integer
 
 
 
 
 
 
 
XA_CASE_NUMBER
activityChanges
string
 
 
 
 
 
 
 
XA_CASE_ASSET
activityChanges
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_PROBABILITY
activityChanges
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_EXPECTED_REVENUE
activityChanges
string
 
 
 
 
 
 
 
XA_OPPORTUNITY_CLOSE_DATE
activityChanges
string
 
 
 
 
 
 
 
Junk5
activityChanges
string
 
 
 
 
 
 
 
Impacted
activityChanges
string
 
 
 
 
 
 
 
Site_Plan
activityChanges
events.definitions.activityChanges.Site_Plan
 
 
 
 
 
 
 
Attachment
activityChanges
events.definitions.activityChanges.Attachment
 
 
 
 
 
 
 
Work_Status
activityChanges
string
 
 
 
 
 
 
 
Finish_Date
activityChanges
string
 
 
 
 
 
 
 
Failure_Code
activityChanges
string
 
 
 
 
 
 
 
Failure_Mode
activityChanges
string
 
 
 
 
 
 
 
Root_Cause
activityChanges
string
 
 
 
 
 
 
 
Repair_Code
activityChanges
string
 
 
 
 
 
 
 
Component_Code
activityChanges
string
 
 
 
 
 
 
 
Next_Action
activityChanges
string
 
 
 
 
 
 
 
Emp_Name
activityChanges
string
 
 
 
 
 
 
 
Regular_Shift
activityChanges
string
 
 
 
 
 
 
 
Craft
activityChanges
string
 
 
 
 
 
 
 
Regular_Type
activityChanges
string
 
 
 
 
 
 
 
Regular_Hours_HHMM
activityChanges
integer
 
 
 
 
 
 
 
Followup_Description
activityChanges
string
 
 
 
 
 
 
 
WAM_Priority
activityChanges
string
 
 
 
 
 
 
 
Due_Date
activityChanges
string
 
 
 
 
 
 
 
Start_Date
activityChanges
string
 
 
 
 
 
 
 
xa_link
activityChanges
string
 
 
 
 
 
 
 
xa_Adequate_rearview_mirrors_sw
activityChanges
string
 
 
 
 
 
 
 
xa_Safety_belts_sw
activityChanges
string
 
 
 
 
 
 
 
xa_Windshield_wiper_blades_and_fluid_sw
activityChanges
string
 
 
 
 
 
 
 
xa_Is_all_seating_in_the_vehicle_secured
activityChanges
string
 
 
 
 
 
 
 
xa_knowledgelibrary
activityChanges
string
 
 
 
 
 
 
 
xa_field_assessment
activityChanges
string
 
 
 
 
 
 
 
on_hold
activityChanges
integer
 
 
 
 
 
 
 
on_hold_comments
activityChanges
string
 
 
 
 
 
 
 
Activity_Priority
activityChanges
string
 
 
 
 
 
 
 
material_not_ready
activityChanges
integer
 
 
 
 
 
 
 
indoor
activityChanges
integer
 
 
 
 
 
 
 
Materials_Quantity
activityChanges
string
 
 
 
 
 
 
 
Materials_Cost
activityChanges
string
 
 
 
 
 
 
 
Person
activityChanges
string
 
 
 
 
 
 
 
Material_Date_Checked_Out
activityChanges
string
 
 
 
 
 
 
 
Transformer_Number
activityChanges
string
 
 
 
 
 
 
 
Buss
activityChanges
string
 
 
 
 
 
 
 
Relay_Number
activityChanges
string
 
 
 
 
 
 
 
Outage_Cause
activityChanges
string
 
 
 
 
 
 
 
Snake_Fence_Operating
activityChanges
string
 
 
 
 
 
 
 
xa_Did_you_complete_vehicle_checklist_sw
activityChanges
string
 
 
 
 
 
 
 
xa_materials_list
activityChanges
string
 
 
 
 
 
 
 
xa_materials_taken
activityChanges
string
 
 
 
 
 
 
 
A_MATERIAL_TRACKING
activityChanges
string
 
 
 
 
 
 
 
xa_incidentinformation
activityChanges
string
 
 
 
 
 
 
 
xa_assign_to_Routing_Bucket_sw
activityChanges
integer
 
 
 
 
 
 
 
Transformer
activityChanges
string
 
 
 
 
 
 
 
Schedule_Lock
activityChanges
integer
 
 
 
 
 
 
 
Entrance_Requirements
activityChanges
string
 
 
 
 
 
 
 
prem_warning
activityChanges
string
 
 
 
 
 
 
 
Unit_of_Measure
activityChanges
string
 
 
 
 
 
 
 
UOM
activityChanges
string
 
 
 
 
 
 
 
row4
activityChanges
integer
 
 
 
 
 
 
 
Add_Row_sw
activityChanges
integer
 
 
 
 
 
 
 
readHistory
activityChanges
string
 
 
 
 
 
 
 
payHistory
activityChanges
string
 
 
 
 
 
 
 
orderHistory
activityChanges
string
 
 
 
 
 
 
 
payOffAmount
activityChanges
string
 
 
 
 
 
 
 
currentAmount
activityChanges
string
 
 
 
 
 
 
 
lessThan30
activityChanges
string
 
 
 
 
 
 
 
thirtyDaysAmount
activityChanges
string
 
 
 
 
 
 
 
over60DaysAmt
activityChanges
string
 
 
 
 
 
 
 
actionTaken
activityChanges
string
 
 
 
 
 
 
 
payment
activityChanges
string
 
 
 
 
 
 
 
trComments
activityChanges
string
 
 
 
 
 
 
 
trEventId
activityChanges
string
 
 
 
 
 
 
 
tr_outageBeginDateTime
activityChanges
string
 
 
 
 
 
 
 
tr_firstCallDateTime
activityChanges
string
 
 
 
 
 
 
 
tr_estimatedRestorationDateTime
activityChanges
string
 
 
 
 
 
 
 
tr_caseNotes
activityChanges
string
 
 
 
 
 
 
 
tr_clues
activityChanges
string
 
 
 
 
 
 
 
tr_numberOfCalls
activityChanges
string
 
 
 
 
 
 
 
tr_numberOfCustomersOut
activityChanges
string
 
 
 
 
 
 
 
tr_numberOfKeyCustomers
activityChanges
string
 
 
 
 
 
 
 
tr_numberOfEmergencyCustomers
activityChanges
string
 
 
 
 
 
 
 
tr_numberOfMedicalCustomers
activityChanges
string
 
 
 
 
 
 
 
tr_deviceId
activityChanges
string
 
 
 
 
 
 
 
tr_phase
activityChanges
string
 
 
 
 
 
 
 
tr_feeder
activityChanges
string
 
 
 
 
 
 
 
tr_deviceLocation
activityChanges
string
 
 
 
 
 
 
 
tr_callList
activityChanges
string
 
 
 
 
 
 
 
tr_outageType
activityChanges
string
 
 
 
 
 
 
 
tr_eventNotes
activityChanges
string
 
 
 
 
 
 
 
tr_deviceConfirm
activityChanges
string
 
 
 
 
 
 
 
tr_eventOutcome
activityChanges
string
 
 
 
 
 
 
 
tr_actualRestoration
activityChanges
string
 
 
 
 
 
 
 
tr_excludeFromOutage
activityChanges
integer
 
 
 
 
 
 
 
tr_reasonForExclusion
activityChanges
string
 
 
 
 
 
 
 
tr_cancelationReason
activityChanges
string
 
 
 
 
 
 
 
tr_system
activityChanges
string
 
 
 
 
 
 
 
tr_subsystem
activityChanges
string
 
 
 
 
 
 
 
tr_failure
activityChanges
string
 
 
 
 
 
 
 
tr_weather
activityChanges
string
 
 
 
 
 
 
 
tr_frInterference
activityChanges
string
 
 
 
 
 
 
 
tr_remedy
activityChanges
string
 
 
 
 
 
 
 
tr_failedEquipment
activityChanges
integer
 
 
 
 
 
 
 
tr_serialNumber
activityChanges
string
 
 
 
 
 
 
 
tr_primaryVoltage
activityChanges
string
 
 
 
 
 
 
 
tr_secondaryVoltage
activityChanges
string
 
 
 
 
 
 
 
tr_rating
activityChanges
string
 
 
 
 
 
 
 
tr_units
activityChanges
string
 
 
 
 
 
 
 
tr_phase2
activityChanges
string
 
 
 
 
 
 
 
Status_Found
activityChanges
string
 
 
 
 
 
 
 
Status_Left
activityChanges
string
 
 
 
 
 
 
 
FA_Comments
activityChanges
string
 
 
 
 
 
 
 
w_requestedBy
activityChanges
string
 
 
 
 
 
 
 
w_meetingPlace
activityChanges
string
 
 
 
 
 
 
 
w_flowHydMainSize
activityChanges
string
 
 
 
 
 
 
 
w_maintType
activityChanges
string
 
 
 
 
 
 
 
w_PressHydMainSize
activityChanges
string
 
 
 
 
 
 
 
w_mainType
activityChanges
string
 
 
 
 
 
 
 
w_hydrantLocation
activityChanges
string
 
 
 
 
 
 
 
w_flowHydrantNumber
activityChanges
string
 
 
 
 
 
 
 
w_nozzles
activityChanges
string
 
 
 
 
 
 
 
w_size
activityChanges
string
 
 
 
 
 
 
 
w_testTimeStart
activityChanges
string
 
 
 
 
 
 
 
w_testTimeEnd
activityChanges
string
 
 
 
 
 
 
 
w_totalTime
activityChanges
string
 
 
 
 
 
 
 
w_pitotPressure
activityChanges
integer
 
 
 
 
 
 
 
w_flowRate
activityChanges
integer
 
 
 
 
 
 
 
w_flowTotal
activityChanges
integer
 
 
 
 
 
 
 
w_staticPressue
activityChanges
integer
 
 
 
 
 
 
 
w_residualPressue
activityChanges
integer
 
 
 
 
 
 
 
w_estFlowRate
activityChanges
integer
 
 
 
 
 
 
 
Boroughs
activityChanges
string
 
 
 
 
 
 
 
Block
activityChanges
string
 
 
 
 
 
 
 
Lot
activityChanges
string
 
 
 
 
 
 
 
BBL
activityChanges
string
 
 
 
 
 
 
 
Add2
activityChanges
string
 
 
 
 
 
 
 
City2
activityChanges
string
 
 
 
 
 
 
 
State2
activityChanges
string
 
 
 
 
 
 
 
Zip2
activityChanges
string
 
 
 
 
 
 
 
NYC2
activityChanges
integer
 
 
 
 
 
 
 
g_APTYPE1
activityChanges
string
 
 
 
 
 
 
 
GL_APTYPE2
activityChanges
string
 
 
 
 
 
 
 
GL_LeakDet
activityChanges
integer
 
 
 
 
 
 
 
GL_RedTag1
activityChanges
integer
 
 
 
 
 
 
 
GL_TagApl_Pic_2
activityChanges
events.definitions.activityChanges.GL_TagApl_Pic_2
 
 
 
 
 
 
 
GL_Location
activityChanges
string
 
 
 
 
 
 
 
Outside_Leak_Causes
activityChanges
string
 
 
 
 
 
 
 
GL_OUT_LEAK_TYPE
activityChanges
string
 
 
 
 
 
 
 
GL_OUT_Source
activityChanges
string
 
 
 
 
 
 
 
GL_OUT_LEL-ARRIVAL
activityChanges
integer
 
 
 
 
 
 
 
GL_CGI_DEV_NO
activityChanges
string
 
 
 
 
 
 
 
GL_tag_appl_Pic1
activityChanges
events.definitions.activityChanges.GL_tag_appl_Pic1
 
 
 
 
 
 
 
GL_OUT_PIC_1
activityChanges
events.definitions.activityChanges.GL_OUT_PIC_1
 
 
 
 
 
 
 
Reason_Tag_1
activityChanges
string
 
 
 
 
 
 
 
GL_RE_TAG2_Reason
activityChanges
string
 
 
 
 
 
 
 
GL_ACTION_TAKEN
activityChanges
string
 
 
 
 
 
 
 
Leak_Log_Nbr
activityChanges
string
 
 
 
 
 
 
 
Time_Made_Safe
activityChanges
string
 
 
 
 
 
 
 
OUTSIDE_EQUIPMENT
activityChanges
string
 
 
 
 
 
 
 
Building_Evacuated
activityChanges
string
 
 
 
 
 
 
 
Time_made_safe_HHMM
activityChanges
string
 
 
 
 
 
 
 
GL_LEAK_DETECTED
activityChanges
string
 
 
 
 
 
 
 
GL_IN_COMMENTS
activityChanges
string
 
 
 
 
 
 
 
GL_OUT_COMMENTS
activityChanges
string
 
 
 
 
 
 
 
GL_IN_REPAIRS
activityChanges
string
 
 
 
 
 
 
 
GL_IN_REPAIR1
activityChanges
string
 
 
 
 
 
 
 
GL_IN_REPAIR2
activityChanges
string
 
 
 
 
 
 
 
GL_RED_TAGS
activityChanges
string
 
 
 
 
 
 
 
GL_IN_REPAIRS2
activityChanges
integer
 
 
 
 
 
 
 
GL_RECHECK_IND
activityChanges
string
 
 
 
 
 
 
 
GL_RECHECK_DATE
activityChanges
string
 
 
 
 
 
 
 
GL_METER_STATUS
activityChanges
string
 
 
 
 
 
 
 
GL_BILLABLE_IND
activityChanges
string
 
 
 
 
 
 
 
GL_BILLABLE_PARTY
activityChanges
string
 
 
 
 
 
 
 
GL_BILLABLE_ADDR_IND
activityChanges
string
 
 
 
 
 
 
 
GL_BILLABLE_ADDR
activityChanges
string
 
 
 
 
 
 
 
GL_GAS_STATUS
activityChanges
string
 
 
 
 
 
 
 
GL_COMPLETION_COMMENTS
activityChanges
string
 
 
 
 
 
 
 
GL_PPM_ARRIVAL
activityChanges
integer
 
 
 
 
 
 
 
GL_FLAME_PACK_NO
activityChanges
string
 
 
 
 
 
 
 
GL_BAR_HOLE_1
activityChanges
integer
 
 
 
 
 
 
 
GL_BAR_CODE_2
activityChanges
integer
 
 
 
 
 
 
 
GL_BAR_HOLE_2
activityChanges
integer
 
 
 
 
 
 
 
GL_BAR_HOLE_3
activityChanges
integer
 
 
 
 
 
 
 
v_tires
activityChanges
integer
 
 
 
 
 
 
 
v_water
activityChanges
integer
 
 
 
 
 
 
 
v_lights
activityChanges
integer
 
 
 
 
 
 
 
v_comments
activityChanges
string
 
 
 
 
 
 
 
Order_Type
activityChanges
string
 
 
 
 
 
 
 
GL_BUILDING_EVAC_TIME2
activityChanges
string
 
 
 
 
 
 
 
GL_PX_SIZE_FRACTIONS
activityChanges
string
 
 
 
 
 
 
 
GL_PX_SIZE_INCH
activityChanges
string
 
 
 
 
 
 
 
GL_PX_MATERIAL
activityChanges
string
 
 
 
 
 
 
 
GL_PX_EXPOSED
activityChanges
string
 
 
 
 
 
 
 
GL_PX_ANNODE
activityChanges
string
 
 
 
 
 
 
 
GL_ANNODE_SIZE
activityChanges
string
 
 
 
 
 
 
 
GL_PX_SEDIMENT
activityChanges
string
 
 
 
 
 
 
 
GL_PX_COATING_TYPE
activityChanges
string
 
 
 
 
 
 
 
GL_PX_COATING_COND
activityChanges
string
 
 
 
 
 
 
 
GL_PX_CORR_EXT
activityChanges
string
 
 
 
 
 
 
 
GL_PX_EXT_CORR_EXTENT
activityChanges
string
 
 
 
 
 
 
 
GL_IN_PPM_ARRV
activityChanges
string
 
 
 
 
 
 
 
GL_LEL_PCT_ARRV
activityChanges
string
 
 
 
 
 
 
 
GL_BAR1_PCT
activityChanges
string
 
 
 
 
 
 
 
GL_BAR2_PCT
activityChanges
string
 
 
 
 
 
 
 
GL_BAR3_PCT
activityChanges
string
 
 
 
 
 
 
 
Surface
activityChanges
string
 
 
 
 
 
 
 
Probable_Pressure
activityChanges
string
 
 
 
 
 
 
 
Repair_Type
activityChanges
string
 
 
 
 
 
 
 
Leak_Cause
activityChanges
string
 
 
 
 
 
 
 
Actual_Pipe_Material
activityChanges
string
 
 
 
 
 
 
 
Actual_Pressure
activityChanges
string
 
 
 
 
 
 
 
Odorant_Detected
activityChanges
string
 
 
 
 
 
 
 
Test_Medium
activityChanges
string
 
 
 
 
 
 
 
Test_Device
activityChanges
string
 
 
 
 
 
 
 
Pressure_Test_PSIG
activityChanges
string
 
 
 
 
 
 
 
Test_Duration_Hours
activityChanges
string
 
 
 
 
 
 
 
Test_Duration_Mins
activityChanges
string
 
 
 
 
 
 
 
Test_Duration_Secs
activityChanges
string
 
 
 
 
 
 
 
Repaired_By
activityChanges
events.definitions.activityChanges.Repaired_By
 
 
 
 
 
 
 
Technician_Name
activityChanges
string
 
 
 
 
 
 
 
Leak_Class
activityChanges
string
 
 
 
 
 
 
 
GL_CaseReviewed
activityChanges
integer
 
 
 
 
 
 
 
GLR_RepairPhoto
activityChanges
events.definitions.activityChanges.GLR_RepairPhoto
 
 
 
 
 
 
 
GLR_ReferCM
activityChanges
integer
 
 
 
 
 
 
 
Appointment
activityChanges
integer
 
 
 
 
 
 
 
newMtr_status_left
activityChanges
string
 
 
 
 
 
 
 
lessThirtyDaysAmount
activityChanges
string
 
 
 
 
 
 
 
disputedAmount
activityChanges
string
 
 
 
 
 
 
 
sixtyDaysAmount
activityChanges
string
 
 
 
 
 
 
 
 
Response Mapping
Response mapping details are as shown in the table below.
Oracle Utilities Service Order Management Inbound Field Activity Response Message
Oracle Field Service Activity Completed Event Message
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM Name
Oracle Field Service Column
Oracle Utilities Service Order Management Column
 
D1-FARequestSynchronousResponse
 
outermosttag
update_PATCH
 
outermosttag
 
 
 
 
D1-FARequestSynchronous
D1-FARequestSynchronousResponse
 
 
 
 
 
 
 
 
 
 
 
TemplateParameters
update_PATCH
Group
 
 
 
 
 
 
 
activities.definitions.updateActivitySchema
update_PATCH
Group
 
 
 
 
request
D1-FARequestSynchronous
Group
 
 
 
 
 
 
 
relatedActivityId
request
string
activityId
TemplateParameters
string
 
 
 
If referenceId!=""
response
D1-FARequestSynchronous
Group
 
 
 
 
 
 
 
referenceId
response
string
apptNumber
activities.definitions.updateActivitySchema
string
 
 
 
 
 
 
 
common_utilities_product_code
activities.definitions.updateActivitySchema
string
 
 
 
Hard code to 'OFSC'
Get Activity Request
“getActivity_REQUEST” mapping details are as shown in the table below.
Oracle Field Service Activity Created Event Message
Oracle Utilities Service Order Management Inbound Field Activity Resquest Message
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM Name
Oracle Field Service Column
Oracle Utilities Service Order Management Column
 
notify_POST
 
OutermostTag
canonical_GET
 
OutermostTag
 
 
 
 
events.definitions.activityEvent
notify_POST
 
 
 
 
 
 
 
 
 
 
 
TemplateParameters
canonical_GET
 
 
 
 
 
activityId
activityDetails
 
activityId
TemplateParameters