21077927: VLF HDL Worker Terminate Work Relationship Fails If MCPD Change Exists On Termdate+1 (Doc ID 2055259.1)

Last updated on APRIL 04, 2016

Applies to:

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

Symptoms

On : 11.1.8.0.0 version, Data Load

When attempting to perform a mass global transfer of 11k workers from one legal employer to another using HDL Worker.dat to terminate the old work relationship before creating the new work relationship, the following error occur.

When there are MCPD on the day after the termination date and there is a subsequent future dated change.

This is actually a common scenario for UBS so its a big blocker for the project.

Attaching example dat, stack trace and assignment data.
the following error occurs.

ERROR
-----------------------
JBO-25030: Detail entity EmployeeAssignmentDEO with row key null cannot find or invalidate its owning entity


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use HDL to load the data

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