1. Implementing Order Management
  2. Control Decimal Precision

Control Decimal Precision

Use the Quantity Decimal Precision profile to control decimal precision for attributes that store numeric values.

For example, to control decimal precision on the order line quantity that the Order Entry Specialist sets on the Create Order page, or to control decimal precision during order import.

Decimal precision is the total number of digits that a number contains, where scale specifies the number of digits that exist to the right of the decimal point.

For example, the number 17.347 uses a precision of 5 and a scale of 3.

You can't modify precision but you can modify scale. For example, if you set the scale to 3 in the Quantity Decimal Precision profile, and if the Order Entry Specialist enters 17.3468 for the quantity, then the profile will round 17.3468 to 17.347.

Quantity for some items is typically a whole number. For example, most companies sell a desktop computer as a whole item. Don't use Quantity Decimal Precision to allow only a whole number in the quantity. Instead, you can set the Indivisible attribute to Yes in the Product Information Management work area when you set up the item.

Here's your scenario.

  • You sell a variety of elements from the periodic table according to weight, such as Diamond.

  • You sell these elements in grams and milligrams, which is 1/1000 of a gram.

  • The value for milligram can range from 0.001 to 0.999.

  • You already set up an item named Diamond in the Product Information Management work area, and you specified it to use Gram as the unit of measure.

  • You will set the scale to 3.

Try it.

  1. Go to the Setup and Maintenance work area, then click Tasks > Search.

  2. On the Search page, search for, then open Manage Administrator Profile Values.

    For details about this task, see Implementing Common Features for Oracle SCM.

  3. On the Manage Administrator Profile Values page, in the Search area, enter the value, then click Search.

    Attribute

    Value

    Profile Display Name

    Quantity Decimal Precision

  4. In the search results, in the Profile Values area, set the value, then click Save and Close > Done.

    Attribute

    Value

    Profile Value

    3

    You can set decimal precision only at the Site level. You can't set it for each item or for each unit of measure.

  5. Go to the Order Management work area, then click Create Order.

  6. On the Create Order page, in the Select Item window, enter Diamond, then click Search.

  7. On the catalog search line, in the quantity window to the left of Gram, set the value to 17.3468, then click Add.

  8. Verify that the Create Order page displays a message that it rounded your value to 17.347.

Related Topics