Deleting Assignment Set Throws the Error "child rows exist" (Doc ID 2174859.1)

Last updated on AUGUST 22, 2016

Applies to:

Oracle Payroll - Version 12.1 HRMS RUP9 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

Deleting assignment set in the "Manage Assignment Set" page throws the following error.

You cannot perform a delete operation when child rows exist Cause: You are doing a delete operation where dependent child rows exist for HR_ASSIGNMENT_SETS .

 

 

Steps to Reproduce:

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

  1.  Go to the Self Service "Manage Assignment Set" page.  (Function "Manage Assignment Set" needs to be added in the menu. This function is delivered in HR_PF.B RUP9)
  2.  Search for the assignment set.
  3.  Click on the delete button.
  4.  Click OK in the warning page.
  5.  Error occurs.

 

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