Autocreate UOM Conversions When Adding a Packaging String to an Item

Prior to this update, to define the item-specific intraclass UOM conversions, you had to follow a two-step process:

  1. Make sure the item is created in the Product Information Management work area.
  2. Populate the computed UOM conversion using the Manage UOM Intraclass Conversions page in the Setup and Maintenance work area.

In this update, you can define item-specific intraclass UOM conversions in a single step by assigning a packaging string to the item when the item is created or updated. When saving the item record, based on the item’s packaging string definition, Oracle Product Hub automatically stores the item-specific UOM conversion for every UOM present in the packaging string. For example, if you assign the packaging string Ea 12/CRD 5/PK 4/CTN to the item RXJY 17 mg Tablet, then Product Hub adds the following item-specific UOM conversions to the database:

Item

From UOM

To Base UOM (Each)

RXJY 17 mg Tablet

Card

12

RXJY 17 mg Tablet

Pack

60

RXJY 17 mg Tablet

Carton

240

The autocreated item-specific conversion will be available in the Manage UOM Intraclass Conversions page in read-only mode. If you want to change the conversion factors, you must modify the packaging string assignment to the item as needed.

The following image shows a packaging string assigned to an item when the item is being edited.

Edit Items Page – Packaging String Assigned to an Item

Edit Items Page – Packaging String Assigned to an Item

The following image shows the conversions for the packaging string on the Manage UOM Intraclass Conversions page.

Manage UOM Intraclass Conversions Page – UOM Conversions for Packaging String

Manage UOM Intraclass Conversions Page – UOM Conversions for Packaging String

This feature benefits your business by the following:

  • Product Data Steward can perform their job more effectively and with greater efficiency because they can specify the packaging string and create intraclass UOMs when the item is created or updated.
  • Reduces superfluous navigation steps by eliminating the need to create the intraclass UOMs in the Setup and Maintenance work area.
  • Creates a new reporting table with various UOM entries to enable improved reporting by leveraging these values, which will be tailored to the specific needs of each business unit.
  • Reports actionable insights faster for downstream processes (for example, Inventory, Order  Management, Purchasing, and so on.)

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Product Management

Tips And Considerations

  • To use the Autocreate UOM Conversions When Adding a Packaging String to an Item feature, then you must opt in to the following features:

    • Create Packaging Strings for Items.

    • Calculate Runtime Transaction UOM Conversions with Generated Item Data (parent feature of the Autocreate UOM Conversions When Adding a Packaging String to an Item feature). 

Note: If you’ve already opted in to the preceding features, you don’t have to opt in again.

  • After availing this feature, if you update a packaging string assignment for an item, the update must meet the data validation constraints as detailed in the Calculate Runtime Transaction UOM Conversions with Generated Item Data What's New.
  • If you aren’t availing this feature, Oracle Product Hub won’t autocreate the item-specific UOM conversion even if you assign a packaging string to the item.

Key Resources

Access Requirements

Users who are assigned a configured job role that contains this privilege can access this feature:

  • Manage Item (EGP_MANAGE_ITEM_PRIV)

This privilege was available prior to this update.