Inventory Transactions Verified When a UOM Conversion is Updated

When you try to change a UOM conversion value, the application will verify if the conversion affects any open transactions.

For intraclass conversions, no transactions can be present using the non-base UOM. For example, when trying to change a conversion between Box and Each for an item that has Each as the primary UOM, no transactions for this item can exist with Box as the transactional UOM.

For interclass conversions, no transactions can exist that use any of the units in the second class because the conversion is between the base units of two classes. It’s valid for every unit in the second class. For example, you have Each and Box in the Quantity class, and Milliliter, Liter, and Gallon in the Volume class. The transactional UOM is often the primary UOM for the item. So let's make that Each. If you have a conversion between Each and Milliliter, and you want to change the conversion, you can’t have any transactions where the transactional UOM is Milliliter, Liter, or Gallon. The conversion is only between Milliliter and Each, but since Milliliter already has its own conversions between itself and Liter, and itself and Gallon, updating the interclass means every element of that class can’t be in used in a transaction.

If the item is found in any transactions as described above, you won't be able to make changes to the conversion. The application will display a message listing the components impacted. This is a list of the inventory transactions that are checked against when a UOM conversion value is updated:

Components Checked

Description

Where Visible

Suggested Action

Existing on hand Stock

Items with on-hand balances in Inventory.

These are visible for the items in the Manage Item Quantities task.

You must issue out on-hand balances for the item prior to updating the UOM conversion.

Pending inventory transactions that aren't processed

Pending unprocessed inventory transactions that exist in the inventory interface.

These are visible in the Manage Pending Transactions page. These transactions are processed by the Manage Inventory Transactions schedule process.

You must process pending inventory transactions and run the Transfer Transactions from Inventory to Costing scheduled process.

Completed inventory transactions that aren't yet costed

Inventory transactions that have been successfully processed in Inventory but haven't yet interfaced to Oracle Fusion Cost Management.

These are visible in the Review Completed Transactions task with the Costed attribute in a Pending status.

You must process pending inventory transactions and run the Transfer Transactions from Inventory to Costing scheduled process.

Inbound shipment lines sent by supplier (ASN) or another inventory org that are yet to be received

These are inbound shipments sent by either a supplier on an PO ASN or a pending receipt from another inventory organization (intra-org transfer, in transit inter-org, or drop ships) and haven't yet been received.

These can be viewed in the Manage Inbound Shipments task.

You must process expected inventory supply prior to updating the UOM conversion.

Received lines yet to be put away

Inbound receipt lines that have been received but haven't been inspected, if applicable, or put away.

Lines that are pending inspection can be viewed in the Inspect Receipts task.

Lines that are pending put away can be viewed in the Put Away Receipts task.

You must process receipt lines awaiting put away prior to updating the UOM conversion.

Outbound shipment lines for a sales order or transfer order that aren't yet shipped

These include outbound shipment lines that are unshipped or shipped but pending inventory interface.

These lines can be viewed in the Manage Shipment Lines task.

You must process open shipment lines prior to updating the UOM conversion.

Pending inventory balance adjustment transactions

These are inventory balance adjustment transactions posted by external systems that aren't yet processed by Oracle Inventory Management Cloud.

These adjustment records exist in the table INV_BALANCE_TXNS_INT.

You must process open inventory balance reconciliation transactions prior to updating the UOM conversion.

Open recall count transactions

If a product is marked for recall, cycle count tasks are created by Supply Chain Health Care for all of the subinventories containing stock for this item. An inventory user needs to perform the count and issue out the material.

These can be viewed in the Manage count task.

You must process open recall count transactions prior to updating the UOM conversion.

Pending cycle count adjustments

After running a cycle count, these adjustments are material transactions that increment or decrement the on-hand quantity of an item based on the physical count entered on the count sequence for that item location.

These are visible on the Approve Count Sequences task.

You must process open cycle count sequences prior to updating the UOM conversion.

Pending physical inventory transactions

After initiating a physical inventory, these are material transactions that adjust the on-hand quantity of an item based on the physical count entered on the physical inventory tag for that item location.

These are visible on the Approve Physical Adjustments task.

You must process open physical inventory adjustments prior to updating the UOM conversion.