Oracle Apex Interactive Report shows ORA-01427: single-row Subquery returns more than one row
I am stuck in this error, query is working fine in sql developer or in sql workshop but i got this error in Interactive report when i just search for any record or do next for further more records. My apex version is 5.1.3
This is my query:
select ep.EMP_ID,
ep.EMP_FIRSTNAME,
ep.EMP_MIDDLENAME,
ep.EMP_LASTNAME,
ep.EMP_GENDER,
ep.EMP_MARITAL_STATUS,
ep.EMP_CNIC,
ep.EMP_DOB,
ep.EMP_FLAG,
ep.EMP_CODE,
case ep.EMP_FLAG when 'y' then 'Active' else 'Inactive' end as Status,
(select g.grade_level from grade g where g.grade_id = ep.EMP_GRADE) as Grade,
(select g2.grade_desc from grade g2 where g2.grade_id = ep.EMP_GRADE) as Designation,
(select p.position_desc from position p where p.position_id = ep.EMP_POSITION) as Position,
(select cg.cg_name from comp_group cg where cg.cg_id = ep.EMP_GROUP) as Employee_group,
(select d.dept_desc from department d where d.dept_id = ep.EMP_DEPT) as Department,
(select e.ets_name from emp_type_setup e where e.ets_id = ep.EMP_TYPE) as EMP_TYPE,
ep.EMP_FIRSTNAME || ' ' || ep.EMP_LASTNAME AS EMP_NAME,
(Select ej.JOB_JOINDATE from EMP_JOB ej where ej.EMP_ID = ep.EMP_ID) as Join_Date,
ep.EMP_RELIGION as Religion
from EMP_PERSONAL ep
where
"EMP_CODE" = :P2_EMP_CODE OR :P2_EMP_CODE IS NULL and
("EMP_DEPT" = :P2_DEPT OR :P2_DEPT IS NULL) and
("EMP_TYPE" = :P2_EMP_TYPE OR :P2_EMP_TYPE IS NULL)
and emp_flag = 'y';
Scrrenshot:
Thanks in Advance