My Oracle Support Banner

Removing Secondary Assignment Record (Doc ID 2335294.1)

Last updated on FEBRUARY 16, 2019

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP5 and later
Information in this document applies to any platform.


On :  12.1 HRMS RUP5 version Production, People Management
Removing Secondary Assignment Record  error

Secondary assignment was created by mistake for one employee using applicant hire & rehire form, customer realized it should be a replacement of primary assignment and proceeded to cancel the hire (new secondary position) , after successfully removing this secondary assignment, the applicant hire & rehire process was restarted again and this time “replace primary assignment” was selected but when trying to save, it generates error below, even after running Generic Upgrade Mechanism as suggested in some notes.

Cannot perform a delete with child rows existing in the future Cause: You are attempting to do a date effective delete where child rows will exist in the future. Action: Clear your changes and remove any future child rows.

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Applicant Hire & Rehire, choosing the option "Create Secondary Assignment".  

2. Once the record loaded into Oracle, Canceled the Hire which removes the secondary assignment.

3. Then try to enter the internal hire change with Applicant Hire & Rehire, choosing "Replace Primary Assignment".

4.  Received the error when clicking "next" to move past the Assignment screen.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.