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 APRIL 02, 2021

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.19.01.0 and later
Information 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


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