ARXRWMAI - Can Not Reverse Some Receipts In Receipt Batch (Doc ID 1182423.1)

Last updated on JUNE 07, 2016

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.
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 = 561065"
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"



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