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

Table 1. 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.
Table 2. 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.