1. Rajini
    September 13, 2011 @ 10:11 pm

    Hi, I have a requirement based on one responsibility i need to show one query in my LOV and for remaining all responsibilities i need to show other lov.

    Using form personalization only one conditon is working

    Example IF responsibility_id =’120′ my lov should be select empname, empno from emp where dept no=20

    for all other responsibiliites my lov should be select empname, empno from emp


  2. Tom
    September 16, 2011 @ 7:48 pm

    Hope you got the answer.
    You have to create two different LOV’s and call each of them based on two different conditions in the each personalization lines complementing each other.

    Example : In one condition you use responsibility_id =’120′ and define your one LOV
    and in anther line condition use responsibility_id ’120′ and define anther LOV.
    That should do.

  3. Anoo
    September 16, 2011 @ 9:24 pm


    I have a requirement on the Miscellaneous Transaction form which needs a error msg when the user not to free-key in the lot number. Also a transaction ID has to be shown soon after the validation of the record.

    I have tried to execute when-validate-trigger for both of them but found that it is being overwritten.
    I have also tried 2 actions with the same condition. But it is not working.

    Can you please help me in understanding how i can pop up an error message when the lot number is out of LOV and also how i can populate transaction_header_id for validated records. (Please let me know the triggers for each.)

  4. Kiran Reddy
    September 29, 2011 @ 12:42 pm

    Hi All,

    How to do some actions when user selects the Ordered Item from the LOV in Sales Order Form.

    I have tried with WHEN-NEW-ITEM-INSTANCE on Ordered Item field.. But the trigger is getting fired when you select it from LOV by clicking on button next to field.

    I have requirement to restrict Ordered Item LOV based on Items in Sales Agreement.

    How can this be achieved.

    Thanks in Advance.

  5. Kiran Reddy
    September 29, 2011 @ 12:43 pm

    Sorry for typo error in last reply…the trigger is NOT getting fired when you select it from LOV by clicking on button next to field.

  6. Tammye Herrin
    October 20, 2011 @ 3:47 am

    In the Projects window (PAXPREPR) form I need to keep the user from being able to change the trans date. Can you tell me how to do this. The user needs to be able to change the project status so we can not use the inquiry for this form.

  7. bhaskar
    November 18, 2011 @ 12:39 pm

    How can manage the Multiple LOV’s in dorms personalisation

  8. bhaskar
    November 18, 2011 @ 12:40 pm

    How can manage the Multiple LOV’s in forms personalisation

  9. Sri
    December 2, 2011 @ 1:36 am

    Hi All,

    I have few questions about this article…
    1. How did you get the name of the target object? In this case it is “Target Object: INV_ALL_VENDORS_NAME”. I am working with a similar situation but was not able to get the LOV name

    2. In the query used how did you get the name of view used…” FROM po_vendors_ap_v” ? I was not able to figure out how to get this view name?

    Please can you help me with this.

  10. Hilko
    December 8, 2011 @ 10:00 pm


    Is it possible to disable (insert and update not allowed) a whole block and enable one field (item). Or must I disable all the other fields except one field?

    I hope you understand me.
    It is for the HR form and we will for one responsibility, that they can only chance the hire date.

    With regards,

  11. Sri
    December 10, 2011 @ 4:38 am

    Hi All,

    I figured out how to get them… There are two ways to get … One u shld have the .fmb file for the form. U open it in forms developer and u can get the LOV, Record group and the corresponding query…

    In second way u can only get the query for the Record group… But i dont think u can get the record group name….. For this method U shld enable the trace with binds option in forms.
    Help –> Diagnostics –> Trace –> Trace with binds..
    Then query the LOV… U need… System will generate a trace file…. Open the trace file and u find the record group query in it…

  12. shan
    June 5, 2012 @ 2:08 pm

    Good but no clarity
    created a custom query in
    and how to know which view has to be used
    plz clarify it

  13. Sritapa
    October 4, 2012 @ 11:27 am

    hey thanks a lot!!!….I could do the personalization with the help of your guidance.

  14. ravendra.singh
    October 29, 2012 @ 6:24 pm

    I need to personalize APXPAWKB.fmb. In which the LOV for PAY_SUM_FOLDER.PAYMENT_DOCUMENT_NAME is returning many columns, but when I open the form through form builder the query for the LOV is returning few columns only so how to restrict the LOV by restricting conditions on 2 columns. ???

  15. sarankumar
    November 22, 2012 @ 3:54 pm

    Hi i found this to be a good and easy way to learn personalisation

  16. Nidhi
    July 11, 2014 @ 1:18 pm

    Hi I want to add one column in the LOV I repeated same steps but it is giving FRM-40350 query caused no records to be retrieved. Checked query its working fine. Any idea will be helpful.

  17. Taufique Ahmad
    July 22, 2016 @ 11:21 am

    When I apply to change the LOV with the help of above query.

    I got the error “FRM-41826: Cannot replace group;columns don’t match LOV”

Back to Top