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!

How to avoid Duplicate values in Oracle forms

Discussion in 'Oracle Forms and Reports' started by gurujothi, Oct 9, 2012.

  1. gurujothi

    gurujothi Active Member

    Likes Received:
    Trophy Points:
    Hello Everyone,

    I am new to Oracle forms, working on Oracle Applications : 12.1.2,
    Here I have a form Receiving Transactions,
    in that I have Lot_Number and quantity columns.

    The purchased items need to be stored in Lot number.
    If 100 quantities purchased then 100 quantities can be stored in single lot number

    Lot_Number Qty
    001 100

    or 100 quantities can be stored in different lot numbers.
    Lot_Number Qty
    001 50
    002 50(The qty may differ)

    but not like the following,
    Lot_Number Qty
    001 50
    001 50.

    For second line,If they selected same lot number as First lot number,
    The error message has to be shown as "Lot number duplicated,Select Different Lot number or update the full qty in original line".

    Can anyone help me to solve this.

    Thank you.