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