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 APRIL 01, 2024

Applies to:

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

Symptoms

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

Error
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
Actions>Adjust
Enter the $99 and try to save



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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