Home Discussions Questions & Answers Outbound Interface Scheduling and File Delivery

Outbound Interface Scheduling and File Delivery

Avatar photoCustomer February 20, 2022 at 7:41 pm

I have configured a report to serve as a nightly outbound interface to a third-party system. How can I schedule this report and ensure the output file is automatically delivered to an FTP location or via email?

Viewing 6 reply threads
  • Author
    Replies
    • Support February 22, 2022 at 12:56 am  

      The easiest and most common way to schedule a Blitz Report is to run it once from the run window with all parameters set correctly, and then navigate to View > Requests to copy that submitted concurrent request . You then update the schedule frequency and configure the Oracle standard delivery options , . These options natively support sending the report output as an email attachment, uploading it to a WebDAV cloud storage location, or sending it to an FTP destination, making it ideal for interface requirements .

    • Avatar photoCustomer February 24, 2022 at 3:42 am  

      If the nightly run extracts zero data rows (e.g., no updates occurred), will an empty file still be sent out, and if so, how can I prevent this?

    • Support February 26, 2022 at 4:05 am  

      By default, when using Oracle’s standard delivery options for scheduled Blitz Reports, the system automatically suppresses the delivery of an empty output file (zero rows) , , . If your interface requirements actually demand that empty files *must* be sent, you can override this behavior by setting the profile option ‘Blitz Report Suppress Empty File Delivery’ to ‘No’ , .

    • Avatar photoCustomer February 26, 2022 at 12:53 pm  

      If I choose to submit a new concurrent request manually instead of copying an existing one, how do I ensure the parameters are mapped correctly to the concurrent program arguments?

    • Support February 28, 2022 at 3:25 pm  

      When manually submitting the ‘Blitz Report’ concurrent program, you must populate the report parameters starting from argument 16 onwards . Crucially, the values must be entered in exactly the same order as they appear on the Blitz Report run window . For instance, if ‘Ledger Name’ is the second parameter on the form, its value must be entered into Parameter2 (which corresponds to Argument 17 of the concurrent request) .

    • Avatar photoCustomer February 28, 2022 at 7:50 pm  

      I want the email subject line to be dynamic and include the Report Name and Row Count. Can I customize the subject line template?

    • Support March 1, 2022 at 5:06 pm  

      Yes, the default email subject is stored in the FND message `XXEN_REPORT_EMAIL_SUBJECT` . You can modify this message text, or create a new custom message, using placeholders like `&REPORT_NAME` and `&ROW_COUNT` for automated replacement at run-time . If you create a custom message (prefixed with `XXEN_REPORT_EMAIL`), you must update the profile option ‘Blitz Report Email Subject Message’ to point to your new message name .

Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with: