Receipts Workbench Issue: Unable To Apply Receipt To An Invoice, No Error Message is Raised, Application is Not Saved. (Doc ID 958554.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

Cannot 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?

The error does not happen for all receipts. 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"
ar.plsql.arp_auto_rule.create_distributions EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax:User-Defined Exception "ORA-06510: PL/SQL: unhandled user-defined exception"
ar.plsql.arp_auto_rule.create_distributions EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA "ORA-06510: PL/SQL: unhandled user-defined exception"
ar.plsql.arp_auto_rule.create_distributions EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common "ORA-06510: PL/SQL: unhandled user-defined exception"
ar.plsql.arp_auto_rule.create_distributions EXCEPTION: ARP_RECEIPTS_MAIN.Derive_Accounting_Entr "ORA-06510: PL/SQL: unhandled user-defined exception"
ar.plsql.arp_auto_rule.create_distributions EXCEPTION: ARP_RECEIPTS_MAIN.Execute "ORA-06510: PL/SQL: unhandled user-defined exception"
ar.plsql.arp_auto_rule.create_distributions EXCEPTION: ARP_ACCT_MAIN.Create_Acct_Entry "ORA-06510: PL/SQL: unhandled user-defined exception"
ar.plsql.arp_auto_rule.create_distributions EXCEPTION: Overloaded ARP_ACCT_MAIN.Create_Acct_Entry "ORA-20001:"


Changes

Upgraded 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