Witam,<\/p>\n
\u017br\u00f3d\u0142o 943710.1 http:\/\/appsdbastuff.blogspot.com\/2012\/10\/how-to-change-profile-option-value.html
\n
\nPlease use the API: FND_PROFILE
\nThe package FND_PROFILE can be found in file AFPFPROS.pls<\/p>\n
FND_PROFILE.SAVE – sets the value of a profile option permanently to the database,
\nat any level. This routine can be used at runtime or during patching.
\nThis routine will not actually commit the changes; the caller must commit.
\nThe levels are: 'SITE’, 'APPL’, 'RESP’, or 'USER’.<\/p>\n
Examples of use:
\nFND_PROFILE.SAVE(’P_NAME’, 'P_VAL’, 'SITE’);
\nFND_PROFILE.SAVE(’P_NAME’, 'P_VAL’, 'APPL’, 321532);
\nFND_PROFILE.SAVE(’P_NAME’, 'P_VAL’, 'RESP’, 321532, 345234);
\nFND_PROFILE.SAVE(’P_NAME’, 'P_VAL’, 'USER’, 123321);<\/p>\n
returns: TRUE if successful, FALSE if failure.<\/p>\n
To update a Profile Option value at Site level, you need to run the SQL Script below:
\nDeclare
\nvalue Boolean;
\nBegin
\nvalue := fnd_profile.save(’APPS_DATABASE_ID’,”,’SITE’);
\nEnd;<\/p>\n
Example:
\n===========
\nSample Code
\n===========
\nDECLARE
\nstat boolean;
\nBEGIN
\ndbms_output.disable;
\ndbms_output.enable(100000);
\nstat := FND_PROFILE.SAVE(’GUEST_USER_PWD’, 'GUEST\/ORACLE’, 'SITE’);
\nIF stat THEN
\n dbms_output.put_line( 'Stat = TRUE – profile updated’ );
\nELSE
\n dbms_output.put_line( 'Stat = FALSE – profile NOT updated’ );
\nEND IF;
\ncommit;
\nEND;
\n===============
\nEnd of Sample Code
\n===============<\/p>\n
Description of the FND_PROFILE.SAVE function parameters:
\nFunction SAVE(
\nX_NAME in varchar2, \/* Profile name you are setting *\/
\nX_VALUE in varchar2, \/* Profile value you are setting *\/
\nX_LEVEL_NAME in varchar2, \/* Level that you’re setting at:
\n 'SITE’,’APPL’,’RESP’,’USER’, etc. *\/
\nX_LEVEL_VALUE in varchar2 default NULL,
\n \/* Level value that you are setting at,
\n e.g. user id for 'USER’ level.
\n X_LEVEL_VALUE is not used at site level. *\/
\nX_LEVEL_VALUE_APP_ID in varchar2 default NULL,
\n \/* Used for 'RESP’ and 'SERVRESP’ level;
\n Resp Application_Id. *\/
\nX_LEVEL_VALUE2 in varchar2 default NULL
\n \/* 2nd Level value that you are setting at.
\n This is for the 'SERVRESP’ hierarchy. *\/
\n) return boolean;<\/p>\n
Luko<\/p>\n","protected":false},"excerpt":{"rendered":"
Witam, \u017br\u00f3d\u0142o 943710.1 http:\/\/appsdbastuff.blogspot.com\/2012\/10\/how-to-change-profile-option-value.html<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[203],"tags":[204],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1057"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1057"}],"version-history":[{"count":2,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1057\/revisions"}],"predecessor-version":[{"id":1059,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1057\/revisions\/1059"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}