Oracle report 6I/RDF uses global variable fnd_global, fnd_frofile

Note: This article is original, as a learning exchange use, reproduced please indicate the author and source, the author reserves the right to pursue legal responsibility. Lumen Su lzsu1989#gmail.com (#[email protected]) www.cnblogs.com/lzsu1989 ------------------------------------------------------------------------------------------------------When developing Oracle report 6i, Fnd_global or fnd_profile are often used to get the current environment variables, such as the current User: Fnd_global.user_id,fnd_global.user_ Name Current concurrent application: fnd_global.prog_appl_id current concurrent Program: fnd_global.conc_program_id current concurrent Request: Fnd_global.conc_request_ ID gets the configuration file: Fnd_profile. VALUE ()  These variables can be used directly in the Plsql SRS, and in Oracle Report 6i, special processing is required. a solution to the problemOracle report 6i uses Fnd_global or Fnd_profile global variables Two problem description e.g.In Datamodel, there is a formula column, the formula column of the handler function, directly returned FND_GLOBAL.CONC_PROGRAM_ID Result: Returns-1, indicating no access to three-way solutionUse Srw.user_exit (' FND srwinit '); 1. Initializes the SRW within the Before_report trigger. User_exit (' FND srwinit '); 2. Gets the global parameter 3. Call Srw.user_exit (' FND srwinit ') again within the After_report trigger; Example code 1. Set user parameters (function is globally available within RDF), p_conc_program_id, type number, Width 152. modifying Before_report triggers

1 functionBeforereportreturnBoolean is2 begin3     4SRW. User_exit ('FND Srwinit');5Srw.message ( -,'Concurrent Request Id:'||:P _conc_request_id);6Srw.message ( -,'Concurrent program Id:'||Fnd_global. CONC_PROGRAM_ID);7Srw.message ( -,'Concurrent program APP Id:'||Fnd_global. PROG_APPL_ID);8:P _conc_program_id:=Fnd_global. conc_program_id;9:P _prog_appl_id:=Fnd_global. prog_appl_id;Ten    One   return(TRUE); A End;

3. Modify the After_report Trigger

function return  is begin       SRW. User_exit ('FND srwexit');    return (TRUE); End;

4. Modifying formula column functions

function return  Number  is begin  RETURN p_conc_program_id; End;

Note: This article is original, as a learning exchange use, reproduced please indicate the author and source, the author reserves the right to pursue legal responsibility. Lumen Su lzsu1989#gmail.com (#[email protected]) www.cnblogs.com/lzsu1989 ------------------------------------------------------------------------------------------------------

Oracle report 6I/RDF uses global variable fnd_global, fnd_frofile