Work Order Canceled Field Mappings R13 (1.0)
The following tables detail field mappings for OEC OFSC Work Order Canceled 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 Canceled in Oracle Fusion Service
When a work order is canceled 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_CANCEL_SUBMITTED |
|
WO_INTEGRATION_MSG_CD |
ORA_WO_INT_MSG_CANCEL_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 |
|
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 |
|
TimezoneCode |
String |
timeZone |
String |
NA |
NA |
|
CaseNote |
String |
wo_case_note |
String |
NA |
NA |
|
ReminderTime |
Integer |
reminderTime |
Integer |
NA |
NA |
Field Mapping for a Cancel Successful Activity
The following table shows the Oracle Fusion Service work order field mapping to the Oracle Field Service activity for a cancel successful.
|
Oracle Fusion Service Attribute |
Data Type |
Oracle Field Service Property |
Data Type |
Condition |
|---|---|---|---|---|
|
WoStatusCd |
String |
NA |
NA |
|
|
WoIntegrationMsgCd |
String |
NA |
NA |
|
|
WoIntegrationStatusCd |
String |
NA |
NA |
|
|
ScheduledDate |
String |
Date |
Date |
NA |
|
ScheduledTimeSlot |
String |
|
String |
NA |