Language in Oracle Reports

Problem

If reports is not set up properly on the server, then no matter whether you concurrent program and EBS session are not in English, your report will come out in English.

Example:select to_char(sysdate, 'DD, Month YYYY') "Date" from dual;

Solution

Put this code in the beforereport trigger.

function BeforeReport return boolean is
v_language varchar2(50);
begin
  --------------------------------  
-- FND Userexit Initialization --
---------------------------------
BEGIN
  SRW.user_exit('FND SRWINIT');
  
  select nls_language
  into v_language
  from fnd_concurrent_requests
  where request_id = :P_CONC_REQUEST_ID;
  
  
  SRW.DO_SQL ('alter session set nls_language='||v_language);

....