Fusion OTBI - KPI Formula Filters Not Working

(Doc ID 2306929.1)

Last updated on DECEMBER 14, 2017

Applies to:

Oracle Fusion Application Toolkit - Version 11.12.1.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

Customer has created KPI for reporting workshop for the bank of America project.
The KPI is based on counting the Unpaid invoices. The KPI is returning the complete count of the invoices for the BU but not the unpaid invoices.

Example
BU1 : Total Invoice 20 . Unpaid : 5
KPI returning 20.

Formula used: FILTER(COUNT("- General Information"."Invoice Number") USING ("- Reference Information"."Payment Status Name" = 'Not paid'))

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms