Unable To Terminate PWK Work Relationship

(Doc ID 2390967.1)

Last updated on APRIL 25, 2018

Applies to:

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


On : version, Global Human Resources

When attempting to terminating the PWK record ,encountered a notification error after the process,
the following error occurs.

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[....] in PersonEOSEVERITY_ERROR27024JBO-27024:
Failed to validate a row with key oracle.jbo.Key[......] in PersonTypeUsageDEOSEVERITY_ERROR27127JBO-27127: The effective date operation for Entity PersonTypeUsageDEO will introduce gaps or overlaps. key=oracle.jbo.Key[.....]SEVERITY_ERRORoracle.jbo.JboExceptionoracle.jbo.RowValExceptionPersonTypeUsageDEOoracle.jbo.RowValExceptionPersonEOoracle.jbo.TxnValExceptionoracle.jbo.JboException}
cause: {null}

The issue can be reproduced at will with the following steps:
1. Terminate the PWK worker
2. Try to Approve the transaction

The issue has the following business impact:
Due to this issue, users cannot Terminate the PWK worker




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