My Oracle Support Banner

Unable to Reverse Some Receipts In Receipt Batch (Doc ID 1182423.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


Symptoms

When attempting to reverse Receipts, not all receipts are being reversed.  No error message is raised.
Then when attempt to leave the form, receive message 'Do you want to save the changes made?'  Cannot exit the form until say 'No'

Debug log shows the following:
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log Oracle error 0001: ORA-06502: PL/SQL: numeric or value error: character to number conversion error has been detected in PROCESS_REVERSAL.
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log Oracle error 0001: ORA-20001: Oracle error 0001: ORA-06502: PL/SQL: numeric or value error: character to number conversion error has been detected in PROCESS_REVERSAL. has been detected in PROCESS_REVERSAL.
ar.plsql.arp_cash_receipts_pkg.update_p EXCEPTION: arp_cash_receipts_pkg.update_p
ar.plsql.arp_cash_receipts_pkg.update_p update_current_cr_rec: EXCEPTION: arp_reverse_receipt.update_current_cr_rec
ar.plsql.arp_cash_receipts_pkg.update_p validate_args: EXCEPTION: arp_reverse_receipt.reverse
ar.plsql.arp_cash_receipts_pkg.update_p Exception in arp_process_receipts.update_cash_receipts
ar.plsql.arp_cash_receipts_pkg.update_p "update_cash_receipt: p_cash_receipt_id = 123456"
ar.plsql.arp_cash_receipts_pkg.update_p "update_cash_receipt: p_amount = 132"
ar.plsql.arp_cash_receipts_pkg.update_p "update_cash_receipt: p_factor_discount_amount = 0"



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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