A 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?
- Which type of quantities are shown in the Inventory Balances subject area?
- Why isn't the Category Hierarchy data correct? Why can't I see the latest changes?
- Why do I see duplicate rows when including the Item Catalog Category attributes in an analysis?
- Why isn't Inventory Valuation showing any data?
- Why isn't the unit of measure (UOM) conversion showing any data?
- Why isn't the unit of measure (UOM) conversion correct or current?
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?
- 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?
- 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.