Monday, 10 February 2014

How to add sequence numbers in XSLT for EBS AP_Invoice_Interface and AP_Invoice_Lines

Create a valid data-source connection to your database. I have used the EBS Application Adapter to create the sequence number for my InvoiceId.

        <top:invoiceId>
          <xsl:value-of select='oraext:sequence-next-val("AP_INVOICES_INTERFACE_S","jdbc/soa/ebsdev")'/>
        </top:invoiceId>

              <top:invoiceLineId>
                <xsl:value-of select='oraext:sequence-next-val("AP_INVOICE_LINES_INTERFACE_S","jdbc/soa/ebsdev")'/>
              </top:invoiceLineId>

As seen above, you can create the sequence number within xslt pointing it to the data-source configured on your weblogic
Posted by at

1 comment:

  1. Richard C. Lambert10 February 2016 at 23:49

    AP invoice automation also enables more paperless work and shorter invoice processing time. In fact, by using the right invoice automation solution your company can reduce AP invoice processing costs by up to 90%. Time is king.
    Project Management Software

    ReplyDelete

Subscribe to: Post Comments (Atom)