3 Replies Latest reply: Apr 29, 2013 5:51 AM by 1001735 RSS

    LOV with view criteria not getting refreshed.

    1001735
      Jdeveloper version 11.1.1.6.0

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

      Eg.
      CustomerMaster table
      Fields
      --------
      CustomerCode
      CustomerName
      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?