Some customers will try to sync workflows to a new environment but experiencing this error: "Foundation object add failed : Relationship To Approver values cannot be applied to DYNAMIC_ROLE.Relationship To Approver values are valid only with ROLE."
But when we review the workflow configuration, there are no values in the Relationship To Approver for any Dynamic Roles.
SAP SuccesFactors Employee Central
Reproducing the Issue
1. Navigate to Instance Synchronization Monitor Tool
2. View the logs from the workflow sync ID
3. View the first workflow in error. You will see this message: "Foundation object add failed : This record cannot be saved as one or more record of this Workflow ID have reported error(s)., Relationship To Approver values cannot be applied to DYNAMIC_ROLE.Relationship To Approver values are valid only with ROLE."
4. Verify the affected Workflow by navigating to Manage Organization, Pay, and Job Structures > Workflow
Result: You will see the Dynamic Role configured (i.e., One Step Approver) but there is no value in Relationship to Approver.
This happens when the Workflow was initially saved with Role as approverType. Then the same workflow was edited changing the approverType from Role to Dynamic Role.
Do an export of the FO Workflow. You will see that the worflow created had approverType as DYNAMIC_ROLE but also has value to relationshipToApprover Value.
Expected result: relationshipToApprover should be cleaned whenever there are changes in the approverType. A separate Engineering ticket has been logged for the permanent fix, ECT-59662. However, there is no defined timeline yet when it will be deployed. In the meantime, customers to perform the workaround as stated in Resolution section.
To correct this, please delete the all the values in "wfStepApprover.relationshipToApprover" column for all "wfStepApprover.approverType" as "DYNAMIC_ROLE" then reimport the Workflow file via Import Foundation Data from Admin Center.
Note: A permission has to be granted to your permission role to be able to see this option (Manage Permission Role > Select a Permission Role > Manage Foundation Objects > Import Foundation Data).
Workflow Instance Sync; Workflows; Instance Synchronization Monitor Tool , KBA , LOD-SF-EC-WFL , Workflow & Trigger (Rules & XML) , Problem