My Oracle Support Banner

OBIA 11g: OOTB Spend by Category Value For Total Spend Amount is Less Than Expected, Due to Categories Setup Without A Description In EBS Source (Doc ID 2434335.1)

Last updated on FEBRUARY 16, 2019

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.
E-Business Suite (EBS) source


Categories that are setup in Oracle E-Business Suite (EBS) without any description are not loaded into the data warehouse. Hence the total Spend amount shown in OOTB report Spend by Category is less than the actual spend for the period.

Further analysis found that the W_DOMAIN_MEMBER_LKP_TL is populated from the EBS table - MTL_CATEGORIES_TL, with filter TL.DOMAIN_MEMEBER_NAME is not null.

However, Description is not a mandatory field in the EBS Category setup and any Category setup without a description should be loaded and will be grouped as "UNSPECIFIIED', to report the KPI's correctly.


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

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