Apply a Receipt to An Invoice Error - This Action Has Been Blocked to Avoid Inaccurate Accounting Entries. Please Contact Oracle Support Services. ORA-00001: Unique Constraint (AR.AR_BASE_DIST_AMTS_GT_U1) Violated

(Doc ID 1683079.1)

Last updated on JUNE 08, 2016

Applies to:

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

Symptoms

On R12, Receipts Related

Attempting to apply a receipt to an invoice and receive the following error:

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

FND DEBUG LOG looks something like this:

get_direct_adj_dist +
  p_mode   : OLTP
  p_trx_id : 1214982
  p_gt_id  : 1599258
get_direct_adj_dist -
get_direct_inv_adj_dist +
  p_mode   : OLTP
  p_trx_id : 1214982
  p_gt_id  : 1599258
get_direct_inv_adj_dist -
update_base +
EXCEPTION OTHERS: update_base :ORA-00001: unique constraint (AR.AR_BASE_DIST_AMTS_GT_U1) violated
...
ARP_BALANCE_CHK.CHECK_RECP_BALANCE (+)
GL_DATE : 01-JUN-2014
Sum_amount_dr :1175.18
Sum_amount_cr :1175.18
Sum_acctd_amount_dr : 1175.18
Sum_acctd_amount_cr : 1175.18
CC_flag : N
GL_DATE : 06-JUN-2014
Sum_amount_dr :1175.18
Sum_amount_cr :28204.32
Sum_acctd_amount_dr : 1175.18
Sum_acctd_amount_cr : 28204.32
CC_flag : N
ARP_BALANCE_CHK.CHECK_RECP_BALANCE - OUT_OF_BALANCE
ARP_BALANCE_CHK.Check_Precision (+)
p_amount 1175.18
p_actual_amount 1175.18
p_FunctionalCurrency 1175.18
Application amount precision matches with FND currency precision
ARP_BALANCE_CHK.Check_Precision (-)
ARP_BALANCE_CHK.Check_Precision (+)
p_amount 28204.32
p_actual_amount 28204.32
p_FunctionalCurrency 28204.32
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
EXCEPTION: arp_process_application.receipt_application

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms