Thursday, October 7, 2010

Print logged user name in Reports 6i in Oracle APPS

Print Logged User name in report 6i in Oracle APPS
1. Create one formula column 'CF_USER_NAME' on data model group.
2. In Pl/SQL formula write below code:
function CF_USER_NAMEFormula return Char is
v_user number := NULL;
v_user_name varchar2(50);
begin
v_user := FND_GLOBAL.user_id;

select user_name into v_user_name
from fnd_user
where user_id =v_user;

RETURN v_user_name;

end;
3. Goto REPORT TRIGGERS > BEFORE REPORT >PL/SQL Editor
Srw.User_Exit('FND SRWINIT');
4. Goto REPORT TRIGGERS > AFTER REPORT >PL/SQL Editor
Srw.User_Exit('FND SRWEXIT');

1 comment:

  1. Thank you very much.
    This was what I was looking for.
    www.ourcalicut.com

    ReplyDelete