How to provide the correct Return Value from the List of Value query in the BIP Data Model — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to provide the correct Return Value from the List of Value query in the BIP Data Model

edited Jun 23, 2025 6:47PM in Reporting and Analytics for HCM 11 comments

Summary:

I have this BIP Data model which extracts the pending approval of a certain user. This used to work before but now I am getting this error "Invalid parameters requested." Below is the LOV SQL query:

select distinct dn.display_name,pu.username
from
per_users pu,
per_person_names_f dn
where
pu.person_id=dn.person_id
order by dn.display_name

The expected return value is pu.username.

Here is the BIP data model:

select
distinct title,
to_date(to_char(trunc(assigneddate,'mi'),'YYYY-MM-DD hh24:mi'),'YYYY-MM-DD hh24:mi') assigned,
fromuser,fromuserdisplayname,
processname,
(select distinct dn.display_name

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!