AR GDF: AR_DFS_TRX_LINES_FIX_ORIG_REM.sql Cannot Apply a Receipt or Credit Memo due to Error - OTHERS IN Trx_level_direct_cash_apply: User-Defined Exception "ORA-06510: PL/SQL: Unhandled User-Defined Exception" (Doc ID 1144926.1)

Last updated on AUGUST 09, 2024

Applies to:

Symptoms

The issue happens only for those invoices with Line level balance set and with having Accounting rules.

>> Not able to Import Credit Memos against Invoices through Autoinvoice

>> Unable To Apply Receipt To An Invoice

No error is raised but when you attempt to save the application the following form message appears:

Do you want to save the changes you have made?

Review of the FND debug log shows:

ar.plsql.arp_det_dist_pkg.reconciliation OTHERS IN Trx_level_direct_cash_apply :User-Defined Exception "ORA-06510: PL/SQL: unhandled user-defined exception"

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.