SAP Knowledge Base Article - Public

2651239 - Cannot Add New Hire: Unable to generate unique Employee ID. Sequence needs to be updated.

Symptom

Unable to add any new hires to system due to error: Unable to generate unique Employee ID. Sequence needs to be updated. Please contact your Admin.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP Success Factors Employee Central

Reproducing the Issue

  1. Add New Employee; 
  2. Save;
  3. Error Message: Unable to generate unique Employee ID. Sequence needs to be updated. Please contact your Admin.

B.png

Cause

This issue is related to the 'Enable Database Sequence to generate next Employee Id' feature in Company Logo & Settings. The database sequence is supposed to be created by logic. However when this error occurs the Database Sequence did not get created (or it does not exists now).

Please note: the database sequence option for Employee IDs is now the system default.

If you have configured business rules for Employee ID generation, then the rules take precedence over the database sequence.

We recommend using the database sequence option if you receive application errors caused by duplicate employee IDs, which can happen in the following cases:

  • Hires are processed by concurrent API calls;
  • Inactive number ranges;
  • During peak times when a high volume of hires are processed by multiple users at the same time.

Please note: in certain cases, gaps in the row of assigned IDs cannot be avoided, such as aborted hires. After enabling the sequence, you may get the error with the text “Unable to generate unique Employee ID. Sequence needs to be updated. Please contact your Admin.”.

This error occurs because the next number provided by database sequence is already used for other employees. The system has a set number of attempts to find a valid number, but if it can't find one, then you will get the error.

FAQ - Additional Information

Q) Where can I get information on this from the Guide?

A) Guide: User ID Generation, Guide: Generating User IDs.

Resolution

To resolve this issue, you can update the sequence to Maximum Number already used as Employee ID for existing employees value.

To do this, enter the Maximum Number already used as Employee ID for existing employees in the field Next Person ID Assigned and save the changes.

To start the sequence with different number, update the number in the field Next Person ID Assigned and save the changes.

See Also

  • 3285156 - "Enable Database Sequence to generate next Employee ID" is not available in Company System and Logo Settings
  • 2493579 - Employee Central: Person/User IDs Used Within Employee Central - SuccessFactors Employee Profile
  • 2495643 - SuccessFactors User IDs - Clarifying the Different IDs
  • 2912730 - User ID sequence in EC
  • 2651239 - Cannot Add New Hire: Unable to generate unique Employee ID. Sequence needs to be updated
  • 2418814 - How to configure an MDF Sequence object and Business Rule to auto-generate Person ID during Hire 
  • 2678155 - Rule-based Generation of UserID/Username for Hires & Rehires with New Employment

Keywords

Unable to generate unique Employee ID. Sequence needs to be updated., Unable to generate unique Employee ID, Company Logo and Settings, Company Logo & Settings, Add New Hire, Database Sequence to generate next Employee Id, Database Sequence, User ID Generation, Employee Central, User ID, Hire, Next Person ID assigned , KBA , LOD-SF-EC-HIR , Hire & Rehire Wizards , LOD-SF-EC , Employee Central , Problem

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM suite all versions