Inventory Sync to Oracle Fusion Field Service: Real-Time Available Information Sync

Sl. No. URL Query Params or Payload Fields Used from API Integrations Using this API
1

Get all organizations

limit=1000

OrganizationId,

OrganizationCode,

OrganizationName,

ManagementBusinessUnitName

Oracle Maintenance OFS Inventory Sync
2

Get all subinventories

onlyData=true&

limit=1000&

expand=itemSubinventories,locators&

q=OrganizationCode={OrganizationCode}

SubinventoryGroup,

SecondaryInventoryName,

locators

Oracle Maintenance OFS Inventory Sync
3

Get all inventory balances

onlyData=true&

limit=1000&

q=OrganizationCode={OrganizationCode};

SubinventoryCode={SubinventoryCode};PrimaryQuantity>0&

expand=serials

ItemNumber,

Revision,

Locator,

PrimaryQuantity,

Serials

Oracle Maintenance OFS Inventory Sync Helper
4

Inventory Available Quantity Details

{ "OrganizationCode": {OrganizationCode}, "ItemNumber": {ItemNumber}, "Subinventory": {Subinventory}, "Locator":{Locator} }

AvailableToTransact

Oracle Maintenance OFS Inventory Sync Helper
5

Get Inventory Serial Numbers

onlyData=true&

q=OrganizationId={OrganizationId};

Reserved=No;UsageCode=3;

ItemNumber={ItemNumber};

SubinventoryCode={Subinventory};Locator={Locator}&limit=1000&offset=0

SerialNumber Oracle Maintenance OFS Inventory Sync Helper
6

Get Work Order Operation Materials

MaterialSequenceNumber,

Quantity,

WoOperationMaterialId

Oracle OFS Maintenance Inventory Reserve Helper
7

Create Operation materials

{ "MaterialSequenceNumber": 30, "InventoryItemNumber": "Gasket Set", "Quantity": 1, "UnitOfMeasure": "Each", "SupplyType": "1", "RequiredDate": "2017-08-08T00:00:00+00:00" }

Oracle OFS Maintenance Inventory Reserve Helper
8

Update Operation Materials

{ "RequiredQuantity": 1 }

Oracle OFS Maintenance Inventory Reserve Helper
9

Get all reservations

q=OrganizationCode={ORGANIZATION_CODE};DemandSourceType='Work order';SupplySourceType='On hand';ItemNumber={ITEM_NUMBER}&expand=all

Oracle OFS Maintenance Inventory Reserve Helper
10

Delete one reservation

Oracle OFS Maintenance Inventory Reserve Helper
11

Create a reservations

{ "OrganizationCode": "M001", "ItemNumber": "Axis Cable", "DemandSourceType": "Work order", "DemandSourceHeaderNumber": "MNT1WO-1902", "DemandSourceLineId": "300000259262849", "SupplySourceType": "On hand", "SubinventoryCode": "LocSubInv", "Locator": "Aisle...", "ReservationQuantity": "1", "ReservationUOMCode": "zzu" }

Oracle OFS Maintenance Inventory Reserve Helper