BI Publisher (MOSC)

MOSC Banner

Split output between emailing or printing when bursting

We upgraded from 11i to R12. We have a bursting file for AR Invoices that will either email the invoice or print it based upon a value in the field called CF_EMAIL.

In R12 we are getting the invoices are getting emailed but for customers with no email address they are not printing.

The filters are:

For emails -  filter="/TLWRAXINPO/LIST_G_ORDER_BY/G_ORDER_BY/LIST_G_INVOICE/G_INVOICE[CF_EMAIL!='']">

  For printing -          filter="/TLWRAXINPO/LIST_G_ORDER_BY/G_ORDER_BY/LIST_G_INVOICE/G_INVOICE[CF_EMAIL!='']">

The bursting file coding is:

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