I have created a LOV (self-join) with view criteria based on static value.
IsHeadOffice (Y or N)
HeadOfficeCode (LOV to list all customer codes with "IsHeadOffice=Y")
The problem is, LOV is not getting refreshed immediately. For eg., if I create a value, say ABCHO, & commit the transaction (checked in database; row is inserted). When I create a new record, the value "ABCHO" is not getting displayed in the LOV. If I go back to the previous page & come to this page again, then 'ABCHO' is displayed in the LOV.
Go to view criteria and edit it, on top right corner you will see the Mode= Database/Memory/Both, can you see if it selected as BOTH (if it is Database, then your problem is quite expected as it will not read the values when in memory).