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!

iProcurement Customization

Discussion in 'Oracle Forms and Reports' started by neelambhumij, Aug 26, 2014.

  1. neelambhumij

    neelambhumij Active Member

    Messages:
    51
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    JOHANNESBURG
    Hi

    I have a requirement to customize the Iproc homepage but unfortunately i have no experience on OAF.

    The requirement is as following:
    If going on navigation .. xx%iproc%buyer%>non-catelog request>services billed by quantities --------->we enter value for "category" by search and select... and we add it to cart.
    later when do checkout... the expenditure type in the billing section should have the selected "category" value as defaulted.

    Any help is really appreciable. :)
    For better undersatnding, please find the attachement.

    Thanks and Regards
     

    Attached Files:

  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi ,

    Check the 'por_custom_pkg' package . I think by Customizing this procedure you can add custom defaulting logic in iProcurement Page.


    Regards
    Sambasiva Reddy.K
     
    neelambhumij likes this.
  3. neelambhumij

    neelambhumij Active Member

    Messages:
    51
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    JOHANNESBURG
    Hi Sambasiva

    I am trying to default the expenditure type in iproc checkout page where charge account number always comes as default.
    My customization code in 'por_custom_pkg'.CUSTOM_DEFAULT_REQ_DIST is removing the defaulting of charge account number.
    Any sugesstion.

    customized code:--
    BEGIN

    p_category_id :=category_id;

    SELECT ( SUBSTR (MtlCategoriesKfv.CONCATENATED_SEGMENTS, 1, 1)
    || '-'
    || SUBSTR (MtlCategoriesKfv.CONCATENATED_SEGMENTS, 2))
    INTO v_exp_type
    FROM MTL_CATEGORIES_KFV MtlCategoriesKfv
    WHERE MtlCategoriesKfv.category_id = p_category_id;

    expenditure_type := v_exp_type;

    RESULT_CODE:=0;
    X_ERROR_MSG:='';

    END;


    Thanks
    Kind Regards
    Neelam