Receipts Workbench: Unable To Apply Receipts To An Upgraded Invoice - EXCEPTION fnd_api.g_exc_error - Over Applications ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT

(Doc ID 1571314.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Transactions Related

Attempting to apply a receipt to an upgraded invoice and the record cannot be saved and the following error occurs in debug log file:

ERROR
-----------------------
EXCEPTION: arp_process_application.receipt_application
EXCEPTION: Overloaded ARP_ACCT_MAIN.Create_Acct_Entry
EXCEPTION: ARP_ACCT_MAIN.Create_Acct_Entry
EXCEPTION: ARP_RECEIPTS_MAIN.Execute
EXCEPTION: ARP_RECEIPTS_MAIN.Derive_Accounting_Entry
EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common
EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA
EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax:User-Defined Exception
"last error:Error: EXCEPTION over_applications in ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT
sum amount remaining from the invoice:0
sum of application buckets :137.14"
fnd_api.G_EXC_ERROR IN Trx_level_direct_cash_apply error count:1
"EXCEPTION fnd_api.g_exc_error - over applications ar_upgrade_cash_accrual.COMPARE_RA_REM_AMT
sum amount remaining from the invoice:0
sum of application buckets :137.14"
SUM_ALL_APP_BUCKET > SUM_ALL_REM_BUCKET - Overapplication


Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Receipts > Receipts
Find Receipt Number and Click Apply to open Applications window
Populate Apply To field
Message: Do you want to save changes you have made?
Select Yes
Form is closed and application cannot be saved

Changes

Upgrade from 11i to R12

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