I just created one simple report by taking Year and Credit Amount column, report gets executed with NO values in Credit Amount column.

This is customized BI Apps rpd.

I get below session log,

[username: weblogic] -------------------- Expression 'Activity Local Amount:[DAggr(Fact - Fins - GL Balance.Activity Local Amount by [ Dim - Date Fiscal Calendar.Fiscal Year Wid, Dim - Date Fiscal Calendar.Year] )]' converted to NULL because [nQSError: 14023] None of the fact sources for Activity Local Amount:[DAggr(Fact - Fins - GL Balance.Activity Local Amount by [ Dim - Date Fiscal Calendar.Fiscal Year Wid, Dim - Date Fiscal Calendar.Year] )] are compatible with the detail filter [Fact - Fins - GL Balance.Debit Credit Indicator = 'CREDIT']. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Dim - Date Fiscal Calendar.Fiscal Year Wid, Dim - Date Fiscal Calendar.Year.

Physical Query :

SAWITH0 AS (select distinct T554878.MCAL_PER_NAME_YEAR as c1,

  T554878.MCAL_YEAR_WID as c2

from

  W_MCAL_DAY_D T554878 /* Dim_W_MCAL_DAY_D_Fiscal_Day */ )

select D1.c1 as c1, D1.c2 as c2, D1.c3 as c3, D1.c4 as c4 from ( select 0 as c1,

  D1.c1 as c2,

cast(NULL as DOUBLE PRECISION ) * -1 as c3,

  D1.c2 as c4

from

  SAWITH0 D1

order by c2 ) D1 where rownum <= 65001

Thanks,

Ajit