Receipts Workbench Issue: Unable To Apply Receipts To Invoices, Debug Log Shows Error: Gross transaction amount do not reconcile (Doc ID 1340257.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.
Form:ARXRWMAI.FMB - Receipts


Symptoms

Applying a receipt to an invoice fails, the FND debug log shows:

Gross transaction amount do not reconcile
OTHERS IN Trx_level_direct_cash_apply :User-Defined Exception
EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax:User-Defined Exception
EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA
EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common
EXCEPTION: ARP_RECEIPTS_MAIN.Derive_Accounting_Entry
EXCEPTION: ARP_RECEIPTS_MAIN.Execute
EXCEPTION: ARP_ACCT_MAIN.Create_Acct_Entry
EXCEPTION: Overloaded ARP_ACCT_MAIN.Create_Acct_Entry
EXCEPTION: arp_process_application.receipt_application

Invoice shows upgrade_method = R12_NLB. All these invoices were created without tax; however, they have positive tax adjustments.


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