Setting Profile ICX: Numeric Characters Creates Incorrect Price When Using a Dynamic Formula (Doc ID 1498283.1)

Last updated on JUNE 23, 2023

Applies to:

Symptoms

On : 12.1.3 version, Pricing, Discounting & Charges

ACTUAL BEHAVIOR
---------------
When the profile ICX: Numeric Characters for European style comma and dot for Decimal places and 1000's place respectively, Pricing formula processes it incorrectly.

EXPECTED BEHAVIOR
-----------------------
Pricing Formula should process it same irrespective of whether the profile ICX: Numeric Characters is set one way or the other.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set ICX: Numeric Characters to European style and process an Intercompany record that bases the transfer price on the cost and uses a formula to make a mark up.
2. When the formula evaluates the cost, it shows as 10 times what it actually is.
3. There are no error messages.

ADDITIONAL OBSERVATION
---------------------------------

When a pricelist with a dynamic formula is used, entering a sales order leads to wrong prices when user preferences have a comma as decimal separator in their user preferences.

  For ICX: Numeric Characters:
  user value = 10.000,00
 
  default value = 10,000.00
 
  Formula (basically) is 1,1 * item price
  The sales order shows:
  usp = 425,70
  The price is now 100 higher than it should be.
 
  =======================
  When ICX: Numeric Characters:
  user value = 10.000,00
 
  default value = 10,000.00
 
  Formula (basically) is 1.1 * item price
  The sales order shows:
  usp = 4.26
  This is correct.
 
  EXPECT: 4,26 when profile ICX: Numeric Characters is
  user value = 10.000,00

  default value = 10,000.00

Changes

Cause

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