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!

Invoice form personalization issue

Discussion in 'Oracle Forms and Reports' started by ravivakula30, Jan 22, 2016.

  1. ravivakula30

    ravivakula30 Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    I have a requirement to populate Document Category Name (Hidden Field at Invoice Header level) based on the Operating Unit value.

    The relationship b/w OU and Document Category Name is set up by using a DFF field at OU level.

    This is the personalization that have I done,

    Condition

    Trigger Event: WHEN-VALIDATE-ITEM

    Trigger Object: Null

    Condition: :INV_SUM_FOLDER.ORG_ID IS NOT NULL



    Actions

    Seq: 10

    Type: Property

    Object Type: Item

    Target Object: INV_SUM_FOLDER.DOC_CATEGORY_NAME

    Property Name: VALUE

    Value:

    =SELECT ATTRIBUTE1 FROM HR_ORGANIZATION_UNITS_V

    WHERE ORGANIZATION_ID = :INV_SUM_FOLDER.ORG_ID


    With the above setup Doc Category Name is populating whenever I choose a OU.



    But the Issue is, for Ex:

    When I choose OU: 123, Doc Category Name is populated: ABC ( from ATTRIBUTE1 = ABC)

    If I go back and change OU: 124, Doc Category Name is populated as Null ( Since ATTRIBUTE1 = NULL) which is correct. But If go to that field ( Doc Category Name) and hit TAB then old value (ABC) which is for previous OU is getting populated.



    Appreciate if anyone can help
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Which version?

    I guess you used when validate record trigger, but trigger object is mandatory.