How to Use Forms Personalization to Restrict Record selection
Hi,
I would like to know if it is possible to execute a piece of sql through forms personalization in E-Business Suite (EBS) that would restrict the types of records returned to the user:
e.g.
if EBS responsibility is 'Asia' then
only show ex-employees if their record meets some additional criteria e.g. payroll = 'Asia' and location = 'China'
else
don't show them
Don't laugh but we are still on 11.5.5 on Windows with no intention of upgrading, so any solution would need to take this into account.
Thanks,
Greg
I would like to know if it is possible to execute a piece of sql through forms personalization in E-Business Suite (EBS) that would restrict the types of records returned to the user:
e.g.
if EBS responsibility is 'Asia' then
only show ex-employees if their record meets some additional criteria e.g. payroll = 'Asia' and location = 'China'
else
don't show them
Don't laugh but we are still on 11.5.5 on Windows with no intention of upgrading, so any solution would need to take this into account.
Thanks,
Greg
0