Order Data Sync Fails Between Salesforce and ERP
A company integrates Salesforce Order Management with an external ERP system for order fulfillment. The integration uses a middleware tool that syncs order data every 15 minutes. Recently, orders are not being created in the ERP system, and the middleware logs show errors: 'Order creation failed: Missing required field: CustomerNumber.' The Salesforce order records have the CustomerNumber field populated, but it is a custom field. The middleware maps Salesforce fields to ERP fields using a mapping configuration. The ERP requires CustomerNumber to be a 10-digit string. In Salesforce, CustomerNumber is a text field with values like 'CUST-1234'. The integration worked previously but stopped after a Salesforce sandbox refresh.
1. What is the likely cause of the sync failure, and how would you troubleshoot it?
Read the worked answer
The likely cause is that after the sandbox refresh, the field mapping or the field itself changed. The error indicates that CustomerNumber is missing in the ERP payload. Possible reasons: 1) The custom field CustomerNumber was not refreshed or was removed in the sandbox, so the middleware cannot find it. 2) The field-level security or permission set changed, so the integration user cannot access the field. 3) The middleware mapping configuration was not updated after the refresh, and it might be pointing to a different field. Troubleshoot: 1) Verify that the CustomerNumber field exists on the Order object in the sandbox and is populated. 2) Check the integration user's profile/permission set for field-level access. 3) Review the middleware mapping to ensure it correctly maps Salesforce CustomerNumber to ERP CustomerNumber. 4) Check if the field type changed (e.g., from text to picklist). 5) Test by manually triggering the integration for a single order and inspecting the payload.
2. What steps would you take to resolve the issue and prevent recurrence?
Read the worked answer
To resolve: 1) Ensure the CustomerNumber field exists and is populated in the sandbox. If it was lost during refresh, recreate it and populate data. 2) Update the middleware mapping to correctly map the field. 3) Adjust the field-level security to allow the integration user access. 4) If the ERP requires a 10-digit string, transform the Salesforce value (e.g., extract digits from 'CUST-1234' to '1234' and pad to 10 digits) in the middleware or via a formula field. To prevent recurrence: 1) Include custom fields and integration configurations in the sandbox refresh template or use a post-refresh script. 2) Document integration dependencies. 3) Implement a validation step in the middleware to check for required fields before sending to ERP. 4) Set up monitoring and alerts for sync failures.