BI Publisher (MOSC)

MOSC Banner

Problem with Bi Publisher Bursting

edited Jun 27, 2017 5:00AM in BI Publisher (MOSC) 2 commentsAnswered

https://ecuo.bi.us2.oraclecloud.com/xmlpserver/help/en/htmfiles/bipoh/add_burst_def.htm#BABJGEJA) but when i try to send an email with the report result on TXT format the job send me the error:

"Output failed.

[INSTANCE_ID=cffar41070i04.usdc2.oraclecloud.com.1495272764164] [SUBJOB_ID=11143] Invalid format requested: text"

I use the next query on the bursting:

SELECT 1 as "KEY",

  'AUX_CUENTAS2_REP' AS "TEMPLATE",

  'en-US' AS "LOCALE",

  'txt' AS "OUTPUT_FORMAT,

  'file' AS "OUTPUT_NAME",

  'EMAIL' AS "DEL_CHANNEL",

  'mail1@oracle.mx' AS "PARAMETER1",

  NULL AS "PARAMETER2",

  'mail2@oracle.mx' AS "PARAMETER3",

  'xxxxxxx' AS "PARAMETER4",

  'xxxxxxx' AS "PARAMETER5",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center