Fusion : Issue While Querying Per_person_secured_list_v And PER_ASSIGNMENT_SECURED_LIS
(Doc ID 2547224.1)
Last updated on JUNE 28, 2022
Applies to:
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.19.01.0 and laterInformation in this document applies to any platform.
Symptoms
ORA-01427 error appears while running custom BIP report with parameter.
Parameter name: pPersonId oracle.xdo.servlet.data.DataException: ORA-01427:
Parameter Query :
select distinct ppn.full_name, ppn.person_id
from
per_person_names_f ppn,
per_person_secured_list_v pps
where 1 = 1
--AND ppn.person_id = M.person_id
--AND PPS.assignment_status_type <> 'INACTIVE'
--and ppn.person_id = ppn.person_id
and ppn.person_id = pps.person_id
and ppn.name_type = 'GLOBAL'
and trunc(sysdate) between ppn.effective_start_date and ppn.effective_end_date
and trunc(sysdate) between pps.effective_start_date and pps.effective_end_date
order by full_name
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 |
References |