Oracle Maintenance to Oracle Fusion Field Service - Work Order Data
Use the table to map the header, operations, operation items, and operation resources of Oracle Maintenance with Oracle Fusion Field Service.
| Sl.No | URL | Query Params/Payload | Fields Used from API | Integrations Using this API |
| 1 | Get One Work Order |
expand=WorkOrderDFF onlyData=true |
WorkOrderNumber WorkOrderId WorkOrderDescription OrganizationCode OrganizationId AssetNumber WoAssetId PlannedStartDate PlannedCompletionDate |
Oracle Maintenance OFS Upsert Activity Helper |
| 2 | Get Asset |
expand=assetDFF onlyData=true |
AssetId AssetNumber AssetDescription InstalledDate SerialNumber |
Oracle Maintenance OFS Upsert Activity Helper |
| 3 | Get All Operations of Workorder |
expand="WorkOrderOperationDFF,WorkOrderOperationResource,WorkOrderOperationMaterial" onlyData=true limit=100 orderBy=OperationSequenceNumber:asc |
WoOperationId OperationName OperationSequenceNumber OperationDescription OrganizationId WorkCenterCode PlannedStartDate PlannedCompletionDate InventoryItemNumber InventoryItemId RequiredQuantity SupplySubInventory SupplyLocator
|
Oracle Maintenance OFS Upsert Activity Helper Oracle Maintenance OFS Delete Activity Helper |
| 4 | Get Operation |
onlyData=true expand=WorkOrderOperationResource,WorkOrderOperationMaterial limit=100 orderBy=OperationSequenceNumber:asc |
WoOperationId OperationName OperationSequenceNumber OperationDescription OrganizationId WorkCenterCode PlannedStartDate PlannedCompletionDate InventoryItemNumber InventoryItemId RequiredQuantity SupplySubInventory SupplyLocator |
|
| 5 | Update Operation Material |
{ "SupplyType" : "1" } |
||
| 6 | GetAllItem |
ItemId=300000177306732 OrganizationId=300000152243516 |
ItemId SerialGenerationValue |
|
| 7 | GetAllOperationResources |
onlyData=true expand=WorkOrderOperationResourceDFF,WorkOrderOperationResourceInstance limit=100 orderBy=ResourceSequenceNumber:asc |
WoOperationResourceId ResourceSequenceNumber ResourceCode StandardOperationCode RequiredUsage ResourceDescription ProfileCode LaborInstanceId
|
|
| 8 | UpdateOperationResource |
{ "ChargeType": "MANUAL" } |
||
| 11 | Update WO. Op. Resource |
Workorder Id WO Operation Id WO Op Resource Id |
Charge Type | Oracle Maintenance OFS Upsert Activity Helper |
| 17 | Get WO. Op. Resource Instances |
Workorder Id WO Operation Id WO Op Resource Id |
Oracle Maintenance OFS WO Status Update Helper | |
| 18 | Delete Wo. Op. Resource Instance |
Workorder Id WO Operation Id WO Op Resource Id WO Op Resource Instance Id |
Oracle Maintenance OFS WO Status Update Helper | |
| 19 | Get all Work Centers | Oracle Maintenance OFS WorkCenter Sync | ||
| 20 | Get all Work Center Resources | Oracle Maintenance OFS WorkZone Update Helper | ||
| 21 | Get all labour resources | Oracle Maintenance OFS WorkZone Update Helper | ||
| 22 | Get all equipment resources | Oracle Maintenance OFS WorkZone Update Helper | ||
| 23 | Get all resources | Oracle Maintenance OFS WorkZone Update Helper |