My Oracle Support Banner

Unable to create Invoice type Adjustment on upgraded Transactions : This action has been blocked to avoid inaccurate Accounting entries (Doc ID 2425345.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

On : 12.2.6 version, Transactions Related
  
There are few Transactions which were upgrade from 11i.
There is Tax and Line balance on Invoice / Credit Memo and Tax Remaining sign is different from line balance.
For e.g. if Line Remaining is +100 then Tax Remaining is -20

While creating an Adjustment of of type INVOICE ,system throws following error 

 
ERROR
-----------------------
This action has been blocked to avoid inaccurate Accounting entries. Please contact Oracle Support

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to create Adjustment on Invoice.

FND debug shows 

ARP_ACCT_MAIN.Set_Adj_CCID()+
Set_Adj_CCID: adj_code_combination_id
ARP_BALANCE_CHK.CHECK_ADJ_BALANCE (+)
ARP_BALANCE_CHK.CHECK_ADJ_BALANCE - OUT_OF_BALANCE
Adjustment_id = 2863516
Amount Debit = 3771.25
Amount Credit = 3771.25
Acctd Amount Debit = 7006.36
Acctd AmountCredit = 3771.25
ARP_BALANCE_CHK.Check_Precision (+)
p_amount 7006.36
p_actual_amount 7006.36
p_FunctionalCurrency 7006.36
Application amount precision matches with FND currency precision
ARP_BALANCE_CHK.Check_Precision (-)
ARP_BALANCE_CHK.Check_Precision (+)
p_amount 3771.25
p_actual_amount 3771.25
p_FunctionalCurrency 3771.25
Application amount precision matches with FND currency precision
ARP_BALANCE_CHK.Check_Precision (-)
This action has been blocked to avoid inaccurate accounting entries. Please contact Oracle Support Services

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
Cause
Solution


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