gravatar

LOV and view accessor for shared am

In 11.1.1.2, there seems to be a bug in ADFbc. If you have a LOV based on a view accessor of a shared AM view object and if you apply a view criteria on top of it, initially the view critieria is applied but one you change the value of the LOV no view criteria is applied and you will see all the values from the LOV vo.

The workaround to this problem is to make sure of the following.
  1. In the entity object which has to view accessor, set the "Row Level Bind Values" to false.
  2. Set the "Shared Instance" property of the view accessor in the EO to "true".

To know more about the "SharedInstance" property look at the following.

http://forums.oracle.com/forums/thread.jspa?threadID=2162952