tag:blogger.com,1999:blog-4761848106405556349.post3857185530448920468..comments2023-11-20T04:28:34.754-06:00Comments on Oracle Apps: FND_PROFILE.save ExampleSanjai Misrahttp://www.blogger.com/profile/04189052945617903398noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4761848106405556349.post-21660652674178544482022-02-24T23:19:55.020-06:002022-02-24T23:19:55.020-06:00Thanks. Great. That's what I was looking for.....Thanks. Great. That's what I was looking for...using this am able to update the profile option at USER level for a user, for this profile.<br /><br />SQL> @app_profile_options_like2.sql<br /><br />selects from fnd_profile_options_tl<br /><br />enter profile option like :- Utilities:Diagnostics<br /><br />PROFILE_OPTION_NAME USER_PROFILE_OPTION_NAME<br />------------------------------ --------------------------------------------------<br />DIAGNOSTICS Utilities:Diagnostics<br /><br />We are on 12.1.3 EBSSatwinderhttps://www.blogger.com/profile/15547437090713707493noreply@blogger.comtag:blogger.com,1999:blog-4761848106405556349.post-78312002388496188322010-01-20T23:13:04.305-06:002010-01-20T23:13:04.305-06:00i used your script and it worked for me. i have Or...i used your script and it worked for me. i have Oracle Apps ver 11.5.9.Sanjai Misrahttps://www.blogger.com/profile/04189052945617903398noreply@blogger.comtag:blogger.com,1999:blog-4761848106405556349.post-68641146791166990342010-01-20T20:16:26.465-06:002010-01-20T20:16:26.465-06:00Hi,
I have followed your blog to update profile o...Hi,<br /><br />I have followed your blog to update profile options. It worked fine for updating at site level.<br /><br />Need some help to update at responsibility level.<br /><br />"set value of profile option 'ICX: Forms Launcher' at Responsibility level for Responsibility 'Workflow Administrator Web (New)' to NULL"<br /><br />I have modified ur procedure as below...<br /><br />SET SERVEROUTPUT ON SIZE 1000000<br />DECLARE<br /> l_resp_id NUMBER;<br /> l_resp_app_id NUMBER;<br /> l_success BOOLEAN;<br />BEGIN<br /><br /><br /><br /> --<br /> -- This will set value of profile option 'ICX: Forms Launcher' at Responsibility level for Responsibility 'Workflow Administrator Web (New)' to NULL<br /> DBMS_OUTPUT.put_line('---');<br /> DBMS_OUTPUT.put_line('Updating value of profile option "ICX: Forms Launcher" at Responsibility level for Responsibility "Workflow Administrator Web (New)" to NULL');<br /> DBMS_OUTPUT.put_line('---');<br /> --<br /> SELECT responsibility_id<br /> , application_id<br /> INTO l_resp_id<br /> , l_resp_app_id<br /> FROM fnd_responsibility<br /> WHERE responsibility_key = 'FNDWF_ADMIN_WEB_NEW'<br /> ;<br /> l_success := FND_PROFILE.save<br /> ( x_name => 'ICX_FORMS_LAUNCHER'<br /> , x_value => NULL<br /> , x_level_name => 'RESP'<br /> , x_level_value => l_resp_id -- it is responsibility id<br /> , x_level_value_app_id => l_resp_app_id<br /> ) ;<br /> IF l_success<br /> THEN<br /> DBMS_OUTPUT.put_line('---');<br /> DBMS_OUTPUT.put_line('Profile Updated successfully at Responsibility Level');<br /> DBMS_OUTPUT.put_line('---');<br /> ELSE<br /> DBMS_OUTPUT.put_line('---');<br /> DBMS_OUTPUT.put_line('Profile Update Failed at Responsibility Level. Error:'||sqlerrm);<br /> DBMS_OUTPUT.put_line('---');<br /> END IF;<br /> --<br /><br /><br /><br /> --<br /> -- Commit is needed because this function will not commit<br /> --<br /> Commit;<br />END;<br />/<br /><br /><br />The PL/SQL is getting executed successfully, but the value for responsibility "Workflow Administrator Web (New)" has not changed to NULL.<br /><br />Plz suggest me in this regard<br /><br /><br />Thanks,<br />PaulPaulhttps://www.blogger.com/profile/06139688468807866289noreply@blogger.com