View alternate unit of measure conversion quantities when recording cycle and physical counts

Idea Lab

Warehouse operators frequently perform counts in a unit of measure that differs from an item’s primary unit of measure, such as cases, packs, or pallets. When recording cycle count sequences or physical inventory tags, users benefit from immediate visibility into converted quantities for different units of measures. Seeing this information allows them to validate that the entered count aligns with inventory expectations without leaving the transaction flow. Now you can view the unit of measure conversion quantities when recording cycle and physical counts on Redwood pages and the predefined spreadsheets configured using the Oracle Visual Builder plug-in for Excel.

A new collapsible UOM conversions section is available in the following flows:

  • Record Cycle Count pages
  • Mobile Cycle Count pages
  • Mobile Physical Inventory pages
  • Record Physical Inventory Tags in Spreadsheet

The section is hidden and collapsed by default. You can enable it using the UOM Conversions business rule. Once enabled, users can expand the section as needed to view UOM conversion details.

Here's the UOM conversions section on the Record Cycle Count page.

View UOM Conversions in Record Cycle Counts

View UOM conversions on Record Cycle Counts page

Here's the UOM conversions section on the Mobile Cycle Count page.

View Unit of Measure Conversions in Mobile Cycle Count

View UOM conversions on Mobile Cycle Count page

Here's the UOM conversions section on the Physical Inventory pages.

View UOM Conversion in Mobile Physical Inventory Pages

View UOM conversion on Mobile Physical Inventory pages

Here's the UOM conversions section in Record Physical Inventory Tags in Spreadsheet.

View UOM Conversions in Record Physical Inventory Tags in Spreadsheet

View UOM conversions in Record Physical Inventory Tags in Spreadsheet

This feature reduces reliance on external calculations, minimizes ambiguity, and streamlines the review and reconciliation process for inventory accuracy.

Steps to enable and configure

Leverage the Visual Builder Studio to expose your applications. To learn more about extending your application using Visual Builder, visit Oracle Help Center > your apps service area of interest > Books > Configuration and Extension.

Use business rules in Visual Builder Studio to control the visibility and behavior of the UOM Conversions section for these flows:

  • Record Cycle Count pages
  • Mobile Cycle Count pages
  • Mobile Physical Inventory pages
  • Record Physical Inventory Tags in Spreadsheet

To enable the section:

  1. Navigate to the page where you want to display the UOM Conversions section.
  2. Select the Edit Page in Visual Builder Studio task from the Settings and Actions menu.
  3. In Page Properties, locate the UOM Conversions section and set its visibility to Visible.
  4. Publish your changes.

UOM Converisons in Business Rule

UOM conversions in business rule

Tips and considerations

  • You can determine whether you can extend a specific page using Visual Builder Studio by using the Edit Page in Visual Builder Studio task from the Setting and Actions menu.
  • Keep the Pages list closed while you work in Visual Builder Studio Express mode to get a cleaner view of the page you’re extending.

Key resources

Access requirements

To extend application pages using Visual Builder Studio, you must be assigned a configured job role that contains this privilege:

Privilege status Privilege name and code
Existing Administer Sandbox (FND_ADMINISTER_SANDBOX_PRIV)