Not able to Change the Quantity Precision of the Item Standard UOM from 'Whole Nbr' to 'Decimal' when Using the Catalog Maintenance Functionality and the 'Item Loader' Process (IN_ITMLOAD) (Doc ID 1961261.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Not able to change the Quantity Precision of the Item Standard UOM from 'Whole Nbr' to 'Decimal' when using the Catalog Maintenance functionality and the 'Item Loader' process (IN_ITMLOAD) (see navigation below).

According to the PeopleBooks, such a change should be allowed:

PeopleSoft Enterprise Managing Items 9.1 PeopleBook > Working with Items > Establishing Quantity Precision and Rounding Rules for Items > Understanding Rules used when Rounding

You can always change a whole number precision to a decimal precision, but you cannot always change a decimal precision to a whole number precision. After you complete certain transactions involving the item—any putaway operation, any order placed against the item, or any adjustment—you cannot make this change.



Steps to replicate the issue:

  1. Search for an Item with a UOM Quantity Precision of 'Whole Number'.
  2. Go to: SCM Integrations, Setup, Catalog Maintenance Template.
  3. Create a Template and use Record INV_ITM_UOM_EC and Field QTY_PRECISION.
  4. Go to: SCM Integrations, Process Transactions, Items, Catalog Maintenance Extract.
  5. As selection criteria, use Record INV_ITM_UOM make sure your Item is going to be selected.
  6. Go to: SCM Integrations, Process Transactions, Items, Catalog Maintenance Update.
  7. Update the value of Record INV_ITM_UOM_EC and Field QTY_PRECISION to 'D' (Decimal).
  8. Go to: SCM Integrations, Process Transactions, Items, Item Loader.
  9. Run the 'Item Loader' process (IN_ITMLOAD) for the Item Load Type of 'Item Export', your Template, and all EIP_CTL_IDs.
  10. Verify the Item UOM Quantity Precision > it's still set to 'Whole Number'.

Changes

 

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