SAP Knowledge Base Article - Public

2497455 - How to change/reset the CURRENT value in a Sequence object

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

  1. Go to admin centre > manage data > sequence > make correction.
  2. You cannot change CURRENT field from the UI as it is a read-only field.

Capture.jpg

Cause

  1. We can use sequence object to assign a particular sequence when an employee is hired.
  2. This sequence is incremented whenever you do a new hire ONLY via 'add new employee' tool.
  3. 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.
  4. You cannot change CURRENT field from the UI as it is a read-only field.

Resolution

  1. Export sequence you would like to edit:

captur12.png

  1. Sequence exported:

captur2.png

  1. Current value to be assigned is 0. Change it to 155 and prepare an import file:

captur3.png

  1. Validate and import:

captur4.png

  1. Now you can verify that current value is set as you entered it in import file.

captur5.png

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