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');
Thank you very much.
ReplyDeleteThis was what I was looking for.
www.ourcalicut.com