FSL Work Order Migration

Insert Order — FSL Object Hierarchy

FSL's object model has strict parent-child dependencies. Attempting to insert child records before parents fail with lookup validation errors. The correct sequence is:

1. Account / Contact / Asset (if not already present)
2. WorkOrder (lookup to Account, Contact, Asset optional)
3. WorkOrderLineItem (lookup to WorkOrder)
4. ServiceAppointment (lookup to WorkOrder or WorkOrderLineItem)
5. AssignedResource (lookup to ServiceAppointment + ServiceResource)
6. ProductConsumed (lookup to WorkOrderLineItem + PricebookEntry)

Each step must complete with zero errors before proceeding to the next. Use External IDs and upsert operations so failed loads can be re-run without duplicates.

Status Picklist Constraints

ServiceAppointment has a Status picklist whose values are tied to FSL lifecycle transitions. Attempting to insert a ServiceAppointment record with a status value (e.g., Completed, Cannot Complete) that does not exist as an active picklist value in the target org will fail.

Before migration, verify all source status values are active in the target org's ServiceAppointment Status picklist. For historical closed appointments, this means activating Completed, Cannot Complete, and any custom values present in the source system.

Scheduling Automation During Migration

When AssignedResource records are inserted, FSL's territory-based scheduling engine may interpret the insert as a new assignment and trigger optimization jobs, recalculations, or time-slot evaluations. These can:

• Conflict with migrated scheduled times
• Generate duplicate scheduling history
• Slow the migration significantly

Best practice: Disable FSL optimization settings in Setup > Field Service Settings before migration. Re-enable after load completes and data is validated.

ProductConsumed Requirements

ProductConsumed records represent parts actually used on a job. They require a PricebookEntryId lookup to a valid PricebookEntry for the product. If the PricebookEntry does not exist (e.g., product is not in the org's standard pricebook), the insert fails.

Pre-migration step: load or confirm all Products and their PricebookEntry records in the standard pricebook before loading ProductConsumed.

Common Patterns

Upsert with External IDs

When to use: All FSL migration loads to ensure re-runnable, duplicate-safe loads.

How it works: Add a custom External ID field (e.g., Legacy_Id__c) to WorkOrder, WorkOrderLineItem, ServiceAppointment, AssignedResource, and ProductConsumed. Use Data Loader or the Bulk API 2.0 upsert operation with the external ID as the match key.

// Data Loader upsert mapping
WorkOrder.Legacy_Id__c → Source.WORK_ORDER_ID
WorkOrder.Account__r.Legacy_Account_Id__c → Source.ACCOUNT_ID

Why not insert: Plain insert with no External ID makes re-runs create duplicates. Upsert allows resuming a failed migration without cleanup.

Disabling Automation Before Migration

When to use: Any time AssignedResource or ServiceAppointment records are loaded in bulk.

How it works:

1. Setup > Field Service Settings > Scheduling > uncheck "Enable Optimization"
2. If using FSL Triggers (managed package), disable via FinServ__TriggerSettings__c custom setting equivalent for FSL — or use the FSL Trigger Settings custom setting to disable individual triggers
3. Load migration data
4. Re-enable settings
5. Validate assigned resource records and scheduled times

Decision Guidance

Recommended Workflow

Step-by-step instructions for an AI agent or practitioner working on this task:

1. Inventory all source status values — Extract distinct ServiceAppointment Status values from source data. Confirm each is active in the target org's Status picklist. Activate missing values before migration begins.
2. Disable FSL scheduling automation — In Setup > Field Service Settings, disable optimization before loading any AssignedResource or ServiceAppointment records.
3. Add External ID fields — Add Legacy_Id__c (or equivalent) External ID fields to WorkOrder, WorkOrderLineItem, ServiceAppointment, AssignedResource, and ProductConsumed.
4. Pre-load Products and PricebookEntry records — Ensure all products referenced by ProductConsumed have active PricebookEntry records in the standard pricebook.
5. Load in strict hierarchy order — Account/Contact/Asset → WorkOrder → WorkOrderLineItem → ServiceAppointment → AssignedResource → ProductConsumed. Validate zero errors at each step before proceeding.
6. Re-enable FSL automation — After all records are loaded and spot-validated, re-enable scheduling optimization in Field Service Settings.
7. Validate data integrity — Run SOQL to confirm all ServiceAppointments have at least one AssignedResource where expected, all ProductConsumed records have valid PricebookEntryId, and status values match source data.

Review Checklist

• All source ServiceAppointment status values are active in target org
• FSL optimization disabled before AssignedResource load
• External IDs added to all FSL migration objects
• Products and PricebookEntry records exist for all ProductConsumed references
• Migration runs in strict hierarchy order with zero errors at each step
• FSL optimization re-enabled and validated after migration
• Post-load SOQL validation run to check record counts and key field values

Salesforce-Specific Gotchas

Non-obvious platform behaviors that cause real production problems:

1. Status picklist validation is hard — not advisory — Inserting a ServiceAppointment with a status value not in the org's picklist throws INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST. This stops bulk loads and requires picklist activation before the load, not after.
2. AssignedResource inserts trigger FSL scheduling engine — Inserting AssignedResource records without disabling optimization can trigger time-slot recalculations that overwrite migrated scheduled times or generate spurious history records.
3. ProductConsumed requires PricebookEntry, not just Product — A Product2 record alone is insufficient. The product must have an active PricebookEntry in a pricebook assigned to the Work Order's account. Missing PricebookEntry throws FIELD_INTEGRITY_EXCEPTION.
4. Case migration and Work Order migration are separate — Work Orders may be related to Cases but the two objects have independent migration paths. Loading WorkOrders that reference non-existent Case records will fail on the lookup field — migrate Cases first if WO-Case relationships are in scope.

Output Artifacts

Related Skills

• data/fsl-territory-data-setup — Service territory, operating hours, and resource data setup required before FSL work order migration
• data/fsl-resource-and-skill-data — ServiceResource and ServiceResourceSkill data that AssignedResource records reference