EBS Customizations (MOSC)

MOSC Banner

How to Use Forms Personalization to Restrict Record selection

edited Jun 4, 2012 4:20AM in EBS Customizations (MOSC) 3 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center