My Oracle Support Banner

When Trying to Apply Receipt Getting Error "ORA-06502: PL/SQL: numeric or value error: character to number conversion error" (Doc ID 3024830.1)

Last updated on JUNE 06, 2024

Applies to:

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

Symptoms

When a specific user tries to apply a receipt is getting below error

ORA-06502: PL/SQL: Numeric or value error: Character to number conversion error
ORA-06502: in "APPS.FND.NUMBER", line 20.

The error is not raised for the other users.

The screen for the user with the error shows the amounts in this format: 99,999.99

For the rest of the users the amounts are showing in this format : 99 999.99 


Steps to Reproduce:

Responsibility: Receivables Manager
Navigation
: Receipts > Receipts

  1. Query Receipt
  2. Click Apply

 

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.