In oracle Application 11i sometime we need to Set multi_org at Report level
Possible Solution:
declare user parameter in Report Builder
P_CONC_REQUEST_ID
/*This is one of
the bind variable when ever we submit a request in SRS window that request ID
will be passed to this bind variable, based on this request id we can execute
concurrent request process. Without this find variable we can’t use SER_EXIT Procedure
after that we can apply the triggers to the report */
Before Report Trigger
function BeforeReport return boolean is
begin
SRW.USER_EXIT('FND SRWINIT');
/* FND SRWINIT will initialize user profile values according to that profile values data will be retrieved from database */
return (TRUE);
end;
After report Trigger
function AfterReport return boolean is
begin
SRW.USER_EXIT('FND SRWEXIT'); /* FND SRWEXIT freeze the memory which is occupied by user profile values*/
return (TRUE);
end;
Report changes for Special characters errors as "Invalid Character"
Possible Solution:
open the rdf in report builder and go to property palette of report ,
In xml settings property you will find this prolog value setting
Change into
<?xml version="1.0" encoding="iso-8859-1"?>
#iso-8859-1 is normally used for Western European and parse the special characters like (¿ * @ ? % #)
No comments:
Post a Comment