How to create fixed list in ADF
1- create a read only view object based on a query example: SELECT 'Reject' DESCRIPTION ,'BCK' CODE FROM DUAL UNION ALL SELECT 'Accept' DESCRIPTION ,'GM' CODE FROM DUAL 2- in the base view object (your main view object that you want to add the fixed list) add a new Transient attribute for example "Manager_descision" 3- Create view accessor in the main view abject that referes to the readonly query VO 4- associat a LOV to your Transient attribute that is based on your view accessor Note that you must add list return value to retrun the value to the database attribute to save the returned value in the DB 5- in your page drag and drop the transient attribute from the data control to the page as selectOneChoceList 6- go to the page Bindings and select the attribute in the strucure window and right click to add attribute names and attribute values 6- save and run the page