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

Inventory Frequently Asked Questions

The Oracle Fusion SCM AnalyticsInventory Frequently Asked Questions (FAQs) provide answers to the most commonly asked questions about your Inventory analytics experience.

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 Data Intelligence 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 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 Data Intelligence.

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

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 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 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 the Inventory Receipts (Preview) features?

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

Why does Receiver Name column in Inventory Receipt and Inventory Receipts (Preview) subject areas showing error?

The Receiver Name attribute is deprecated in the Inventory Receipt and Inventory Receipts (Preview) subject areas. Instead, you can use the Received By attribute which is added in the Inventory Receipt and Inventory Receipts (Preview) subject areas in the 23.R3 release.

Why can't I see the Inventory Receipts Analysis dashboard features?

To activate the Inventory Receipts Analysis dashboard and data visualization features, enable the Inventory Receipts (Preview) functional area in the Console Preview features area.

Why isn't the Inventory Turns subject area showing Onhand Quantity, Sales Quantity, Historic Balances, and Transactions for items over 1+ years of age?

The Inventory Turns subject area currently shows Onhand Quantity, Sales Quantity, Historic Balances, and Transactions for items only for the past 365 days.

Why do I see duplicate records for an item number when creating an analysis based on prebuilt Subject Area Inventory Balances / Inventory Item / Item column?

This is expected behavior if data is deleted from Fusion Applications. This shouldn't create any issues on your report if you report on the data based on the correct keys. When analyzing on the dimension only, remove or clean stale data, then perform a hard reset and reload the data.