My Oracle Support Banner

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 and later
Information in this document applies to any platform.


ORA-01427 error appears while running custom BIP report with parameter.

Parameter name: pPersonId ORA-01427:

Parameter Query :


select distinct ppn.full_name, ppn.person_id
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


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

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