Using a shared application module for static lookup data
Shared application modules allow you to share static read-only data models across multiple user sessions. They are the ideal place to collect all the static read-only view accessors used throughout your ADF application for validation purposes or as data sources for your list of values (LOVs). This is because a single shared application module is constructed and used throughout the ADF application for all user sessions, thus minimizing the system resources used by it. In this case, a single database connection is used. In addition, by collecting all of your static read-only view objects in a shared application module, you avoid possible duplication and redefinition of read-only view objects throughout your ADF application.
Internally, the ADF Business Components framework manages a pool of query collections for each view object as it is accessed by multiple sessions by utilizing a query collection pool, something comparable to application...