BI Publisher (MOSC)

MOSC Banner

BI publisher Bursting FTP/SFTP

edited Feb 17, 2016 4:11AM in BI Publisher (MOSC) 2 commentsAnswered

Hello to All,

I've a problem using the FTP bursting to create a spool of file (one file for each country in my case) into a directory.

I'm usign the code below to use the burst but I get a generic error.

select distinct

   COUNTRY_CD as "KEY",

'Graph_1' TEMPLATE,

'RTF' TEMPLATE_FORMAT,

'en-US' LOCALE,

'PDF' OUTPUT_FORMAT,

'SFTP' DEL_CHANNEL,

'wiki.ifad.org' PARAMETER1,

'country-briefs' AS PARAMETER2,

'zfRLOO2IKsi7OmMz' AS PARAMETER3,

'/upload' as PARAMETER4,

COUNTRY_CD||'.' AS PARAMETER5,

'true' AS PARAMETER6

FROM

DWH_PS_FIN.CP_CONTRIBUTIONS_SUMMARY

where COUNTRY_CD='AFG'

Anybody has a suggestion to underline the mistake in the query?

Tagged:

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