Work Order Created Field Mappings R13 (1.0)

The following tables detail field mappings for OEC OFSC Work Order Created R13 (1.0) between Oracle Fusion Service and Oracle Field Service. The mapping uses the Oracle Field Service standard and administrator-defined properties.

Work Order Created in Oracle Fusion Service

The fields shown in the following table are updated when a work order is created in Oracle Fusion Service:

Oracle Fusion Service Attribute	Value
WO_INTEGRATION_STATUS_CD	ORA_WO_INT_CREATE_SUBMITTED
WO_INTEGRATION_MSG_CD	ORA_WO_INT_MSG_CREATE_SUB

Work Order Field Mapping

The following table shows the Oracle Fusion Service work order field mapping to the Oracle Field Service activity.

Oracle Fusion Service Attribute	Data Type	Oracle Field Service Property	Data Type	Administrator-Defined Property	Condition
WoId	Long	apptNumber	String	NA	NA
WoNumber	String	wo_number	String	NA	NA
FsTypeCd	String	activityType	String	NA	NA
PrimaryAssetName	String	wo_asset_name	String	yes	NA
PrimaryAssetSerialNumber	String	wo_asset_serial_number	String	yes	NA
PrimaryAssetInstallDate	Date	wo_asset_install_date	String	yes	NA
PrimaryAssetPurchaseDate	Date	wo_asset_purchase_date	String	yes	NA
PrimaryAssetStatusCode	String	wo_asset_status	String	yes	NA
PrimaryAssetProduct	String	wo_asset_product	String	yes	NA
AccountPartyName	String	wo_account_name	String	yes	NA
ContactName	String	customerName	String	NA	NA
ContactEmail	String	customerEmail	String	NA	NA
ContactPhoneNumber	String	customerPhone	String	NA	NA
ContactAltPhoneNumber	String	customerCell	String	NA	NA
Address1 Address2 Address3 Address4	String	streetAddress	String	NA	concat(Address1,Address2,Address3,Address4)
City	String	city	String	NA	NA
PostalCode	String	postalCode	String	NA	NA
State Province	String	stateProvince	String	NA	NA
Country	String	country_code	String	NA	NA
TimezoneCode	String	timeZone	String	NA	NA
WoArea	String	resourceId	String	NA	NA
CaseNote	String	wo_case_note	String	NA	NA
Duration	Integer	duration	Integer	NA	NA
ReminderTime	Integer	reminderTime	Integer	NA	NA
ResolutionDueDateLocal	String	slaWindowEnd	String	NA	If RequestedDate = "" and ResolutionDueDateLocal != "" concat((substring(ResolutionDueDateLocal,1,10), ' ',(substring(ResolutionDueDateLocal,12,8))
RequestedDate	Date	date	String	NA	NA
RequestedTimeSlot	String	timeSlot	String	NA	NA
SrNumber	String	wo_sr_number	String	NA	yes
FsResourceExternalId	String	resourceId	String	NA	NA

Field Mapping for a Successful Activity Create

The following table shows the Oracle Fusion Service work order field mapping to the Oracle Field Service activity for an Activity Create successful.

Oracle Fusion Service Attribute	Data Type	Oracle Field Service Property	Data Type	Condition
WoStatusCd	String	NA	NA	=ORA_SVC_WO_PENDING
WoIntegrationMsgCd	String	NA	NA	Null
WoIntegrationStatusCd	String	NA	NA	=ORA_WO_INT_CREATE_ SUCCESSFUL
ScheduledDate	String	Date	Date	NA
ScheduledTimeSlot	String	Timeslot	String	NA
FsActivityId	Long	activityId	Integer	NA

Field Mapping for an Activity Create Failure

The following table shows the Oracle Fusion Service work order field mapping to the Oracle Field Service activity for an Activity Create failure.

Oracle Fusion Service Attribute	Data Type	Oracle Field Service Property	Data Type	Condition
WoIntegrationMsgCd	String	NA	NA	=ORA_WO_INT_MSG_CREATE_FAIL
WoIntegrationStatusCd	String	NA	NA	=ORA_WO_INT_CREATE_FAILED
FsErrorDetail	String	NA	NA	Substring(ErrorDetail,1,500)