Home » Developer & Programmer » Reports & Discoverer » how to get profile values to display in RDF report (oracle 11.5.10.2)
how to get profile values to display in RDF report [message #559518] Tue, 03 July 2012 14:15 Go to next message
godfather1000
Messages: 13
Registered: July 2012
Junior Member
Can some one please tell me how I can profile values to be displayed in RDF report.Here is what I have in my before report trigger

srw.USER_EXIT ('FND SRWINIT');
apps.fnd_client_info.set_org_context(FND_GLOBAL.ORG_ID);
:CP_Fnd_User :=FND_GLOBAL.USER_NAME;
:CP_CompanyName := FND_PROFILE.VALUE('xx');

When I print the value of the user name it gets printed fine.But when I print the place holder column value for the profile I get null.

Thanks in advance
Re: how to get profile values to display in RDF report [message #559521 is a reply to message #559518] Tue, 03 July 2012 15:39 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This looks like an Oracle Apps. question (and I know nothing about it).

Anyway: are you saying that :CP_FND_USER displays its value, but :CP_COMPANYNAME does not?

If yes, then you might see what the function returns using SRW.MESSAGE built-in (so maybe the placeholder column is a culprit for some reason; then you might move that code into the formula column instead and see what happens).

If not, what is "place holder column value for the profile"?
Previous Topic: Need help find report header info
Next Topic: Generate PDF - REP-0999 error!!
Goto Forum:
  


Current Time: Thu Mar 28 04:40:36 CDT 2024