1. Configuring Applications
  2. Routing Run Result Fields

Routing Run Result Fields

This section provides a list of routing run result fields.

Important: This information only applies to Oracle Field Service environments. You can verify whether you've Oracle Field Service or Oracle Fusion Field Service, by signing in and checking on the About page.
Sl. No. Name Label Data Type Required Description
1 Routing Run Id routing_run_result.routingRunId INTEGER True The unique ID of the specific routing run.
2 Routing Plan Name routing_run_result.routingPlan VARCHAR2 The name of the routing plan that was run. This is not unique.
3 Routing Plan Id routing_run_result.routingPlanId INTEGER The unique ID of the routing plan that was run.
4 Routing Plan Label routing_run_result.routingPlanLabel VARCHAR2 The label of the routing plan.
5 Routing Profile Name routing_run_result.routingProfile VARCHAR2 The name of the routing profile that the routing plan belongs to. Is not unique.
6 Routing Profile Id routing_run_result.routingProfileId INTEGER The unique ID of the routing profile that the routing plan belongs to.
7 Routing Profile Label routing_run_result.routingProfileLabel VARCHAR2 The label of the routing profile.
8 Start Type routing_run_result.startType VARCHAR2
Type of routing start:
  • When routing is started automatically on schedule, the value is 'automatic'.
  • When routing is started manually by user, the value is 'manual'.
9 Resource Id provider.pid INTEGER The internal ID of the routing bucket.
10 Target Date routing_run_result.targetDate DATE The date for which the activities are routed. The format is 'YYYY-MM-DD'.
11 Number Of Days routing_run_result.numberOfDays INTEGER For a single day routing, the value is 1. For multi-day routing, the value is the number of days routed, starting from 'targetDate' and going into the future.
12 Result routing_run_result.result VARCHAR2
  • When the routing is executed successfully, and some activities are moved as a result, the value is 'succeeded'.
  • When the routing execution is stopped by the user, the value is 'stopped'.
  • When the routing execution fails, the value is 'failed'.
13 Message routing_run_result.message VARCHAR2 The field contains the error description when 'result' is 'failed' or 'skipped'.
14 Routing Run Duration routing_run_result.routingRunDuration INTEGER The duration (in seconds) of the routing run.
15 Activities Matched routing_run_result.activitiesMatched INTEGER The number of activities and pre-existing activity segments matching the routing plan filters.
16 Activities In Routes Before Routing routing_run_result..activitiesInRoutesBeforeRouting INTEGER The number of activities and pre-existing activity segments that were in routes of resources before the routing run.
17 Activities Routed routing_run_result.activitiesRouted INTEGER The number of activities scheduled and assigned by the routing run.
18 Activities Not Routed routing_run_result.activitiesNotRouted INTEGER The number of activities matching the routing plan filters but not routed.
19 Resources Matched routing_run_result.resourcesMatched INTEGER The number of resources matching the routing plan filters.
20 Resources Used routing_run_result.resourcesUsed INTEGER The number of resources with assigned or removed activities by the routing run.
21 Average Working Time routing_run_result.averageWorkingTime INTEGER The average working time of the resources (in minutes).
22 Average Overtime routing_run_result.averageOvertime INTEGER The average overtime time of the resources (in minutes).
23 Average Travel Time routing_run_result.averageTravelTime INTEGER The average travel time of the resources (in minutes).
24 Average Downtime routing_run_result.averageDowntime INTEGER The average downtime time of the resources (in minutes).
25 Extended Status routing_run_result.extendedStatus VARCHAR2
The additional information on the type and result of the routing run. The field includes:
  1. The type of this routing execution. Can be one of the following values:

    • 'routing',

    • 'routing_rollback',

  2. If type is 'routing', then next position in the field shows routingAlgorithmType

    The filed may take values:
    • bulk
    • urgent
    • immediate
  3. If type is 'bulk' 'routing', then next position in the field shows result if it differs from possible values of the field result: When there are no activities found, the value is 'skipped'.

  4. The next position in the field is set to notAccepted and points at the case when it is 'bulk' 'routing', 'result' is 'succeeded' but was not applied.

    Allowed combinations:
    • routing-rollback
    • routing-bulk
    • routing-urgent
    • routing-immediate
    • routing-bulk-skipped
    • routing-bulk-notAccepted
    • routing-immediate-skipped
    • routing-broadcast
26 Average Mileage routing_run_result.averageMileage INTEGER The average travel mileage of the resources (in miles or km).
27 Reoptimized Activities routing_run_result.reoptimizedActivities INTEGER The number of activities re-optimized by the routing run.
28 Created Activities routing_run_result.createdActivities INTEGER The number of activities were created automatically for the routing run.
29 Removed Activities routing_run_result.removedActivities The number of removed activities (which may be warehouse visits or activity segments) Removed Activities routing_run_result.removedActivities The number of removed activities (which may be warehouse visits or activity segments) INTEGER The number of removed activities (which may be warehouse visits or activity segments)
30 Start Time routing_run_result.startTime DATE The time when the routing run started in UTC time zone. The time format is YYYY-MM-DD HH:MM:SS.
31 Assurance Percentage routing_run_result.assurancePercentage NUMBER The assurance of routing result, from 0 to 100. The lesser assurance is, the less confident is the result, which, in most cases, may be connected to sub-optimal results. Typically, for good results one may expect assurance 85 or more.
32 Consumed Time routing_run_result.consumedTime INTEGER Actual time (in seconds) that was consumed by SLR and routing engine during the routing run.
33 Routing Plan Time Limit routing_run_result.routingPlanTimeLimit INTEGER Time limit for the routing plan (in seconds).
34

Routing Plan Optimization Goal

routing_run_result.routingPlanOptimizationGoal

VARCHAR2
If there is an optimization goal at the routing run, the field shows the goal. May be one of the following:
  • balanced
  • minimize_travel
  • maximize_jobs
  • maximize_jobs_density
  • reduce_overdue
35 Routing Plan Time Limit SLR Percentage routing_run_result.routingPlanTimeLimitSlrPercentage INTEGER Part of total time limit which is time limit for SLR service
36 Not Assigned Due To Validation Issues Count routing_run_result.notAssignedDueToValidationIssuesCount INTEGER Configuration / Data validation errors
37 Not Assigned Due To Changes While Routing Was Running Count routing_run_result.notAssignedDueToChangesWhileRoutingWasRunningCount INTEGER The assignment is impossible due to changes that happened while routing was running.
38 Not Assigned Due To Activity Configuration Count routing_run_result.notAssignedDueToActivityConfigurationCount INTEGER Not-assignment reason: configuration of an activity.
39 Not Assigned Due To Resources Configuration Count routing_run_result.notAssignedDueToResourcesConfigurationCount INTEGER Not-assignment reason: configuration of resources
40 Not Assigned Needs Manual Assignment Count routing_run_result.notAssignedNeedsManualAssignmentCount INTEGER Not-assignment reason: the constraint violation. Try to assign the activity manually
41 Not Assigned Other Issues Count routing_run_result.notAssignedOtherIssuesCount INTEGER Other Not-Assignment Reasons.
42 Partially Assigned Segmentable Activities Count routing_run_result.partiallyAssignedSegmentableActivitiesCount INTEGER Partially assigned segmentable activities.
43 Not Assigned Due To Dynamic Mode Restrictions Count routing_run_result.notAssignedDueToDynamicModeRestrictionsCount INTEGER Activities were not assigned in accordance with the routing plan dynamic mode settings.
44 Not Assigned Due To Cost Settings Count routing_run_result.notAssignedDueToCostSettingsCount INTEGER Not-assignment reason: routing plan and/or resource type cost settings may be suboptimal.
45 Not Assigned Due To Travel Restrictions Count routing_run_result.notAssignedDueToTravelRestrictionsCount INTEGER Not-assignment reason: activity locations and routing plan travel settings prohibits assignment.
46 Not Assigned Due To Optimization Criteria Count routing_run_result.notAssignedDueToOptimizationCriteriaCount INTEGER Activities were not assigned in accordance with the optimization criteria chosen.
47 Resource Blocked Due To Routing Schedule Count routing_run_result.resourceBlockedDueToRoutingScheduleCount INTEGER Resources are blocked by another run because of sub-optimal routing plan schedule.
48 Not Assigned Needs Overtime Overdue Rules Relaxation Count routing_run_result.notAssignedNeedsOvertimeOverdueRulesRelaxationCount INTEGER Not-assignment reason: the overtime/overdue constraint violation. Try to assign manually with relaxed constrains or just relax business rules on overdue/overtime for the routing plan.
49 Subcategory routing_run_result.subcategory VARCHAR2 Reserved for future needs
50 Resource External Id provider.external_id VARCHAR2 The external ID of the routing bucket.
51 Routing Rollback Run Id routing_run_result.routingRollbackRunId INTEGER The unique ID of the routing run which were rolled back.
52 Type of Routing Run Run routing_run_result.type VARCHAR2 The type of the routing run. The field is obsolete.