Credit an Invoice with Option Open Receivables "No" - Error APP-AR-11091: You Cannot Over Apply This Transaction (Doc ID 1595846.1)

Last updated on OCTOBER 04, 2022

Applies to:

Symptoms

You want to Credit an invoice and receive error

APP-AR-11091: You cannot over apply this transaction.

Transaction type of the Invoice has option Open Receivables set to "No".

Debug log shows :

ARP_BAL_UTIL.Transaction_Balances (+)
arp_trx_util.get_summary_trx_balances()-
previous_customer_trx_id : 54155
l_line_amount            : -3023,58
l_tax_amount             : -228,3
l_freight_amount         : 0
l_open_receivables_flag  : N
l_prev_line_original     : 3023,58
l_prev_line_remaining    : 0
l_prev_tax_original      : 228,3
l_prev_tax_remaining     : 0
l_prev_freight_original  : 0
l_prev_freight_remaining : 0
l_prev_total_original    : 3251,88
l_prev_total_remaining   : 0          
l_open_receivables_flag : N
l_commit_adj_amount : 0
check for total overapplication
raise_error: arp_non_db_pkg.check_natural_application(2)+
raise_error: -- Checking out NOCOPY the parameters
raise_error: -- Checking amount due remaining
raise_error: arp_non_db_pkg.check_creation_sign(1)+
raise_error: arp_non_db_pkg.check_creation_sign(1)-
raise_error: arp_non_db_pkg.check_natural_application(2)-AR_CKAP_OVERAPP
ERROR:  overapplication of the total amount
arp_trx_validate.add_to_error_list()+
p_mode = STANDARD
adding: ctid: 55206  trx_number: 2013005343  line: ,
 msg: AR_CKAP_OVERAPP token 1   token 2
error location:
APP-AR-11091: You cannot over apply this transaction.

Cause

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