Error When Trying To Purge Assignment: ORA-01403 : no data found (Doc ID 1178785.1)

Last updated on JANUARY 05, 2017

Applies to:

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

pyentmnt.pkb
pyentmnt.pkh
PERWSHRG.fmb


Symptoms


On : Version  11.5.10.2, 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

 

STEPS
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

 

Changes

No known changes.

 

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