My Oracle Support Banner

APP-AR-11526 ORA-20001 The Invoice Has Open Claim When Trying To Reverse An Adjustment (Doc ID 2248859.1)

Last updated on MARCH 14, 2022

Applies to:

Oracle Receivables - Version 12.2.3 and later
Information in this document applies to any platform.


When attempting to reverse an adjustment for the invoice with claim attached the following errors occurs.

APP-AR-11503:Invoice type adjustment must make the balance due zero

APP-AR-11526: arp_process_adjustment.insert_adjustment
exception ORA-20001: The invoice has open claim for the amount 1320.
This adjustment will make the remaining balance on the invoice less
than the claim amount.
Please close the claim first and then create an adjustment.

Steps to Reproduce:
Responsibility: Receivables manager
Navigation: Transactions > Transactions
The issue can be reproduced at will with the following steps:
Transactions> Query Transaction#123456789
Enter the $99 and try to save


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

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