BI Publisher (MOSC)

MOSC Banner

I am trying to FTP bursting for a standard BIP report "InvoicePrintReport", but it is not working.

edited Jul 14, 2022 2:21PM in BI Publisher (MOSC) 4 commentsAnswered

In the schedule page output, i cannot see the name of the file i gave in the query also FTP bursting is not working, Also I can see the report in the output of the scheduled job. I tried email bursting and that is working fine.

Below is the code I am using:

SELECT 

   ps.customer_trx_id || '_' || ps.payment_schedule_id as "KEY",

   :TEMPLATE_NAME TEMPLATE,

   'RTF' TEMPLATE_FORMAT,

'en-US' LOCALE,

   'PDF' OUTPUT_FORMAT,

   ps.trx_number || '_' || ps.terms_sequence_number output_name,

   'FTP' DEL_CHANNEL,

   :server_name PARAMETER1,

   :username PARAMETER2,

   :password PARAMETER3,

   '/Test/FromCust/' PARAMETER4,

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