This discussion is archived
2 Replies Latest reply: Dec 16, 2010 12:15 AM by user45338 RSS

Payroll: Value Set issue

user45338 Newbie
Currently Being Moderated
We have a custom report which is working fine in India HRMS manager Resp .When we create a custom resp and add that report there , value sets are showing no values found.
Has anyone faced such issue before .
Query of value set is fetching values at back end.
Query of value set is as below:

select PAY.PAYROLL_NAME,PAY.PAYROLL_ID
from
apps.PAY_PAYROLLS_F PAY,
apps.fnd_sessions fnd
where pay.business_group_id =
:$PROFILES$.PER_BUSINESS_GROUP_ID
and fnd.session_id = userenv('sessionid')
and fnd.effective_date between pay.effective_start_date
and pay.effective_end_date
order by pay.payroll_name

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points