Symptom
What are the behaviors of mdfSystemLastModifiedDate and mdfSystemLastModifiedBy of Parent and Child Object, especially there has workflow configured on this Object?
Environment
SAP SuccessFactors HXM Suite
Cause
Resolution
For Parent Object Record mdfSystemLastModifiedDate:
- mdfSystemLastModifiedDate is always the last modified date and time of final approval.
For Child Object Record mdfSystemLastModifiedDate:
- Update/Make correction Cases:
If there is no inflight change to child record, and approve the workflow directly, Child last modified date will not be updated, it will be the initiator's workflow initiating timestamp.
If there are inflight changes to child records, Child last modified date is updated to the timestamp of final approval.
The expected outcome is that if the child records are updated during the workflow approving, last modified date is updated. If there are no changes to the child record, data in child record will not be updated.
- Insert/Create Cases: Last modified Date for both parent and child should be same as these are new records creations -- the timestamp of final approval.
Regarding mdfSystemLastModifiedBy:
If in this workflow pending record, there has no inflight changes, lastmodifiedby is the initiator, if there has inflight changes lastmodifiedby is the last approver.
Currently customer may will use Integration Center to check the mdfSystemLastModifiedBy of MDF records and sometimes it shows the last approver's information even there has no inflight changes on this pending record, and this is a defect per confirmed by engineering team, we will update the fix progress on this KBA accordingly.
If customer has audit requirements, we recommend to use MDF Change Audit Report.
See Also
- 2790859 - Change Audit Log Report for Metadata Framework (MDF) Configuration and Data Changes.
Keywords
MDF, metadata framework, workflow, mdfSystemLastModifiedDate, mdfSystemLastModifiedBy, pending data, inflight changes, parent object, child object, MDF-83486 , KBA , LOD-SF-MDF-WFL , Custom Object based Workflows , How To