Home » Developer & Programmer » Reports & Discoverer » getting error while printing user name (report 10g, EBS R12)
getting error while printing user name [message #502428] Wed, 06 April 2011 04:52 Go to next message
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

Report message to a moderator

Re: getting error while printing user name [message #502433 is a reply to message #502428] Wed, 06 April 2011 05:00 Go to previous messageGo to next message
cookiemonster
Messages: 13919
Registered: September 2008
Location: Rainy Manchester
Senior Member
The select isn't finding data obviously.
Change the function to return v_user_id and see if it's the value you think it is.

Report message to a moderator

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
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.

Report message to a moderator

Previous Topic: How to reset the Oracle report id parameter on the application server
Next Topic: Matrix Report Cell If No Data then Display 'A'
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 16:24:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.