2 Replies Latest reply: Dec 16, 2010 2:15 AM by user45338 RSS

    Payroll: Value Set issue

      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:

      apps.PAY_PAYROLLS_F PAY,
      apps.fnd_sessions fnd
      where pay.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