5 Replies Latest reply: Jun 5, 2012 10:47 AM by Hussein Sawwan-Oracle RSS

    form query/search issue F6 , F11 + Ctrl F11

    773692
      Dear Techies,

      I have an issue with form query/search mode in oracle applications. The Issue is i have a custom form which has headers and lines. whenever i open the form cursor is defaulting on a column called "Transaction_year" which is a mandatory column, Because of this whenever i want to search first I have to clear the record (Press F6) then press F11 and CTRl F11.

      And my client is irritated to press so many buttons. I cannot make mandatory col to optional since it is "Transaction_year" a primary key. I have to customize the form in such a way that it should allow f11 + ctrl f11 to search.

      Can somebody help me how can i achieve this. I am new to forms :(