Work Order Updated Field Mappings R13 (1.0)

The following tables detail field mappings for OEC OFSC Work Order Updated 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 Rescheduled in Oracle Fusion Service

When a work order is rescheduled in Oracle Fusion Service, even if other fields are also updated, the fields shown in the following table are updated.

Oracle Fusion Service Attribute	Value
WO_INTEGRATION_STATUS_CD	ORA_WO_INT_RESCHED_SUBMITTED
WO_INTEGRATION_MSG_CD	ORA_WO_INT_MSG_RESCHED_SUB

Work Order Updated in Oracle Fusion Service

When a work order is updated in Oracle Fusion Service, the fields shown in the following table are updated.

Oracle Fusion Service Attribute	Value
WO_INTEGRATION_STATUS_CD	ORA_WO_INT_UPDATEE_SUBMITTED
WO_INTEGRATION_MSG_CD	ORA_WO_INT_MSG_UPDATE_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	Condition
WoId	Long	apptNumber	String	NA	NA
WoNumber	String	wo_number	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
CaseNote	String	wo_case_note	String	yes	NA
ReminderTime	Integer	reminderTime	Integer	NA	NA
RequestedDate	Date	date	String	NA	NA
RequestedTimeSlot	String	timeSlot	String	NA	NA
FsResourceExternalId	String	resourceId	String	NA	NA

Field Mapping for an Update Successful

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

Oracle Fusion Service Attribute	Data Type	Oracle Field Service Property	Data Type	Condition
WoIntegrationMsgCd	String	NA	NA	Null
WoIntegrationStatusCd	String	NA	NA	If(WoIntegrationStatusCd = ORA_WO_INT_RESCHED_SUBMITTED Then ORA_WO_INT_RESCHED_SUCCESSFULElse ORA_WO_INT_UPDATE_ SUCCESSFUL)
ScheduledDate	String	Date	Date	NA
ScheduledTimeSlot	String	Timeslot	String	NA

Field Mapping for an Activity Update Failure

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

Oracle Fusion Service Attribute	Data Type	Oracle Field Service Property	Data Type	Condition
WoIntegrationMsgCd	String	NA	NA	If WoIntegrationMsgCd = ORA_WO_INT_RESCHED_SUBMITTED Then ORA_WO_INT_MSG_RESCHEDUE_FAIL Else ORA_WO_INT_MSG_UPDATE_FAIL
WoIntegrationStatusCd	String	NA	NA	If WoIntegrationStatusCd = ORA_WO_INT_RESCHED_SUBMITTED Then ORA_WO_INT_RESCHED_FAILED Else ORA_WO_INT_UPDATE_FAILED
FsErrorDetail	String	NA	NA	Substring(ErrorDetail,1,500)