Create Invoice Type Adjustments for Credit Memo fails with Error "Entered and accounted amount mismatch for the adjustment is detected in call to method arp_balance_check.check_adj_balance" (Doc ID 3016264.1)

Last updated on APRIL 22, 2024

Applies to:

Symptoms

When attempting to run "Create Automatic Billing Adjustments" to on Credit Memos, the following error occurs in the log file:

EXCEPTION:  unknown mode : ADJUSTMENT
ARP_BALANCE_CHK.CHECK_ADJ_BALANCE (+)
p_adj_id      = nnnnnnn
p_request_id  = xxxxxxx
p_called_from_api = N
ARP_BALANCE_CHK.CHECK_ADJ_BALANCE - OUT_OF_BALANCE
Adjustment_id = nnnnnnn
Amount Debit = 100
Amount Credit = 100
Acctd Amount Debit = 100
Acctd AmountCredit = 10
Entered and accounted amount mismatch for the adjustment is detected in call to method arp_balance_check.check_adj_balance. Please contact Oracle support

Try to Create manual Adjustment of type Invoice throws following ERROR on screen:

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Tools and then Scheduled Processes.
2. Go to Submit New Process and Run Create Automatic Billing Adjustments

For Manual Adjustment
1. Navigator Go to Receivables > Billing
2. Query the Credit Memo against which Adjustment is needed
3. Click on Action > Manage Adjustments
4. Click on Create
5. Select the options for the adjustments, add Adjustment Type = Invoice Adjustments
6. Press submit and observed the error appears as

The sum of debits and credits are out of balance. This action was blocked to avoid inaccurate accounting entries. (AR-855267)
ORA-20001: (AR-855636)
arp_process_adjustment.insert_adjustment exception: ORA-20001: (AR-855636)

Changes

Cause

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