My Oracle Support Banner

OBIA 11g: Inventory Product Categories Are Not Loaded, Instead It Shows Only Zeros (Doc ID 2520935.1)

Last updated on APRIL 15, 2021

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.10.2 version, DataWarehouse

Inventory Product Categories are not loading correctly:

All the inventory Product categories are not loaded during Full / Incremental data load. This is causing many of the reports to show incorrect results. Even after trying with both full and incremental data load; the inventory categories does exist in the source table but its not loading to the Data Warehouse staging and dimension tables.

Changes

No customization done to logic except adding new columns added following Oracle recommendation articles.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 Fix Instructions for EBS 12.2.x
 Fix Instructions for EBS 12.1.x
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.