Hi,
I have created a View object with a simple query like shown below
select .....
from fnd_users
where user_id = fnd_global.user_id
This VO is attached to a messagechoice field in OAF page, so if a user login and opens this page it will show only the data pertaining to this user only.
This is working fine when i login for the first time with user credentials it is showing the right data for this user, but when i logout and login with a different user then i am still seeing the data which belongs to the first user.
One work around is if i clear the cache in the oracle applications then i am getting the right data but this should be done for every user change which is not feasible.
I have worked on many solutions such as vo.clearcache(), vo.reset(), OAWebbean(messagechoice).cacheenabled(false) all these approach's did not work. I have placed all these in the processrequest of the controller.
Can anyone please help me out with this.