Integrated Document Solutions
for Business Applications

Sort Posts

Get Fresh Updates

Home / Blog / Current Page

Easily Add New Document Types for Delivery from AventX Oracle Connector

Posted on by John Vincent

I often receive emails and phone calls from DBAs and ERP Managers that need help satisfying new functional requests that they receive from their end-users.  For example, these questions typically included something like the following:  “We deployed AventX in Oracle EBS for sending batches of invoices and now the end-users are asking if we can send a custom report with AventX…is this possible?”  The answer is almost always yes and let me tell you why.

The AventX Oracle Connector comes out of the box with “embedded queries” for sending six of the most popular document types including purchase orders, invoices, statements, work orders, sales order acknowledgements, and requests for quotations (we call these “seeded documents” because AventX provides the SQL query for finding recipient’s email address, fax number, or their defined printer). This means without any advanced configuration the software can fax, email, print, and archive these documents.  For those of you that have custom reports like dunning letters, quote acknowledgments, packing slips, pick slips, etc., we have an easy to use tool in Oracle EBS called the “New Document Wizard” (aka the Add Your Own Document Wizard or AYOD  for short).  This tool can help you do some pretty cool stuff without any custom code including the following:

  • Configure any document for email, fax, or print delivery as a batch or a single document
  • Configure an unlimited number of recipients; simply enter your SQL and we even provide a “Test Query” button to make sure it returns the correct recipient data.  The query can be configured to return the first recipient or all recipients.
  • Configure the subject of email that AventX will send on a per document type basis.
  • Configure who receives acknowledgments regarding delivery status (e.g. success and failure).
  • Configure a specific attachment extraction query.
  • Configure an XML Archive Gateway query (this tells AventX how it should archive your new document).
  • Configure a sender query (i.e. the FROM = value); this is who gets the email if the recipient hits the “reply” button.

To help you get started, here are the slides from our Add Your Own Document tutorial webcast:

If you need some additional help, I offer the following resources:

  1. Contact the Services department to learn more
  2. Customers on active support can call STR Software’s Support Team with questions and requests for help regarding how to configure additional documents for automated delivery.
  3. Log into our Support Portal to read the knowledge base article and gain access to demonstration videos:  How to setup additional documents with the AventX Add Document Wizard with your SQL

Share This

4 Responses to Easily Add New Document Types for Delivery from AventX Oracle Connector

  1. Rohit says:

    Hi John,

    Thanks for sharing the information.
    I have one question about archiving using Aventx. We have requirement where we want to FTP the PDF output to server for archiving. Is it possible or we only can FTP XML output of report using XML Archive Gateway ?

    if yes which version of Aventx support PDF archiving.


  2. John Vincent says:

    Hi Rohit,

    Thank you for your comments. Yes, AventX supports sending the PDF output to an archive server via FTP or sFTP which can be setup and controlled via AventX. AventX has supported archiving technology since the introduction of version 5.6 and all of the setup and configuration is easily done within Oracle forms.

    Please contact me directly regarding your specific project.


  3. Mukesh says:

    Hi John,

    We are facing one issue for Emailing the XML Remittance report which is giving output as PDF. The error message is mentioned below.
    open failed: illegal insecure pathname
    FCOA ERROR 231: Unable to successfully page document. Please reference lastdoc.log and fcoa.log for details.
    Required your help on the same.

    Mukesh Rathi

  4. John Vincent says:

    Hi Mukesh,

    There are two great resources available from STR Software that can help you further. This first and recommended is to contact the STR Software Support Team: The STR Software Customer Portal also has a valuable knowledge base that will allow you to find helpful tips based on error codes:

    We look forward to your call.


Leave a Reply to John Vincent Cancel reply

Your email address will not be published. Required fields are marked *