DevOps, CI/CD and Automation

Hi all,

I'm using Oracle Report Builder 6i.

I have a report with a data definition and 2 RTFs - one is with language: English and the other one: French.

I want to specified which template to add in the Before Report Trigger of the Report/It is an Oracle Standard Report - RDF file/.

I tried to add a logic inside to pick the French RTF but it still add the default template/English/.

function BeforeReport return boolean is


result boolean;


begin



   -- Call the function
  result := fnd_request.add_layout(template_appl_name => 'Receivables',
                                   template_code => 'XXNCP_RESPONSE_FILE_RESULT',
                                   template_language => 'fr',
                                   template_territory => 'FR',
                                   output_format => 'PDF');



  -- populate global temp table with file data
  apps.xxncp_ar_inv_extract.fill_file_information(:p_dir_name,:p_file_name);
  


  commit;
  return(result);
  --return (TRUE);
end;

If I manually choose the French Language - the report works fine - picks up the French template.

Any ideas? Maybe calling the API is not right?

Thanks in advance,

A.Stoyanov.