Thursday 30 August 2012

Set Multi_Org at Report level & Parse Special Characters like (¿ * @ ? % # )


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: