getting error while printing user name [message #502428] |
Wed, 06 April 2011 04:52 |
rahul_dorlikar
Messages: 26 Registered: June 2010 Location: PUNE
|
Junior Member |
|
|
following is my code written in formula column
function CF_1FORMULA0006 return Char is
v_user_id number;
u_name varchar2(100);
begin
fnd_profile.get('user_id',v_user_id);
select user_name into u_name from fnd_user
where user_id =v_user_id;
return u_name;
end;
getting no data found error ,please tell me where i am wrong
|
|
|
|
Re: getting error while printing user name [message #502468 is a reply to message #502433] |
Wed, 06 April 2011 09:25 |
|
brentlowe
Messages: 1 Registered: April 2011 Location: Richmond, VA
|
Junior Member |
|
|
Are you certain that your call to fnd_profile is returning a value? In order to use fnd_profile, make sure you've called the user exits: FND SRWINIT and FND SRWEXIT. See the Oracle EBS Developer's Guide chapter "Coding Oracle Reports Concurrent Programs" for more detail.
|
|
|