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) | ARAutoInvoice
 
ARAutoInvoice
Use this transaction to create invoices, debit memos, credit memos, and on‐account credits in Oracle Receivables.
For more information about this transaction, see your Oracle Applications documentation.
Oracle Applications Module
Receivables
Open Interface
AutoInvoice
Open Interface Tables
The open interface tables exposed by this transaction are:
*RA_INTERFACE_LINES_ALL
*RA_INVOICE_SALESCREDITS_ALL
*RA_INTERFACE_DISTRIBUTION_ALL
Error SQL
Inputs
Field
Description
WM_USER
Name of the user for the corresponding user ID in the CREATED_BY column of the RA_INTERFACE_LINES_ALL table. This parameter will accept wild cards. % returns all errors.
Outputs
Field
Description
INTERFACE_LINE_ID
Contains the INTERFACE_LINE_ID from the RA_INTERFACE_LINES_ALL table.
INTERFACE_SALESCREDIT_ID
INTERFACE_SALESCREDIT_ID Contains the INTERFACE_SALESCREDITS_ID from the RA_INVOICE_SALESCREDIT_ALL table. This field will be empty if the error is from a different table.
INTERFACE_DISTRIBUTION_ID
Contains the INTERFACE_DISTRIBUTION_ID from the RA_INVOICE_DISTRIBUTIONS_ALL table. This field will be empty if the error is from a different table.
MESSAGE_TEXT
Error message.
INVALID_VALUE
The value that caused this error.
LINK_TO_LINE_ID
Contains the INTERFACE_LINE_ID from the associated row in the RA_INTERFACE_LINES_ALL table. A value will be in this field if the error occurred in the SALESCREDIT or DISTRIBUTIONS tables
ORG_ID
Operating Unit Identifier.