SAP Knowledge Base Article - Public

3554236 - New Hire Workflow Approval Error: "Error Occurred When Transitioning The Workflow" -2H 2024

Symptom

An error occurred: "Error occurred when transitioning the workflow" when the approver attempts to approve the workflow of the new hire.

Log Error: "ObjectType: TimeAccountTypeDateReference Error : com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: [301]: unique constraint violated(input position 1)" 

Environment

SAP SuccessFactors Employee Central – Time Management

Reproducing the Issue

  1. Navigate to Pending Workflow Request
  2. Go to New Hire Workflow
  3. Click on Approve.
  4. "Error occurred when transitioning the workflow"

Cause

  • Defect

Resolution

  1. A solution is being investigated by Product Engineering.
  2. To receive updates on this issue, bookmark this article by clicking the star. For further information on updates from subscribing KBAs, see KB Article 2171560  - How to Be Notified of New or Updated SAP Notes or KBAs.

Workaround:

For Workflow Approval Error:

  1. Go to the Workflow Page and click on Update.
  2. Remove all the values from the following fields under the Job Information Section:
    • Holiday Calendar
    • Time Profile
    • Work Schedule
    • Time Recording Variant
  3. After removing the values, approve the workflow.
  4. Once the workflow is approved successfully, navigate to Hired User Employee Profile >Job Information History > Hire Record > Edit.
  5. Add the following time information field values:
    • Holiday Calendar:
    • Time Profile:
    • Work Schedule:
    • Time Recording Variant: 
  6. Save the changes.

For Any Error During Time Information Fields Update via Job Info History:

  1. Navigate to Import and Export > Export > Time Account Type Date Reference Object.
  2. Export the file and filter using the affected User ID.
  3. If you find Time Account Type Date Reference records existing in the database even before the time information is added in Job Information > History > Hire Record, delete them using the following steps:
    • Go to Manage Data > Time Account Type Date Reference, search with the External Code, and delete the record.
  4. Once the Time Account Type Date Reference records are deleted, update the Time Information fields in Job Information.

To prevent the occurrence of the error during the hiring.

It has been observed that the issue tends to occur when Time information is added during Onboarding and then altered again during the Hiring Process. Specifically, if the hire date or time information is changed, it can lead to this problem. To avoid this, it's crucial to ensure that once the Time information is added in Onboarding, it remains consistent and is not changed during the Hiring Process. This consistency can help prevent the issue from arising. 

Should you need to make a change to the hiring process, it is recommended to do so in the Onboarding Dashboard / New Hire Details, prior to proceeding to EC Hire Please ensure to save your changes before proceeding to EC Hire.

Additional step that is required is to Disable the Onboarding Centralised Services:

To disable the Service Layer for ONB, you can follow these steps:

1. Navigate to Manage Data, then select Onboarding Configuration > DEFAULT_ONB2_CONFIG.
2. Next, choose Take Action > Make Correction.
3. Set Centralised Services in Employee Central for Enhanced Internal Hire Process Enabled to false.
4. Finally, click Save.

Please ensure to follow these steps exactly as provided to avoid any issues.

Keywords

Error occurred when transitioning the workflow, INC10418447, ObjectType: TimeAccountTypeDateReference Error : com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: [301]: unique constraint violated(input position 1),  TimeAccountTypeDateReference Error, unique constraint violated(input position 1), unique constraint violated, New Hire Workflow Error, Time Account Type Date Reference, CS20240009008996,2H2024, b2411, KI2411. , KBA , LOD-SF-EC-TIM-JOB , Time Management in Job Info - Records & Objects , LOD-SF-EC-WFL , Workflows - Configuration, Tools, Objects & Rules , LOD-SF-EC-TIM-TA , Time Accounts (TAT, TA, TAD) , Known Error

Product

SAP SuccessFactors Employee Central 2411