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 FEBRUARY 08, 2023

Applies to:

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

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.