1. Reference for Fusion SCM Analytics
  2. Frequently Asked Questions

B Frequently Asked Questions

Refer to these Frequently Asked Questions if you have questions about the behavior of Fusion Analytics Warehouse.

Topics:

Are Backdated inventory transactions considered in the Inventory Balances subject area?

The Inventory Balances subject area doesn't support backdated inventory transactions when calculating period historic balances in Fusion SCM Analytics. If backdated inventory transactions need to be included in Inventory Balances, then reset the data pipeline for the Inventory Balances functional area. See Reset a Data Pipeline for a Functional Area.

Which type of quantities are shown in the Inventory Balances subject area?

Currently, the Inventory Balances subject area supports Regular on hand quantities.

Why isn't the Category Hierarchy data correct? Why can't I see the latest changes?

To ensure that the Category Heirarchy data is correct and reflects the latest changes, manually submit the Oracle Enterprise Scheduler (ESS) job, Refresh Product Hub Snapshots in Fusion Cloud SCM.

Why do I see duplicate rows when including the Item Catalog Category attributes in an analysis?

When building analyses, Fusion Analytics Warehouse uses the Item Catalog Category attributes. You see all the Item Catalog Categories associated for the Item in the analyses. To see specific Item Catalog Categories, use the Item Catalog Category filter.

Why isn't Inventory Valuation showing any data?

There are two possible reasons:
  • You need to set up a new run control for the cost reports processor using the Create Cost Accounting Distributions page in Fusion Cloud SCM, which generates the inventory valuation data.
  • Run the Oracle Enterprise Scheduler (ESS) job, Refresh Cost Accounting Report Data. You can configure this job to run automatically when you run the Create Cost Accounting Distributions process. See Refresh Cost Accounting Report Data in Using Supply Chain Cost Management.

Why isn't the unit of measure (UOM) conversion showing any data?

Run the Oracle Enterprise Scheduler (ESS) job, Generate Item UOM Conversions for Primary Units. This job creates and maintains the set of UOM conversions for the primary unit of measure for every item in Fusion Cloud SCM. This is a prerequisite to see the UOM conversions for the primary unit of measure for every item.

Why isn't the unit of measure (UOM) conversion correct or current?

There are two possible scenarios for an incorrect UOM conversion:
  • Scenario 1: Only Standard UOM conversions initially exist, and the Inter or intra class UOM conversion is defined later in Fusion Cloud SCM.
  • Scenario 2: The UOM conversion is end dated in Fusion Cloud SCM before or after a load happens in Fusion Analytics Warehouse.

In both scenarios, unless you apply the updates to transactions in Fusion Analytics Warehouse, Fusion Cloud SCM won't consider the latest UOM conversion.

Why am I not able to see quantity metrics at subinventory and locator level in the PO Receipts subject area?

All the quantity metrics are at the Receipt line level and not at the Transaction level (Subinventory, Locator) in the PO Receipts subject area.

Why isn't Historic Inventory Balances showing the current month's Inventory Balances?

Historic Inventory Balances show Onhand balance as at 11:59 pm of the last day for the past 11 months in the Inventory Balances subject area.

Why am I not able to see PO number, Supplier, ASN, and other Purchasing and Inventory related document information in the Inbound Details folder in the Inventory Balances subject area?

To view the PO number, Supplier, ASN, and other Purchasing and Inventory related document information under the Inbound Details folder in the Inventory Balances subject area, ensure that the "Purchasing" functional area has been activated.

Why am I not able to see the Project-related details in the SCM subject areas?

To view the Project-related details in the SCM subject areas, ensure that the "Project Costing" functional area has been activated in Oracle Fusion ERP Analytics.

Why am I not able to see quantity metrics at subinventory and locator level in the PO Receipts subject area?

All the quantity metrics are at the Receipt line level and not at the Transaction level (Subinventory, Locator) in the PO Receipts subject area.

Why does the Average Work Order Delay metric in the Manufacturing Work orders (Preview) subject area show an incorrect value when aggregated at the Organization or Item level?

The Average Work Order Delay is computed for Closed and Completed Work orders only. Aggregate and filter this metric for System Status Code as Closed and Completed to ensure that the Average Work Order Delay is computed properly.

Why does the Operation Yield % metric in the Manufacturing Work Orders (Preview) subject area show incorrect values when aggregated at the Organization or Item level?

The Operation Yield % metric is computed for Released, Closed, and Completed Work orders only. Aggregating with the filter for System Status Code as Released, Closed, and Completed ensures that the Operation Yield % metric is computed properly.

Why isn't COSG and Gross Margin subject area showing any data?

There are two possible reasons:

You need to set up a new run control for the cost reports processor using the Create Cost Accounting Distributions page in Oracle Fusion Cloud Supply Chain & Manufacturing, which generates the inventory valuation data.

Run the Oracle Enterprise Scheduler (ESS) job and refresh the Cost Accounting Report data. You can configure this job to run automatically when you run the Create Cost Accounting Distributions process. See Refresh Cost Accounting Report Data in Using Supply Chain Cost Management.

  1. Navigate to the Create Cost Accounting Distribution screen.
  2. Define the Run Control or select an existing Run Control.
  3. Select View, then select Columns, and then click Show All to see the Cost Reports processor.
  4. Enable the Cost Reports processor.
  5. Schedule the newly defined run control.

Which approval date or version does the Purchase Order subject area in Fusion Analytics use?

The Purchase Order subject area in Fusion Analytics uses the original version or first time approval date for analyses or metrics that are used to derive the cycle time metrics. However Oracle Transactional Business Intelligence uses the latest version or last approval date. When comparing the data between Fusion Analytics and Oracle Transactional Business Intelligence, don't use the approval date for analyses because it will provide a different outcome.

Why do Work Order Yield % metrics in the Manufacturing Work orders (Preview) subject area show incorrect values when aggregated at the Organization or Item level?

The Work Order Yield % is computed for Closed and Completed Work orders only. Aggregating with the filter for System Status Code as Closed and Completed ensures that the WO Yield % is computed properly.

Why do I see the metrics multiplied when a Catalog and Functional Area is selected in a report?

When building analyses, Fusion Analytics Warehouse displays the metric at the grain in which it has been designed. For example, Sales Orders are at the Fulfillment line level, therefore adding Catalog and Functional Area will multiply the metric values. To see the correct value of the metric, use the Functional area as a filter and choose an appropriate Functional area value.

Why can't I see the PO receipt amount related metrics in the Inventory Receipts (Preview) subject area?

Metrics related to the PO receipt amount are available in the PO Receipts subject area.

Why can't I see information related to see PO and ASN receipts in the Inventory Receipts subject area?

All receipts information, including PO and ASN receipts, is available in the Inventory Receipts (Preview) subject area. You need to enable Inventory Receipts (Preview) to see all Inventory receipts information.

Why can't I see the Inventory Receipts (Preview) features?

For the Inventory Receipts (Preview) feature to work properly, you need to enable the SCM Purchasing, Inventory, and FA_Receiving subject areas.