My Oracle Support Banner

Rehires Failing With Error (Doc ID 2073790.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Fusion Benefits Cloud Service - Version and later
Oracle Fusion Benefits - Version and later
Information in this document applies to any platform.


On : version, Global Human Resources

Rehires are failing with error message

Error Message faultName: {{}ServiceException} messageType: {{}ServiceException} parts: {{ ServiceErrorMessage=29000JBO-29000: Unexpected exception caught: oracle.jbo.TxnValException, msg=JBO-27023: Failed to validate all rows in a transaction.SEVERITY_ERROR27023JBO-27023: Failed to validate all rows in a transaction.SEVERITY_ERROR27024JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000015918448 2015-10-02 4712-12-31 ] in RelationAssignmentDEOSEVERITY_ERRORFND:::FND_CMN_REC_COMB_VALS_EXSTJBO-FND:::FND_CMN_REC_COMB_VALS_EXST: <MESSAGE><NUMBER></NUMBER><TEXT>A record with this combination of values already exists.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>SEVERITY_RECOVERABLE_ERRORoracle.jbo.AttrSetValExceptionAssignmentId300000015918040RelationAssignmentDEOoracle.jbo.RowValExceptionRelationAssignmentDEO

The issue can be reproduced at will with the following steps:
1. Click on `Create work relationship¿ to start with the rehire process
2.Start of the rehire train, enter necessary information in every page and  navigate to the review page
3.Transaction gets approved but doesn't commit to database, Fails with error


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.