My Oracle Support Banner

Error " The Condition :ASSGT.DT_UPDATE_MODE = 'CORRECTION' " and "ORA-01427: single-row subquery returns more then one row" when Navigating Assignment Form (Doc ID 2996233.1)

Last updated on JANUARY 03, 2024

Applies to:

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

Symptoms

When attempting to navigate to assignment form for an employee,
the following error occurs.

ERROR
-----------------------
The Condition :ASSGT.DT_UPDATE_MODE = 'CORRECTION' AND
(select 1
from per_all_assignments_f
where assigment_id = :ASSGT.assignment_id
and effective_start_date = :ASSGT.effective_start_date)IS
NULL could not be evaluated because of error ORA-01427:
single-row subquery returns more then one row

STEPS
-----------------------
1. Login application with AU HRMS Manger
2. N> People > Enter and Maintain form.
3. Date track to to 01-Jul-23
4. Query for employee number : XXXXX
5. Click on Assignment button and getting above mentioned error.

Cause

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
Symptoms
Cause
Solution


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