If you need to ensure that your view accessor always queries the latest data from the lookup table, you can set the Auto Refresh property on the destination view object. This property allows the view object instance to refresh itself after a change in the database. The typical use case is when you define a view accessor for the destination view object.
For example, assume that an LOV displays a list of zip codes that is managed in read-only fashion by a database administrator. After the administrator adds a new zip code as a row to the database, the shared application module detects a time when there are no outstanding requests and determines that a pending notification exists for the view instance that access the list of zip codes; at that point, the view object refreshes the data and all future requests will see the new zip code.
To enable auto-refresh for a view instance of a shared application module:
#In the Application Navigator, double-click the view object that you want to receive database change notifications.
#In the overview editor, click the General navigation tab.
#In the Property Inspector expand the Tuning section, and select True for the Auto Refresh property.
Source: http://docs.oracle.com/cd/E16162_01/web.1112/e16182/bclookups.htm#CIHCHGIA
For example, assume that an LOV displays a list of zip codes that is managed in read-only fashion by a database administrator. After the administrator adds a new zip code as a row to the database, the shared application module detects a time when there are no outstanding requests and determines that a pending notification exists for the view instance that access the list of zip codes; at that point, the view object refreshes the data and all future requests will see the new zip code.
To enable auto-refresh for a view instance of a shared application module:
#In the Application Navigator, double-click the view object that you want to receive database change notifications.
#In the overview editor, click the General navigation tab.
#In the Property Inspector expand the Tuning section, and select True for the Auto Refresh property.
Source: http://docs.oracle.com/cd/E16162_01/web.1112/e16182/bclookups.htm#CIHCHGIA
