My Oracle Support Banner

OBIA : Project Dashboards does not show data for Specific Currency (Doc ID 2322615.1)

Last updated on NOVEMBER 13, 2019

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


OOTB Dashboard prompts or reports are returning no data or showing 'Null' or 'Unspecified'. An example analysis is : "Project Financial Performance Overview" in
"Project management" -> "Project Performance".

Issue is observed in below Environment.

OBIA version : Oracle Business Intelligence Applications Configuration Manager version - Oracle Project Analytics

OBIEE version : Build:

Data Source and version : EBS R12.1.3

Target database version : Oracle 11.2

ODI Version :


Report gives results when column format is set to Number.

but when data format in the column properties is changed to currency like  add [$:currencyTagColumn="Project - Performance"."Currency Code"."BI Common Currency Code"] as a custom numeric format then the result is : no data is found.


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.