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 laterInformation in this document applies to any platform.
Symptoms
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.
OR
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).
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 |
1. Bug Summary |
2. Fixed Files |
3. Recommended Patches |
4. Solution Steps |
References |