Symptom
How to modify CURRENT value in a sequence object when its read-only?
- The sequence is incremented in import actions when the 'get next value()' function is called. Only during hire import, the ID generation via sequence wont happen as we already import with ID in basic import file, however the sequence need to be set correctly so that the hire from UI starts from next sequence number. For this scenario, this KBA can be helpful in setting correct current sequence number.
Disclaimer:
- Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
- This change should only be made with the greatest caution. The sequence number is set to read only by default on purpose as updating this sequence erroneously can lead to serious issues. Any one updating the sequence must be sure on why the change is being done and understand the status or allotment of current, previous and all in between sequence numbers.
Environment
SAP SuccessFactors HXM Suite
SAP SuccessFactors Employee Central
Reproducing the Issue
- Go to admin centre > manage data > sequence > make correction.
- You cannot change CURRENT field from the UI as it is a read-only field.
Cause
- We can use sequence object to assign a particular sequence when an employee is hired.
- This sequence is incremented whenever you do a new hire ONLY via 'add new employee' tool.
- But when you import say 50 new employees via import, the sequence number is not incremented and we would manually need to change the current value to say +50.
- You cannot change CURRENT field from the UI as it is a read-only field.
Resolution
- Export sequence you would like to edit:
- Sequence exported:
- Current value to be assigned is 0. Change it to 155 and prepare an import file:
- Validate and import:
- Now you can verify that current value is set as you entered it in import file.
This 155 will be the value assigned to any new hire done from 'add new employee' tool.
Keywords
change, sequence, value, current, person ID, personID, increment, hire, foundation object, import , KBA , LOD-SF-EC-EMP , Employment Information (Employment Details) , LOD-SF-EC , Employee Central , LOD-SF-EC-HIR , Hire & Rehire Wizards , How To
Product
SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Suite all versions