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!

Form Personalization- Required when in 'New' mode, not required when in update mode

Discussion in 'Oracle Apps Technical' started by kminf, Dec 5, 2014.

  1. kminf

    kminf Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    I've a requirement where I need to make the field- RET_TYPE_DISP 'REQUIRED' when a new record is created. But if we query for any previous records, in update/edit mode field- RET_TYPE_DISP should be 'NOT REQUIRED' .
    Currently I'm trying-

    Trigger Event:- WHEN-NEW-ITEM-INSTANCE
    Trigger Object:- RETIRE.RET_TYPE_DISP
    Processing Mode:- Not in Enter-Query Mode
    Action:
    Object Type:- Item
    Target Object:- RETIRE.RET_TYPE_DISP
    Property Name:- REQUIRED
    Value:- TRUE

    But this is making field REQUIRED in 'NEW' as well as 'UPDATE' mode.
    Can anyone pls. tell what steps need to be followed for not making it REQUIRED in 'UPDATE' mode?

    Thanks in advance!!
     
  2. kminf

    kminf Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Re: Form Personalization- Required when in 'New' mode, not required when in update mo

    Hey All...any help??
     
  3. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Re: Form Personalization- Required when in 'New' mode, not required when in update mo

    Hi ,

    Make the field is required if the record status is NEW or INSERT only. Put the below one in the conditions filed

    :SYSTEM.RECORD_STATUS IN ('NEW','INSERT')


    Regards
    Sambasiva Reddy.K
     
  4. kminf

    kminf Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Re: Form Personalization- Required when in 'New' mode, not required when in update mo

    Thank you very much Sambasiva!!This worked perfectly...thanks again...
     
  5. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Re: Form Personalization- Required when in 'New' mode, not required when in update mo

    you are welcome kminf...