eTEXT BIP Bursting

Content

Hi All,

 

I developed SQL Query and eText template as per the requirement. Now I am trying to send eText output to mail through Bursting. When I submit the report and I got the attached error. Without bursting report ran successfully.

 

Kindly provide inputs syntax used for eTEXT template.

 

SELECT DISTINCT  '123' AS "KEY",

'Bursting Annual'     AS TEMPLATE,

  'en-US'                           AS LOCALE,

  'ETEXT'                             AS OUTPUT_FORMAT,

  'EMAIL' DEL_CHANNEL,

   'Consolidated'       OUTPUT_NAME,

  'xx@gmail.com' PARAMETER1,

  'bipublisher-report@oracle.com' PARAMETER3,

  'Annul Report Consolidated' PARAMETER4,

  'Dear '||'

 

 

'|| 'Please find the attached Annual Documents.'

||'

 

 

'||'Regards,

HR' PARAMETER5, 

  'false' PARAMETER6