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