My Oracle Support Banner

Receipts Workbench Error: Attempting to Reverse Receipts Created by Automatic Receipts Process Raises Error: This action created unbalanced accounting entries (Doc ID 393364.1)

Last updated on FEBRUARY 01, 2021

Applies to:

Oracle Receivables - Version to [Release 11.5.10]
Information in this document applies to any platform.
ConcurrentProgram:ARZCAR_RECEIPT - Automatic Receipts Creation Program


Reversing receipts created by Automatic Receipts generates unbalanced accounting entries.

Steps to reproduce this issue:

1. Created the following Receipt Class:

Creation Method: Automatic
Remittance Method: Standard
Clearance Method: By Matching
Payment Method: DE REMITTANCES
Lead days = 5

2. Created Payment Term CE BB as follows:

Credit Check = Yes
Discount Basis = Lines Only
Installment Options = Include tax and freight in first installment
Due: 8 Days
Discount: 4% 8 days

3. Created the following invoices:

trx_number      amount
12524                287.88
12525              4187.86
12526                  50.00
12527                294.60
12528                119.68
12529              1396.31
12530              1573.83

All of them with the payment term = CE BB, trx_date = 24-AUG-2006, gl_date = 24-AUG-2006.

4. Created batch 1187 Type Automatic. Automatic Receipts created receipt Number 4 (cash_receipt_id = 33698, status = CONFIRMED).
5. Unapply the receipt to the following transactions: 12524, 12527, 12528, 12529, 12530. Saved the changes.
6. Change the amount of the receipt so there will be no UNAPP amount.
7. Remitted the receipt.
8. Change Responsibility to Cash Management, Vision Operations (USA).
9. Go to Bank Statements --> Manual Clearing --> Clear Transactions.
10. Enter the Bank account for the payment method (make sure only Receipt is checked).
11. Enter receipt number (in this case receipt_number = 4).
12. Mark the receipt, click on Clear Transactions.
13. Change Responsibililty to Receivables, Vision Operations (USA).
14. Query receipt 4.
15. Click on Reverse (Reason = Non-sufficient funds).
16. Click OK.

The following warning pops-up:

"This action created unbalanced accounting entries. Please contact Oracle Support Services"

The reason you are getting this warning is that I have patch 4898885 (ONE OFF VALIDATE SUBLEDGERS WHILE INSERTING / UPDATING RECORDS (11I.AR.O)) applied.  Otherwise, you will not be able to post this receipt.

The are two possible manifestations of the error:

1. Receipts appear on Unposted Items Report and fail to post in GL

The journal entries created for the receipt are not balanced. This situation manifests if the user has not applied the patch provided for Bug 4474065 to prevent the creation/saving of unbalanced journal entries. 

Bug 4474065 provides a feature that raises an error when unbalanced accounting is encountered. This prevents the creation of data corruption. The patches for this feature are:

11i.AR.L: Patch 4638595
11i..AR.N: Patch 4478669
11i.AR.O: patch 5053864



Upon closer inspection, the receipts that manifest this error are Reversed Receipts. Review of the history shows that the receipt is applied, then unapplied, then reversed.

For a $500 receipt, following is an illustrationi of the records in AR_RECEIVABLE_APPLICATIONS:

2. When you attempt to reverse a receipt, the process is rolled back and an error is raised: 

This action is not permitted because it would create Unbalanced Accounting Entries. Please Contact Oracle Support Service

The above is the new behavior after applying the patches listed in note box in the previous section.

Steps to Reproduce:

  1. Create an automatic receipt method
  2. Create a customer
  3. Enter multiple invoices and make sure they have assigned this payment method and a bank account.
  4. Generate an automatic receipt for all 3
  5. Remit the receipt
  6. Unapply the 3 invoices from receipt
  7. Reverse the receipt.  

Additional Information:



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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 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.