We have one report in Discoverer when we are running it in any machine it is working fine except Sweden user machine.
When we are running the report at Sweden machine we are receiving error -ORA 01722.
We checked the conversion of string to numeric but it is fine.
Well, obviously it's not, otherwise Oracle wouldn't complain.
How is the conversion being done? Is it considering local numeric formats? or perhaps expecting a specific format that "looks fine" to yourself, but you don't realise that other countries use different formats?
e.g. in the UK, we use a comma "," as the thousands separator and a period "." as the decimal separator. In some other countries they are the other way around.