Rehires Failing With Error (Doc ID 2073790.1)

Last updated on NOVEMBER 18, 2015

Applies to:

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

Symptoms

On : 11.1.10.0.0 version, Global Human Resources

Rehires are failing with error message



ERROR
-----------------------
Error Message FAULT_NAME=ServiceException::FAULT_TEXT=com.oracle.bpel.client.BPELFault: faultName: {{http://xmlns.oracle.com/apps/hcm/employment/core/transactionApprovalService/}ServiceException} messageType: {{http://xmlns.oracle.com/adf/svc/errors/}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



STEPS
-----------------------
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 databse, Fails with error
 as seen below
4. Error message screenshot and also copy pasted the error message



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms