Fusion Bursting Examples: FAX Delivery

Variation 1: Fax Sales Orders

SELECT Order_ID AS "KEY",
       'SalesOrder.rtf' TEMPLATE,
       'en-US' LOCALE,
       'PDF' OUTPUT_FORMAT,
       'Order_' || Order_ID OUTPUT_NAME,
       'FAX' DEL_CHANNEL,
       'FAX_SERVER' PARAMETER1,                        -- Fax server name
       Fax_Number PARAMETER2                             -- Fax number
FROM Orders;

Variation 2: Fax Invoices by Customer

SELECT Customer_ID AS "KEY",
       'InvoiceReport.rtf' TEMPLATE,
       'en-US' LOCALE,
       'PDF' OUTPUT_FORMAT,
       'Invoice_' || Customer_ID OUTPUT_NAME,
       'FAX' DEL_CHANNEL,
       Customer_Fax PARAMETER1,                         -- Fax server name or number depending on config
       Customer_Fax PARAMETER2                           -- Fax number
FROM Customers;