My Oracle Support Banner

AutoInvoice Errors: Troubleshooting Payment Terms In AutoInvoice (Doc ID 1083494.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Receivables - Version to 12 [Release 11.5.10 to 12.0]
Oracle Receivables - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Receivables - Version 12.2.7 to 12.2.7 [Release 12.2]
Information in this document applies to any platform.
Form:RAXSUTRM.FMB - Define Payment Terms
Executable:RAXMTR - AutoInvoice Master Program
Executable:RAXTRX - AutoInvoice Import Program


Oracle Receivables (AR): AutoInvoice Information Center > Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 > Note 1083494.1

This note was created to facilitate troubleshooting issues regarding Payment Terms in AutoInvoice.

Receivables allows you to define standard payment terms to associate a due date and discount date for transactions. Payment terms can allow discount (when paid prior to due date), split terms (to facilitate installments) and balance forward (for periodic billing).

For more information on how to setup Payment Terms, please review:

For troubleshooting other AutoInvoice issues, please review Note 1075757.1, Troubleshooting AutoInvoice for Oracle Receivables Release 12.

In AutoInvoice, providing details on the payment term is mandatory for invoices and debit memos. Depending upon your setup in Transaction Sources, you need to provide either the TERM_ID or TERM_NAME in RA_INTERFACE_LINES_ALL.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Troubleshooting Steps
 1. Troubleshooting Errors During Import
      a. Invalid Payment Terms ID (TERM_ID)
      b. AutoInvoice Allows Import Of Data With End-Dated/Inactive Payment Terms
      c. AR_RAXTRX-1629 or You Must Supply Payment Terms For Your Non-credit Transaction
           i. Transaction Source Setup
           ii. Check Contra Charge Setup
      d. X row(s) inserted into errors table (null billing_date)
      e. ORA-1400 Cannot Insert NULL into AR_PAYMENT_SCHEDULES_ALL
      f. You Must Supply Payment Terms For Your Non-credit Transaction or APP-11939 You Must Supply Term ID Or Term Name
      g. You Cannot Supply Payment Terms For Your Credit Memo Transaction
      h. Please Set A Default Payment Term For The Customer, Site, Or Transaction Type
      i. Passing in DUE_DATE
      j. Error when using payment terms with cutoff dates
 2. Troubleshooting Unexpected Behavior Of Interfaced Data - Payment Terms
      a. Customer Profiles (Override Terms)
 b. Due Dates Reflect A Date That Has Already Passed
 3. Important Files
 4. Still Have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.