This discussion is archived
2 Replies Latest reply: Oct 11, 2011 3:04 AM by igwe RSS

Value set not working in responsibility

igwe Newbie
Currently Being Moderated
Hello everyone,
I created a custom responsibility and added a custom concurrent program to it (specifically the payroll run concurrent program). Now this concurrent program has a value set attached to it (PY_SRS_PAYROLL_GB) to select the payroll name. My custom concurrent program works great when attached to the Global Super HRMS Manager responsibility, but when attached to my custom responsibility, the value set say list of values contains no entries.

This is the body of the value set:

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
and popmf.ORG_PAYMENT_METHOD_ID =
Pay.DEFAULT_PAYMENT_METHOD_ID
and popmf.CURRENCY_CODE = 'GBP'
order by pay.payroll_name

Any ideas? Could I have gone wrong somewhere in my responsibility definition? I set the data group to Standard for the Human Resources application. This matches the Global Super HRMS Manager responsibility.

Thank you

Legend

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