My Oracle Support Banner

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.

----------------------- 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[....] 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




To view full details, 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 a vibrant support community of peers and Oracle experts.