My Oracle Support Banner

Receipts Workbench Issue: Miscellaneous Receipt is in Remitted Status Even Though the Amount is Not Captured Successfully in IBY or Second Refund Fails with ORA-06502: PL/SQL: Numeric or Value Error (Doc ID 1499087.1)

Last updated on MAY 20, 2024

Applies to:

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



A Receipt is noted to be in REMITTED status, even when the amount is not captured successfully in IBY. During remittance process, when the receipt is REMITTED and then it receives a failed capture status from IBY, the receipt must revert to its previous remittance status.


Attempting to create a second refund against a cash receipt, the following issue is observed when the miscellaneous receipt is created. During the remittance, receive the following error:
ORA-06502: PL/SQL: numeric or value error: character to number

These symptoms are observed randomly during remittance.

Steps to Reproduce:

Responsibility: Receivables Manager
Navigation: Receipts > Remittance

Remittance failed for the MISC receipt created through second refund against cash receipt and/or the receipt is in REMITTED status even though the amount is not captured successfully in IBY (status = 0).




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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