Jdeveloper version 18.104.22.168.0
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.
How to refresh the LOV immediately after Commit?
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).