Search This Blog

Thursday, 13 March 2014

Display User Name in ERP Report



11.       Add Parameter P_CONC_REQUEST_ID in report

2     Begin
3       SRW.USER_EXIT('FND SRWINIT');
4
begin
                                select nvl(description,user_name)
                                into :P_GENERATED_BY
                                from fnd_user
                                where USER_ID = fnd_profile.value('USER_ID');
                exception
                                when no_data_found then null;
                end;
5Return (True);