Symptom
You are facing an issue in Object Replication between the EC to ERP when trying to delimit records for Positions.
Environment
- SAP SuccessFactors HXM Suite
- Replicating Organizational Objects from Employee Central to SAP ERP HCM
Reproducing the Issue
- Create a position in EC
- Replicate this position using the report RH_SFIOM_ORG_OBJ_REPL_QUERY
- Execute the report RH_SFIOM_VIEW_ORG_STRUC_RPRQ to save the data inside the ERP database
- Delimit the position in EC (set as inactive and change the date)
- Replicate this position again using the report RH_SFIOM_ORG_OBJ_REPL_QUERY
- Execute the report RH_SFIOM_VIEW_ORG_STRUC_RPRQ to save the data inside the ERP database
After the step 6, we will see that the EC and ERP will have different data. That means object replication failed.
Resolution
The root cause of this issue is that you don't have set the "MDF Version History" to "Delete History". This is required in order to also replicate deletions to the ERP system.
Please check the guide page Known Issue: Deletion Isn't Replicated from Employee Central.
After doing this change, please notice the step 4 of this link (to replicate all deletions that weren't transferred to SAP ERP HCM, trigger a "full load" for the object in question, for example, for Position). This "full load" will generate the OData API query without any "Last modified date" greater than in the filters and this will sync your EC and ERP data correctly.
For your information, find below the explanation on how it works:
- For the Position API to recognize the delimitations which are happening and that Position should also be recognized by last modified, you have to enable "MDF version History = Delete History"
- This will alert the Audit Framework to start listening the delimitations which are happening for Position API.
- After enabling it, please do the OData Metadata Refresh.
- Now, again do the "Initial Full Load" for all the positions from EC to ERP.
- Moving on from this point in the timeframe, any timeslice which will be deleted in the Position data in EC (Admin Center -> Manage Data) will be recognized equal to someone changing the position data and last modified will be affected thus helping the middleware to detect the changes using the Position API.
- Now the interface runs in delta load, pulling this position.
- Finally the logic from ERP detects this change and delimits on the Infotype level when the respective timeslice does not come in the API response.
Conclusion
The reason for the "MDF version history" to be marked as "Delete History" is to make the Position API recognize the changes in the data when a position record is delimited.
In addition, please ensure that you have all the required permissions to retrieve "Positions" assigned to the API user. All the permissions to the API user can be seem in the chapter Granting Permissions for Organizational Object Replication of the guide.
Note: the terms "delimit" and "delimitation" does not mean deletion of the record. It means: set the position as inactive and change its end date so the system knows that it has ended and it not valid anymore. If you delete the position record through Take Action > Permanently Delete Entry option on Manage Data, this won't be replicated to ERP. This is explained in the guide: "Deletions of organizational objects in Employee Central aren't replicated to SAP ERP HCM. We recommend you set organizational objects that are no longer relevant to Inactive in Employee Central. This means that the replication delimits the corresponding infotype record in the SAP ERP HCM system.".
See Also
Keywords
report RH_SFIOM_ORG_OBJ_REPL_QUERY, report RH_SFIOM_VIEW_ORG_STRUC_RPRQ, MDF Version History > Delete History, MDF Foundation Object > Position, SuccessFactors Employee Central HCI - Object replication, SuccessFactors Employee Central Boomi - Object replication, Issue in Object Replication between the EC to ERP when trying to delimit records for Positions, lastModifiedDate, last modified, ec, position management, boomi, api, odata, CPI , KBA , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , LOD-EC-INT-EE , Employee Integration EC to ERP On Premise , LOD-SF-INT-SAP , Please use LOD-EC-INT* , Problem