Pricing And Availability Window With Unit Of Measure Conversion Shows Wrong Price Break Quantities (Doc ID 2102192.1)

Last updated on FEBRUARY 01, 2016

Applies to:

Oracle Order Management - Version 12.2.4 and later
Information in this document applies to any platform.
FORM: OEXPRAVA

Symptoms

On :  12.2.4 version, Quoting & Negotiation

ACTUAL BEHAVIOR  
---------------
Checking pricing in hundredweight (CW) in the Pricing and Availability window (OEXPRAVA).
CW Unit Price is correctly calculated as 100 * LB Unit Price defined in the price breaks.
However, the Price Break Quantity is calculated incorrectly. This should be the Pound (LB) Price Break Quantity / 100.
While on the price and availability form, if one changes the Unit of Measure (UOM) to ‘CW’ from UOM of 'LB',
then clicks on ‘Price and Availability’ again, the following error is shown.

ERROR
-----------------------
 FRM-40831: Truncation occurred: value to long for field VALUE_TO.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Review of Unit of Measure Conversions
    Navigate to: Inventory > Setup > Items > Conversions > Standard (tab)

Unit      Class  = Conversion  
CW       WEIGHT    45359.22922
Gram     WEIGHT    1
Pound    WEIGHT    453.5922922
Base UOM of Grams.
CW is exactly 100x Pound.

2. Review Price List Setup
    Responsibility: Oracle Pricing Manager
    Navigate to: Price Lists > Price List Setup

Price List Line is setup in LBs
Price List = PPP Price List – Pricing and Availability Test
Currency: USD
Item Number: 1228220, UOM = LB, Primary UOM is checked
Price Break type = Point

Under Price Breaks… (Break Type = Point, Attribute = Item Quantity)
       Value From   Value To      List Price    
                0           5000                    1
             5000          10000                   .9
            10000       99999999                   .8
3. Replicate the issue.
    Responsibility: Order Management Super User (or equivalent)
    Navigate to: Orders, Returns > Pricing and Availability
    Enter the following fields:

Item Number
Unit of Measure LB
Price List
Then click on the ‘Price and Availability’ button and everything looks good.
     item: 1228220, Qty = 1, UOM = LB, Warehouse is null,
     request date: 24-SEP-2015, order type is null.

Under Pricing tab….
Unit List Price = 1.0000, Unit Selling Price = 1.0000 USD, Price List = PPP Price List -…,
  Under Price Breaks… (Break Type = Point, Attribute = Item Quantity)
       Value From   Value To      List Price    
                0           5000                    1
             5000          10000                   .9
            10000       99999999                   .8
.

*Now, change the UOM to ‘CW’ and click on ‘Price and Availability’ again.
  Error is shown:
  FRM-40831: Truncation occurred: value to long for field VALUE_TO.
  item: 1228220, Qty = 1, UOM = CW, Warehouse is null,
  request date: 24-SEP-2015, order type is null.

Under Pricing tab….
Unit List Price = 100.0000, Unit Selling Price = 100.0000 USD, Price List = PPP Price List -…,
  Under Price Breaks… (Break Type = Point, Attribute = Item Quantity)
       Value From            Value To                        List Price    
               0                   49.8866213151927437   100
49.8866213151927437   99.7732426303854875     90
99.7732426303854875   997732.416326530612     80


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot acquire the correct information without an error message.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms