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:
Oracle Fusion Receivables Cloud Service - Version 11.13.23.10.0 and laterInformation in this document applies to any platform.
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:
ORA-20001: (AR-855636)
arp_process_adjustment.insert_adjustment exception: ORA-20001: (AR-855636)
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
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 |