Global HR: Transfer, Rehire, Termination Notification Failed With Errors: JBO-27023: Failed to validate all rows in a transaction (Doc ID 1637656.1)

Last updated on JULY 11, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.7.0.0 and later
Oracle Fusion Global Human Resources - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to transfer, rehire, or terminate an employee, the following notification error occurs:

ERROR
-----------------------
FYI:Failed with Errors : Transfer for ...
HRC-1035165 You must reinitiate the transaction.
Transaction Id 300,000,010,041,913
Requestor John.Doe@oracle.com
Task Id 01b331e4-d7e2-4c15-8cf7-3ea790c26a47
Task Title : Transfer for ...
Task Status APPROVE
Composite Name HcmEmploymentManageComposite
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[100000001829761 2013-03-22 2014-03-09 ] in PayrollUsageDEOSEVERITY_ERRORPAY:::PAY_REG_PAYROLL_PRIMARY_FLAG JBO-PAY:::PAY_REG_PAYROLL_PRIMARY_FLAG : <MESSAGE><NUMBER>PAY--1</NUMBER><TEXT>PAY-PAY_REG_PAYROLL_PRIMARY_FLAG </TEXT><CAUSE>The message, PAY-PAY_REG_PAYROLL_PRIMARY_FLAG , can not be accessed.</CAUSE><ACTION>Report this problem to an administrator.</ACTION><DETAILS>PAY-PAY_REG_PAYROLL_PRIMARY_FLAG </DETAILS><INCIDENT></INCIDENT></MESSAGE>SEVERITY_RECOVERABLE_ERRORoracle.jbo.RowValExceptionPayrollUsageDEOoracle.jbo.RowValExceptionPayrollUsageDEO27024JBO-27024: Failed to validate a row with key oracle.jbo.Key[100000001837138 2013-03-22 2014-03-09 ] in PayrollUsageDEOSEVERITY_ERRORPAY:::PAY_REG_PAYROLL_PRIMARY_FLAG JBO-PAY:::PAY_REG_PAYROLL_PRIMARY_FLAG : <MESSAGE><NUMBER>PAY--1</NUMBER><TEXT>PAY-PAY_REG_PAYROLL_PRIMARY_FLAG </TEXT><CAUSE>The message, PAY-PAY_REG_PAYROLL_PRIMARY_FLAG , can not be accessed.</CAUSE><ACTION>Report this problem to an administrator.</ACTION><DETAILS>PAY-PAY_REG_PAYROLL_PRIMARY_FLAG </DETAILS><INCIDENT></INCIDENT></MESSAGE>SEVERITY_RECOVERABLE_ERRORoracle.jbo.RowValExceptionPayrollUsageDEOoracle.jbo.RowValExceptionPayrollUsageDEOoracle.jbo.TxnValExceptionoracle.jbo.JboException} cause: {null}


The issue can be reproduced at will with the following steps:
1. Navigator>Person Management
2. Search and select person
3. Select the Manage Employment task
4. Click on Edit>Update
5. Enter the effective date and select Transfer
6. Change the business unit, job, location and department
7. Click Review
8. Click Okay on Roles
9. Click Submit
10. Click Continue
11. Click OK to confirm
Review the notification and note it indicates "Failed with Errors". Note the transfer is not completed either.


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