Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter Sample Transaction Definitions User’s Guide Documentation | Transaction Definition (IS-to-Oracle Applications 11.5) | APInvoices
 
APInvoices
Use this transaction to create invoices for existing purchase orders. The Payables Open Interface Import program creates invoices to import into Payables, using invoice data stored in the Payables open interface tables.
For more information about this transaction, see your Oracle Applications documentation.
Oracle Applications Module
Payables
Open Interface
Payables Open Interface
Open Interface Tables
The open interface tables exposed by this transaction are:
*AP_INVOICES_INTERFACE
*AP_INVOICE_LINES_INTERFACE
Error SQL
Inputs
Field
Description
SOURCE
A value to match against the SOURCE column in a corresponding AP_INVOICES_INTERFACE row. This parameter will accept wild cards. % returns all errors.
Outputs
Field
Description
PO_NUMBER
Purchase order number associated with the Invoice.
VENDOR_ID
Vendor ID.
VENDOR_NUM
Vendor number.
VENDOR_NAME
Vendor name.
VENDOR_SITE_ID
Vendor site ID.
VENDOR_SITE_CODE
Vendor site code.
INVOICE_NUM
Invoice number.
INVOICE_ID
Invoice ID.
LINE_NUMBER
Invoice line number.
DISPLAYED_FIELD
Error code display value.