1. Implementing Product Management
  2. Configure Decimal Precision for Quantity and Yield

Configure Decimal Precision for Quantity and Yield

You can standardize decimal precision for structures and formulas with other SCM modules such as Inventory and Manufacturing by leveraging the standard inventory profile option INV_QUANTITY_DECIMAL_PRECISION.

This ensures consistent handling of quantity and yield precision across supported applications, reports, and integrations. The profile option allows precision to be configured up to 30 decimal places, and the specified precision is applied uniformly to both positive and negative values.

To use this feature, you must opt in to enable this feature Redwood: Configure Decimal Precision for Quantity and Yield.

Before you Opt in

Check the current data precision value. Failure to do so might result in changes to existing data.

In the Setup and Maintenance work area, navigate to the following:

  • Offering: Product Management

  • Task: Manage Administrator Profile Values

Search for the profile option code INV_QUANTITY_DECIMAL_PRECISION.

Attributes Where Precision is Applicable

The configured precision is applied to key component attributes, including:

  • Quantity
  • Yield
  • Absolute Yield
  • Minimum Quantity
  • Maximum Quantity
  • Substitute Item Quantity

The configured precision is honored in:

  • BOM components in change contexts (change orders, change requests, problem reports, and corrective actions)
  • Item Structure Report (only in the classic UI)
  • Change Summary Report
  • BOM Compare
  • History(or Audit) views - displayed values respect the configured precision.

The following product areas accept up to 30 decimal places for the attributes:

  • REST APIs (itemStructures and productChangeOrdersV2)
  • SOAP services
  • Item Import (FBDI)

Guidelines for Set Up

  • It's recommended to opt in to this feature only after evaluating how decimals are used in the attributes across the Oracle SCM applications such as Product Management, Inventory, Manufacturing, Order Management and Planning. Once you opt in, some changes with respect to decimals (in Product Management) can't be fully reversed when you opt out.
  • If you opt in to this feature and set the profile option INV_QUANTITY_DECIMAL_PRECISION to a value less than 10, the existing Quantity values with higher than 10 decimals will be rounded off to the value you set, resulting in loss of data.
    When the existing inventory profile value is low
    • If you opt in when the decimal precision is already set to a lower value, such as 5, the existing precision values will be decreased.
    • If you require a higher precision value, increase the profile option value before you opt in. For example, 10.
    • If you opt out, any data that isn’t modified will retain its original value, while any data that’s modified after opting in will retain the updated value (in this example: 5 decimals).
  • When the existing inventory profile value is high
    • If the decimal precision is already set to a higher value, such as 15, opt in to this feature only if this level of precision is desired.
    • If you opt in and modify the Quantity value, the updated value will be retained even after you opt out.
  • When you reduce the inventory profile value after you opt in
    • Existing Quantity and Yield values with higher precision will be rounded off to match the new value.
    • The initial higher-precision values can’t be restored once they’re rounded off.
    • You may opt out to reset the decimal precision to 10.
  • Modifying the profile option INV_QUANTITY_DECIMAL_PRECISION will also impact downstream Oracle applications such as Inventory, Manufacturing, and Costing, if you’re already using them.
  • If you have integrated your application with third party applications, modify the additional precession values according to your requirements to support the integration.
  • If you’re using Product Management for the first time, it's recommended that you opt in to the feature. Note that default value for the profile option INV_QUANTITY_DECIMAL_PRECISION is set to 5.
  • If you use Packs in classic interface, note that Quantity doesn’t honor the profile option.
  • For descriptive flexible attributes, the inventory profile option is ignored, decimal precision for these attributes is controlled by the configuration of the associated value set.