Error ORA-01403: no data found when Updating Organization Manager and FRM-40735: ON-INSERT trigger raised unhandled exception ORA-06502 when Updaiting BG Recrutitment Details (Doc ID 2434647.1)

Last updated on JANUARY 16, 2023

Applies to:

Symptoms

When attempting to  to Update Organization Manager the following error occurs.

STEPS
-----------------------

The issue can be reproduced at will with the following steps:
1. Go to Saudi HRMS Manager Responsibility
2. Navigate to  Work structure -> Organization -> Organization Manager
3. Update Organization Manager Relationship
4. Notice Error

OR

When attempting to update the Recruitment details at Business Group (BG) level, the following error occurs:

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to HRMS Manager responsibility.
2. Navigate to Work Structures > Organization > Select the BG > Others > Recruitment > Click on the blank field.
3. Fill the information in the Recruitment form and click OK > OK > Yes.
4. Get error.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.