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:
where pay.business_group_id =
and fnd.session_id = userenv('sessionid')
and fnd.effective_date between pay.effective_start_date
order by pay.payroll_name
Thanks its solved .
Solution is adding Navigator: Disable Multiform. function to custom menu.
This is an AOL function that should be included on all menus (custom or standard) to allow session_id to be populated.