Pricing Attribute Mapping Function Returns a Wrong Value When Using the European Numeric Format ".," (Doc ID 1680505.1)

Last updated on MARCH 31, 2020

Applies to:

Symptoms

QP Pricing Attribute mapping function returns wrong value du to simple change of numeric character format in user preference 10.000,00
When apply format 10,000.00 in user preference, the API returns the right value but this is not the client format. The needed format is 10.000,00
We changed the ICX profile options and tested with different value but still get the same issue.
Hen we changed NLS database to FRANCE as territory and French as langue and ‘,.’ As numeric format, the same application with ICX profiles, but still the same issue.
The attribute mapping we tested is simple:
Enter value in Sales Order attribute1 like 5,000001 (this mean 5% for user value set is 7 decimal character)
The function should return this value divided by 100
So the expected result is 0,05
But we get instead 50.000.001,00

We modified the SQL function used in the pricing attribute mapping, we set the variable type as varchar2 in US format (to_char(V_HUM_REEL, '90D9999999', 'NLS_NUMERIC_CHARACTERS=''.,''') rather than number type then it gives the right value in Sales Order unit price.

Cause

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