DCP

Wednesday 4 March 2015

Calling BI Publisher Template Dynamically in EBS Report

Calling BI Publisher Template Dynamically.
--------------------------------------------------------
In After Parameter Form Trigger code the logic to update the Layout picked by the concurrent program.

   if nvl(:P_FORMAT, 'PDF') = 'EXCEL' then

      UPDATE fnd_conc_pp_actions t
         SET t.argument2 = 'DSDPO_BDOC_ANALYSIS_XLS', t.argument5 = 'EXCEL'
       where t.concurrent_request_id =  FND_GLOBAL.CONC_REQUEST_ID
         and t.action_type = 6;
    else
      UPDATE fnd_conc_pp_actions t
         SET t.argument2 = 'DSDPO_BDOC_ANALYSIS', t.argument5 = 'PDF'
       where t.concurrent_request_id =  FND_GLOBAL.CONC_REQUEST_ID
         and t.action_type = 6;
   
    end if;