ZA - ORA-01403: NO DATA FOUND error when trying to add or update the address of an employee (Doc ID 2157467.1)

Last updated on JULY 07, 2016

Applies to:

Oracle HRMS (South African) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Address issues

When attempting to add address to any employee the following error occurs.
Error occur only in DEV environment where patch Release 12.1 Branch : 23203677:R12.PER.B was applied

ERROR
-----------------------
ORA-01403: no data found

--------------------------------------------------------------
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-01422.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (n) NWU HRMS Manager
2. People and Maintain -> Search employe
3. Click on Address -> Enter details -> Save -> error is raised

4.(n) Fast Path -> Address
5.Search employe-> Enter details -> Save -> error is raised


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