Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter Sample Transaction Definitions User’s Guide Documentation | Transaction Definitions (IS-to-Oracle 10.7SC) | APInvoice
 
APInvoice
Use this transaction to create invoices from invoice information loaded from other accounting system and to update voucher number information for existing invoices. The Payables Open Interface Import program creates invoices to import into Payables using invoice data stored in the Payables open interface.
For more information about this transaction, see your Oracle Applications documentation.
Oracle Applications Module
Payables
Open Interface
AP Invoice Open Import Transaction
Open Interface Tables
Open interface table(s) exposed by the transaction are as follows:
*AP_EXPENSE_REPORT_HEADERS_ALL
*AP_EXPENSE_REPORT_LINES_ALL
Error SQL
Open interface table(s) queried by the error SQL are as follows:
*AP_EXPENSE_REPORT_HEADERS_ALL
*FND_USER
Inputs
Field
Description
WM_USER
User ID of the person who initiated the transaction; that is, the user ID in the CREATED_BY field in the transaction.
SOURCE
Import source name for your non‐Oracle accounting system.
Outputs
None.
Usage Comments
Field
Description
VENDOR_ID
Vendor ID.
VENDOR_SITE_ID
Vendor site ID.
INVOICE_NUM
Invoice number.
SOURCE
Invoice ID.
REJECT_CODE
Description.
To import invoice information, run the Payables Invoice Import request, which is under the AP module.