My Oracle Support Banner

OBIA 11g: Custom Reports with Aging Bucket Dimension and Specific Facts Return NULL Values (Doc ID 2119992.1)

Last updated on DECEMBER 02, 2016

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

In the Financials - AR Overview subject area, see the Aging Bucket dimension and many facts such as Facts - AR Aging, Facts - AR Invoice Aging, Facts - AR Transactions, Facts - AR Payment Performance etc.

When a custom report is created with attribute columns from Aging Bucket and measure columns from specific facts (such as Facts - AR Aging or Facts - AR Invoice Aging), see the measure columns in the results contain non-NULL values.

When a custom report is created with attribute columns from Aging Bucket and measure columns from specific facts (such as Facts - AR Transactions or Facts - AR Payment Performance), see the measure columns in the results contain NULL values.

(The observed behavior is the same with the Financials - AP Overview subject area.)

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
Cause
Solution
References


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