Home › Discussions › Questions & Answers › Outbound Interface Scheduling and File Delivery

Outbound Interface Scheduling and File Delivery

Avatar photoCustomer Questions & Answers 7 replies

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?

7 replies

  • Support Enginatics

    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 .

  • 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 Enginatics

    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’ , .

  • 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 Enginatics

    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) .

  • 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 Enginatics

    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 .

  • You must be logged in to reply to this post.