Search This Blog

Thursday, July 2, 2009

Set Profile Option Value using PL/SQL

On request here is how to set the profile option value using PL/SQL

Function FND_PROFILE.SAVE can be used to set the value of any profile option at any level i.e. Site, Application, Responsibility, User etc.

Below is a sample code of how to use this function


DECLARE
a BOOLEAN;
BEGIN
a := fnd_profile.SAVE ('CONC_REPORT_ACCESS_LEVEL'
, 'R'
, 'USER'
, '22746'
, NULL
, NULL
);

IF a
THEN
DBMS_OUTPUT.put_line ('Success');
COMMIT;
ELSE
DBMS_OUTPUT.put_line ('Error');
END IF;
END;

8 Comments:

Vijayakumar said...

Dear Suresh,

Excellent writeup,Thanks for dedicating this article for the requirement mentioned. Thanks in anticipation.

Thanks,

Kasi,Vijayakumar

nature lover said...

HI Suresh,
your apps blog is super . Ca

vvvv said...

Dear Suresh,

I came across one interview question like,

How can u compile the flexfields through command prompt?

plz help me on this.

Thanks and Regards,
Venkat

Suresh Vaishya said...

I think one option of doing this could be by using FNDLOAD. Check my post on FNDLOAD to see the command to upload flexfield.

vvvv said...

Dear Suresh,

Thanks for ur prompt reply...

Thanks & Regards,
Venkat

Ram said...

hi Suresh,
i am Ramesh,Bangalore,India.
how to get the IP Address of Client System in PL/SQL Oracle...
can You get Solution..... Urgent.........

Suresh Vaishya said...

Check my post
http://sureshvaishya.blogspot.com/2009/07/retrieve-ip-address-and-host-name.html

Thanks,
Suresh

Ram said...

hi suresh,
in forms 6i,
how to add values from user "Table" into "List of Values"(LOV").... all Examples for LOV in forms.....add,delete,edit.....

Copyright (c) All rights reserved. Presented by Suresh Vaishya