My Oracle Support Banner

Troubleshooting AutoInvoice Receipt Method, Payment Method, Credit Card and Bank Account Errors (Doc ID 1098583.1)

Last updated on MARCH 02, 2021

Applies to:

Oracle Receivables - Version and later
Information in this document applies to any platform.
Executable:RAXTRX - Autoinvoice Import Program


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


The purpose of this note is to explain the usage of the Payment Method and Receipt Method features in the context of AutoInvoice.  This note also seeks to provide step-by-step troubleshooting instructions to resolve common errors, exceptions and unexpected behavior returned by AutoInvoice related to these fields.

This note should be used in conjunction with the following two articles:
Note 1067402.1, AutoInvoice Setup for Release 12: A Case Study Using a Simple Script
Note 1075757.1, Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12

In addition, readers may wish to review the following:
Note 1071284.1 Setting Up Receipt Class And Method For AutoInvoice

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
 Oracle Receivables (AR): AutoInvoice Information Center >Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 > Note 1098583.1
Troubleshooting Steps
 1. Receipt Method Defaulting vs Passing as a Parameter
     a. Defaulting Logic
     b. Passing a Specific Receipt Method
     c. Validation Used for Receipt Methods
 2. Customer Bank Account Defaulting and Validation Criteria
     a. Changes From Release 11.5 to Release 12
     b. Bank Account Defaulting Logic
     c. Bank Account Validation
 3. Troubleshooting Common Errors and Exceptions
     a. Review AutoInvoice Execution Report
     b. Review the Failed Transactions
         i. Interface Lines Form
         ii. Interface Data Collection Scripts & Querying RA_CUSTOMER_TRX_LINES_ALL
     c. If Receipt Method is Not Manual, Make sure the Bank Account exists
     d. Apply the very latest version of the AutoInvoice Defaulting Source Code
     e. Known Errors and Causes
 4. Credit Card Integration Issues
      a. 11i: Manually Created Bank Accounts vs Credit Cards (Org ID's are Null)
      b. Invalid payment method id (RECEIPT_METHOD_ID) (0)
     c. Supplied customer bank account (CUSTOMER_BANK_ACCOUNT_ID) must be both valid and active
      d. Receipt Method is incorrectly defaulted in even when one is not necessary
      e. Cannot apply the credit memo because the invoice is locked by another user. Please try again later
 5. 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.