Oracle Fusion Inventory items to Oracle Field Service Inventory Items Field Mapping

Inventory Data Model Field Description Oracle Field Service Field Field Type Description Mandatory
Inventory Organization code of Inventory organization Resource id String ID of the parent bucket where the Inventory organization is mapped M
- - Inventory Type Enum

Type of Inventory to stort in Oracle Fusion Field Service

"part" - For non-serialised Inventory

"part_sn" - For serialised inventory

M
On-Hand item SerialNumber Serial number string Serial number in case of a serialised inventory O
On-Hand item ItemNumber Part Item Number string Unique number for the part item M
On-Hand item ItemNumber Part Item Desc string Name / Description of the part item O
On-Hand item Revision Part Item Revision string Revision of the inventory item, if present O
concat (On-Hand item ItemNumber, On-Hand item Revision ) part_item_number_rev string Unique number for the part item concatenated with the revision O
concat (subinventory, locator, part_item_number_rev) inventory_identifier string Used as the unique identifier when syncing inventory items to inventory org in Oracle Fusion Field Service M
PrimaryUOMCode part_uom_code string UOM Code associated with the part item coming from Inventory management M
PrimaryQuantity quantity number M
Locator mwo_locator string Locator from which the inventory item is obtained M
SubInventory mwo_inventory_subInv string Subinventory from which the inventory item is obtained M