Application

 

3 comments:

  1. how to update profile option in R12 using api...
    ==
    Q: I want to update the profile option at server level, Ex. Profile option is "Node Trust Level" , Server : Hostname

    Ans:

    DECLARE
    VALUE BOOLEAN;
    l_node_id number;
    BEGIN
    select node_id into l_node_id from fnd_nodes where NODE_NAME = 'hostname';
    VALUE := fnd_profile.save ('NODE_TRUST_LEVEL', 3, 'SERVER',l_node_id,null,null);
    END;
    /

    ===

    Q: how to change the color using api.
    Ans:
    ==
    Declare
    value Boolean;
    Begin
    value := fnd_profile.save('FND_COLOR_SCHEME','red','SITE');
    End;
    /
    ===

    Thanks,
    Mi2

    ReplyDelete

Ask your Questions....