getting error while printing user name [message #502428] |
Wed, 06 April 2011 04:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/e101ab19db9861236d02fc6daff8ced4?s=64&d=mm&r=g) |
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.
|
|
|