3 Replies Latest reply on Apr 29, 2013 10:51 AM by 1001735

    LOV with view criteria not getting refreshed.

      Jdeveloper version

      I have created a LOV (self-join) with view criteria based on static value.

      CustomerMaster table
      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?