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 and later
Information in this document applies to any platform.


On : 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.


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


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
 Fix Instructions for EBS 12.2.x
 Fix Instructions for EBS 12.1.x

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