My Oracle Support Banner

Document Of Record For Ex-Employee Fails With Ora-01403: No Data Found (Doc ID 1356571.1)

Last updated on FEBRUARY 15, 2019

Applies to:

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


Problem Statement:

When attempting to edit the document of record for the ex-employee, following error fire.

Exception Details. oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(
at oracle.apps.per.dor.webui.DocsOfRecordForPersonCO.processFormRequest(

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

1. Create document of record for the employee.
2. Terminate the employee.
3. Date track to the time the person is ex-employee.
4. Query the ex-employee and open the document of record.
5. Click on the update pencil and error fire.





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.