Generate Item UOM Conversions for Primary Units

Use the Generate Item UOM Conversions for Primary Units scheduled process to generate the standard conversions for all existing units of measure that can be primary units on an item, and generate all item specific conversions for each item having any defined.

As an administrator, you can model this data for use with Oracle Fusion Analytics Warehouse extraction.

When to Use

The Generate Item UOM Conversions for Primary Units process should be run once to populate all existing UOM and Item data. Thereafter, it should be scheduled to run whenever new item specific conversions are defined, or in the event new UOM data with standard conversions are added.

Privileges Required

  • Define Sales Forecast (ZSF_DEFINE_SALES_FORECAST_PRIV)
  • Manage Sales Forecast Participant (ZSF_MANAGE_SALES_FORECAST_PARTICIPANT_PRIV)

Specifications

Use these specifications when you run the scheduled process.

Specification Description
Job Type As needed.
Frequency Once to establish the data for existing UOMs and items. Thereafter it should be scheduled based on the frequency of new item specific conversions being created, and how regularly data is extracted to Fusion Analytics Warehouse. If Item specific conversions are defined daily but extraction is done weekly, then the scheduled frequency does not need to be more than weekly.
Time of Day After work hours at 00:00:00 a.m.
Duration Typically less than two minutes for subsequent process requests.
Compatibility There should be only one instance of the process running at any one time and there is no current functional need to run multiple instances of this process at the same time.

Parameters

None.

Troubleshooting Information

  • You can view the status of the process in the Scheduled Processes work area.
  • Errors and warning messages encountered while running the process are displayed in the process log file.