Troubleshooting AutoInvoice Receipt Method, Payment Method, Credit Card and Bank Account Errors
(Doc ID 1098583.1)
Last updated on DECEMBER 22, 2023
Applies to:
Oracle Receivables - Version 11.5.10.0 and laterInformation in this document applies to any platform.
Executable:RAXTRX - Autoinvoice Import Program
Purpose
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
| Purpose |
| 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? |
| References |