My Oracle Support Banner

GL Concurrent Programs Are Completing With Error "ORA-01722: invalid number error" After Setting the Profile Option ICX: NUMERIC CHARACTERS To 10.000,00 At User Level. (Doc ID 2937215.1)

Last updated on APRIL 23, 2023

Applies to:

Oracle General Ledger - Version 12 and later
Information in this document applies to any platform.


After Setting the profile option 'ICX: NUMERIC CHARACTERS' to 10.000,00 at user level, few GL concurrent programs are completing with error

Exception Occured while inserting the data into GL_DAILY_RATES_INTERFACE-1722:-ORA-01722: invalid number

Number of Records Successfully Processed into GL: 16

Program - Daily Rates Import and Calculation Request Submitted successfully. Request_id is -3286504

Number of Records Rejected at GL_DAILY_RATES_INTERFACE: 75372

The issue can be reproduced at will with the following steps:
1. Login to General Ledger Responsibility.
2. Navigation: View/Submit a New Request.
3. Run the custom program 'XXXXX: XX GL Daily Rates Process'.
4. The program gets completing with error.


The Profile Option ICX: Numeric Characters is set to 10,000.00 at the site level and the issue is occurring after setting the Profile Option ICX: Numeric Characters is set to 10.000,00 at the user level


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

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