My Oracle Support Banner

E1: 03B: Troubleshooting Common Errors on Automatic Cash Receipts (a.k.a. Auto Receipts or Auto Cash) (Doc ID 1988280.1)

Last updated on OCTOBER 01, 2021

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version XE and later
Information in this document applies to any platform.

Purpose

This document provides answers to some frequent errors and issues on Automatic Receipts (a.k.a. Auto Cash) (P03B121, R03B50, R03B551, R03B50D, R03B50E, R03B50A, R03B50B, R03B50F).

NOTE!  For full information on:
  • Setup for automatic receipts processing, link to <document 1458481.1> - How To Set Up and Map Data for Automatic Receipts In EnterpriseOne Accounts Receivable.
  • Processing automatic receipts, link to <document 1458442.1> - How To Process Automatic Receipts (Auto Cash) In EnterpriseOne Accounts Receivable.
  • Frequently Asked Questions (FAQ) on processing auto cash, link to <document 1987804.1> FAQ: Automatic Receipts (Auto Cash) in EnterpriseOne Accounts Receivable.

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
Troubleshooting Steps
 Automatic Receipt Algorithm Issues (R03B50A, R03B50B, R03B50D, R03B50E, R03B50F)
 Issue 1:  Known Invoice Match with Amount (R03B50D) algorithm does not apply a partial receipt to an invoice when the processing option on the Amount Match tab for Tolerance is set to a 1.
 Issue 2:  Invoices are not matching to receipts correctly using Known Invoice with Known Amount (R03B50D) algorithm.
 Issue 3: The Known Invoice Match with Amount (R03B50D) creates unwanted chargebacks, deductions, or write-offs when the amount received is over the invoice total.
 Issue 4: The Known Invoice Match with Amount (R03B50D) does not match an invoice that is indicated in the electronic receipt and only an unapplied receipt is created.
 Issue 5: When using Known Invoice Match with Amount (R03B50D) with several Invoices that all have the full amount of the invoice on the receipt, but the amount of the receipt is less than the total amount of the invoice, the system is not creating the Chargeback (document type RB), and only creates the F03B13 record without any F03B14 records. Apply Receipts processing options for creating Chargebacks are set on the version of R03B50D being invoked. The jdedebug.log for R03B50 shows Error 078F ("The record being inserted into the table F03B11 already exists or you do not have authority to insert records into this table."), as well as the following unique constraint error:  unique constraint (QADTA.F03B11_PK) violated.
 Update Receipts Header (R03B551) Issues
 Issue 1: Error:  Gross Amount is Missing -  The receipts listed above have not been uploaded. All other receipts have been processed on Update Receipts Header (R03B551).
 Issue 2: Error: Transaction failed to commit - The receipts listed above have not been uploaded. All other receipts have been processed - when the Update Receipts Header (R03B551) is submitted.
 Apply Receipts to Invoices (R03B50) Issues
 Issue 1:  Unposted Receipts Will Not Match to Unapplied Cash.
 Issue 2:  Unable to process receipts with negative amounts using Apply Receipts to Invoices (R03B50).
 Issue 3: The new generic match field RMR1 is not matching properly.
 Issue 4:  The Apply Receipts to Invoices (R03B50) UBE runs the Known Invoice Match with Amount (R03B50D) algorithm in a loop until terminated.
 Issue 5: Receipt batch uploaded ok but has a upload status of H so it didn't apply to invoices.
 Issue 6: Error: "No Receipts Met Selection Criteria" when called from the Update Receipts Header (R03B551).
References

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