1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Purchase Order Summary Form Personalization

Discussion in 'Oracle Forms and Reports' started by Bharat, Aug 1, 2012.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi all,

    When we enter purchase order number and line number in Purchase order summary form then it going to show only that line in Purchase order form. But here in my case its not showing that line and showing new line. So I have personalized Purchase Order Summary form by adding one global variable with assigning value as ( ${item.find.line_num.value} ) to my global variable. Now personalized purchase order form by adding condition like ( :global.xx_line_num is not null ) then action as block, po_lines, Default_where line_num = :global.xx_line_num. So its defaulting that variable as some value. Whenever I query purchase order form with any Purchase order its displaying only that number which is stored previously in that global variable.

    How can we clear that global variables?