Error When Trying To Purge Assignment: ORA-01403 : no data found

(Doc ID 1178785.1)

Last updated on OCTOBER 12, 2017

Applies to:

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



On : Version, Person / Assignment Issues

When attempting to delete an assignment for one employee, the following error occurs.

ORA-01403 : no data found
ORA-06512: at 'APPS.HRENTMNT', line 6812
ORA-06512: at 'APPS.PER_ASSIGNMENTS_F1_PKG', line 738
ORA-06512: at 'APPS.PER_ASSIGNMENTS_F1_PKG', line 2561


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

1. People -> Enter and Maintain -> assignments.
2. There are 3 assignments for this employee
3. Go to -2 assignment. Purge assignment, page disappears and -3 assignment appears.
4. Click save
5. Receive the error message



No known changes.



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